The current description says that the load balancer is for read-only operation. Does that mean that MySQL Load Balancer will not accept update statements for the slaves?
No. Currently, the MySQL Load Balancer doesn’t prevent you from making modifications on the slaves. The read-only description is being used to indicate that you should only use this solution for sending queries to existing slave hosts.15.6.5.2: The MSQL Load Balancer is listed as being ‘slave state aware’. Do you check the status of both threads in the replication process.Yes. the monitor module runs SHOW SLAVE STATUS and checks the status of the replication process. If there is a problem, either because the slave has lagged too far behind the master, or because the query thread has stopped, then the slave will be taken out of the list of available slaves for distributing queries.
Related Questions
- The current description says that the load balancer is for read-only operation. Does that mean that MySQL Load Balancer will not accept update statements for the slaves?
- Can I reset the load balancer (LB) cookie with a POST operation during authentication?
- What does qualified mean in a product description?