An overview of replication
MariaDB supports built-in replication. This feature is one of the most ancient and an advanced MariaDB feature. The first version of the code saw the light in MySQL 3.23.15, in May 2000. At that time, MySQL did not even include InnoDB, and did not support important features such as views or the UNION statement. Of course, the first version of replication was quite poor. Basically, a master just logged SQL statements and sent the log entries to the slaves. However, the age of this feature reveals how stable it is nowadays.
MariaDB replication is based on the binary log. The binary log keeps track of the events that modify the databases. The binary log supports three formats:
STATEMENTROWMIXED
With the STATEMENT format, events are all SQL statements that do or could modify some data. With the ROW format, events are all modifications that occur as a consequence of such statements. The MIXED format records the statements when possible, but it can also record the...
