MariaDB TX replication supports advanced configuration options: enhanced semi-synchronous replication for consistency, optimistic parallel replication for performance, delayed replication for disaster recovery, read throttling for reduced load, binlog compression for reduced IO and more. In addition, multi-master clustering is supported, and can be combined with replication to create tiered topologies.

MariaDB TX now supports automatic failover via its database proxy, MariaDB MaxScale. If automatic failover is enabled and the master fails, it will automatically promote the most up-to-date slave. If the previous master is recovered and automatic rejoin is enabled, it will automatically configure it as a slave. In addition, DBAs can now issue a command to perform a switchover on demand.

MariaDB MaxScale, as a database proxy, enables DBAs to add or remove database nodes on demand – applications are not impacted because topology changes are transparent to them. MariaDB MaxScale will automatically route queries to the right database nodes when the topology changes, regardless of whether there was an automatic failover or a new database node was added.

MariaDB MaxScale includes a built-in database firewall and result set limiting to prevent malicious users from reducing database availability via denial of service attacks – excessive repetitive queries or queries returning excessive results (e.g., millions of rows).

MariaDB TX includes backup/restore tools with encryption and compression support as well as point-in-time rollback. MariaDB Flashback enables DBAs to recover data faster by rolling back transactions to a previous point in time rather than performing a restore from a backup.