New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
MySQL Cluster / Replication
Mahfuz_SS_EHL
Host Rep, Veteran
in Help
Hello,
Is it possible to replicate MySQL Database in 2 or more servers live ??
I mean, suppose, you have Server 1 - Server 2 - Server 3 with MySQL/MariaDB installed & running. Server 1 is being used primarily but each & every data, table needs to be replicated or inserted to Server 2 & 3 automatically & vice-versa.
If anyone has any experience, please share.
Regards.
Comments
Yes, it is possible via the Master, Slave, Slave concept. And I suggest you go with MariaDB Galera or Percona XtraDB as they are easy to maintain.
👍 right
In your setup if master server get downtime whole project will crash, much better to get master to master to master setup so data will be updated automatically and if one server will be down no issues with that.
Downside of master-master replication is that writes become slower since each one needs an ACK from multiple masters.
Downside of master-slave is that if master dies, project goes read-only (you can still read from slaves/replicas).
Pick your poison.
edit: apparently there's another master-master scheme with fast writes that foregoes some ACID guarantees. Again, just another poison.
Just to shit post a little.