- About Us
When it comes to databases, high availability (HA) and disaster recovery (DR) should not require expensive options, separate software or complex application code. HA/DR should come out of the box. It should be built-in, configurable and easy to use.
MariaDB TX high availability options include master/slave replication, multi-source replication, multi-master clustering or any combination thereof – to help DBAs reduce planned and unplanned downtime.Download the guide
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.
The example topology below uses multi-master clustering with synchronous replication and splits reads and writes – routing all writes to a single node (chosen by the database proxy) and routing all reads to the other nodes (with load balancing).
This recorded webinar will explore high availability strategies and their impact on performance and consistency, explain how replication and clustering work in MariaDB TX and introduce the new automatic failover/rejoin capabilities.watch now
MariaDB TX offers high availability options including master/slave replication, multi-source replication, multi-master clustering or any combination thereof – to help DBAs reduce planned and unplanned downtime.read more