My question is simple :
- I have 2 servers, both are identical with proxy, apache, MariaDB,...etc.
- I have one IP Failover : the IP is routing to my first server but if this server falls down I will change the routing to the second server.
I try to install MariaDB Galera Cluster but is there a real advantage ?
In fact, I would like to know what kind of replication I have to use for MariaDB between both server for my use :
- MariaDB Galera Cluster
- Standard replication Master-Master
- Standard replication Master-Slave
And why ?
Thank you.
[EDIT]
If I install MariaDB Galera Cluster, I have 2 solutions :
I can do 2 virtual servers on each 2 servers and I will have one node on each virtual servers so 4 nodes.
I can do one node on each 2 servers so 2 nodes but it seems I have to install Galera Arbitrator, that's right ? But do I need a third server for that ?
What is the best way ?