Setting up replication is not hard as long as all the various bits are in place. This recipe is all about the most basic concept of replication topologies; a single master server replicating to multiple slaves is shown in the following diagram:
This recipe assumes that we have three servers. The servers are named
db03, and they reside on the
192.168.4.0 network with IP addresses
192.168.4.103. One server,
db01, will be our replication master, and the other two will be our replication slaves.
For the purposes of this recipe, the servers are assumed to contain fresh installs of MariaDB, ...