Since MariaDB is a fork from MySQL, the syntax is similar, but MariaDB has several additional features. Basic SQL syntax remains the same, but MariaDB handles data storage and functions differently.

Prior to release 5.1, MySQL replication was statement-based, meaning that the actual SQL commands were replicated from the master to one or more slaves. However, certain use cases did not lend ...