# Bit confused with Percona master-slave method vs Percona Xtradb cluster to use in bank services?

**URL:** <https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841>\
**Category:** Percona XtraDB Cluster\
**Created:** [August 1, 2020, 3:29pm UTC](https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841 "2020-08-01T15:29:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)\
**Post date:** [August 1, 2020, 3:29pm UTC](https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841/1 "2020-08-01T15:29:56Z")

</div>

Actually I don’t want any&nbsp; 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.&nbsp;

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [August 2, 2020, 8:39am UTC](https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841/2 "2020-08-02T08:39:35Z")

</div>

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/](https://www.percona.com/blog/2016/06/07/choosing-mysql-high-availability-solutions/ "Link: https://www.percona.com/blog/2016/06/07/choosing-mysql-high-availability-solutions/")

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 3, 2020, 6:56am UTC](https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841/3 "2020-08-03T06:56:49Z")

</div>

[@lokesh123](https://forums.percona.com/profile/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

---

<div class="post-metadata">

**Author:** ![MirSos](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MirSos](https://forums.percona.com/u/MirSos)\
**Post date:** [August 4, 2020, 5:50am UTC](https://forums.percona.com/t/bit-confused-with-percona-master-slave-method-vs-percona-xtradb-cluster-to-use-in-bank-services/7841/4 "2020-08-04T05:50:09Z")

</div>

You may set up virtual IP to check database, if virtual IP can’t connect, he change host to another. But&nbsp;HAProxy or ProxySQL are better solution
