Configuring replication
In this section we will see which configuration parameters are required on the master and slave servers.
All the following explanations also apply to the multisource replication environments. However, there are some differences that will be explained after the common tasks.
Setting up a replication environment requires at least the following steps:
Configuring a new replication master
Configuring one or more replication slave
Loading data from the master
Starting the slave
Checking if the slaves are running
These tasks, along with other useful topics, will be explained in this section.
Configuring a new replication master
When setting up a replication environment, the first thing to do is of course to set up at least one master. This is an easy task, as the master is just a normal MariaDB server that has a unique ID and maintains a binary log.
First, a server ID needs to be set on all masters and slaves. The server ID needs to be unique. It must be an integer value of 4 bytes...