Related

Product Now Available: Managed MySQL Databases Product
"Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7 Question Question
MSQL does not start and is down Question Question

Question

default my domain fetch data from slave server but when it is down it automatically starts fetching database from master server.

Posted August 22, 2019 749 views
CentOSMySQLDatabases

I have configured mysql master-slave replication in centos 7, and I want to use this in such a way that by default my domain fetch data from slave server but when it is down it automatically starts fetching database from master server.

Add a comment
piyushkumar
By:
piyushkumar

Related

Product Now Available: Managed MySQL Databases Product
"Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7 Question Question
MSQL does not start and is down Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
bobbyiliev August 23, 2019

Hello,

You would need either load balancer or logic built into your application in order to load balance the connections to the different replicas.

If you decide to use a load balancer, you could have a look at one of the following:

  • ProxySQL

  • MariaDB MaxScale

  • HAProxy

  • DigitalOcean managed load balancer

Hope that this helps!
Regards,
Bobby

Reply Report

Related

Looking for something else?

Ask a new question Search for more help