MySQL: 3 servers on-site architecture I have 3 servers with RHEL 6 OS and Percona server running in one of the servers in the same data centre, while the other 2 servers lie idle.

Now I need to implement some kind of on-site redundancy (high-availability) for my databases.

What is the best option we got here? I want to go for Percona cluster but I don't want to since there aren't people who cannot manage the same.

Any other options?

Master and two slaves?
Two Masters (Active-Passive) and One slave?

Need inputs here.
These are your options:


1 master with 2 slaves, standard replication. If you have long running or massive transactions you may want to stick with this.
1 master with 2 slaves + MHA to handle failover
2 masters (active-passive) with 1 multi-source replicating slave. Just to emphasize active-passive masters
3 node Percona XtraDB Cluster/MariaDB Galera Cluster, avoid these if you have long running or big transactions.
3 node PRM cluster


Others might have a better answer but IMHO these are good options.