Summary

In this chapter, we discussed how the replication works in MariaDB.

Implementation details about the replication threads and logs have been provided. We discussed how to rotate the binary log. While this rotation is needed even on the server that does not make use of the replication, the DBA should normally make sure that no file is deleted even if at least one slave still needs it.

We learned how to set up a master, a slave, and a slave who also acts as a master. We learned how to load the initial data into a slave and into a new master. We also learned how to verify if the replication is working properly and some hints were provided to identify and solve the most common replication troubles.

In the next chapter we will discuss table partitioning.