Protected: MariaDB: replication, recovering and switching for Master-Slave mode.

MySQL Master-Slave type replication is often used to provide application resiliency. In addition, it allows you to distribute the load on the database between several servers (replicas).

Master Slave Flow

Of course, it is Linux of family of CentOS7+

Configuring of replication takes place in several steps. We will use two servers with addresses: 10.90.100.31 and 10.90.100.32

Case 1 - Beginning.

Configuring the Master. If this is 'fresh' installation, on the server that will act as the master, you need to make changes in additional files of configuration in /etc/my.cnf.d: Settings of character sets for Master/Slave:

This content is password protected. To view it please enter your password below:

Scroll to top