Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


MySQL Cluster / Replication
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.

MySQL Cluster / Replication

Mahfuz_SS_EHLMahfuz_SS_EHL Host Rep, Veteran

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.

  • dedicatserver_rodedicatserver_ro Member, Host Rep

    @imgmoney said: MariaDB Galera

    👍 right

  • WebProjectWebProject Host Rep, Veteran

    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.

  • wotetiwoteti Member
    edited July 2021

    @WebProject said:
    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.

  • JabJabJabJab Member
    edited July 2021

    Just to shit post a little.

    The terms master and slave have historically been used in replication, but the terms terms primary and replica are now preferred. The old terms are used throughout the documentation, and in MariaDB commands, although MariaDB 10.5 has begun the process of renaming. The documentation will follow over time. See MDEV-18777 to follow progress on this effort.

    Thanked by 1vedran
Sign In or Register to comment.