Actually I don’t want any database server fail which stop my bank services. I want virtual IP which move all my server traffic to alive node automatic master-master concept with master slave.
Hi @lokesh123
master-slave is non cluster (active-passive) solution with non-synchronous replication and
XtraDB is cluster solution with synchronous.
Below link may help you.
https://www.percona.com/blog/2016/06/07/choosing-mysql-high-availability-solutions/
1 Like
@lokesh123
Neither Master-Slave nor Percona XtraDB Cluster manages Virtual IP by themselves. You need to have a load-balancer or a proxy in front of a cluster. We recommend to use HAProxy or ProxySQL
1 Like
You may set up virtual IP to check database, if virtual IP can’t connect, he change host to another. But HAProxy or ProxySQL are better solution
1 Like