SkySQL Replication Options

This page details a number of topics related to "replication", including MariaDB SkySQL services and features.

If there is any aspect of SkySQL service that doesn't meet your requirements, please contact us.

Transactional Services

  • MariaDB Platform for Distributed SQL uses MariaDB Xpand. This distributed service is strongly consistent and synchronous.

  • MariaDB Platform for Transactions in a Galera topology uses MariaDB Enterprise Cluster, powered by Galera. This replicated service uses virtually-synchronous certificate-based replication.

  • MariaDB Platform for Transactions in a HA (Primary/Replica) topology uses MariaDB Replication. This replicated service uses asynchronous or semi-synchronous replication.

For additional information, see "Services".

Inbound and Outbound Replication

Inbound replication means replication to MariaDB SkySQL.

Outbound replication means replication from MariaDB SkySQL.

Typical Use Cases

  • Offsite replica for Disaster Recovery (DR)

  • Dedicated replica for reporting workloads

  • Migration cutover to SkySQL, such as Lift and Shift

Inbound/Outbound with Distributed SQL

MariaDB Platform for Distributed SQL supports inbound and outbound replication with:

  • MariaDB Server 10.3

  • MariaDB Server 10.4

  • MariaDB Server 10.5

  • MariaDB Xpand 5.3

  • MySQL 5.7

GTID (Global Transaction ID) is not supported.

Character set must be the same on primary (master) and replica (slave). Collation must be the same on primary (master) and replica (slave).

For additional information, see "SkySQL Replication Operations".

Inbound/Outbound with Transactions

MariaDB Platform for Transactions supports inbound and outbound replication in the HA (Primary/Replica) and Galera topologies.

The supported versions for replication depend on:

  • The MariaDB Enterprise Server version used by the SkySQL service

  • The direction of replication (inbound or outbound)

When the SkySQL service uses ES 10.5 and replication is inbound, the following versions are supported for the external primary server:

  • MariaDB Server 10.2

  • MariaDB Server 10.3

  • MariaDB Server 10.4

  • MariaDB Server 10.5

  • MySQL 5.7

When the SkySQL service uses ES 10.5 and replication is outbound, the following versions are supported for the external replica server:

  • MariaDB Server 10.5

When the SkySQL service uses ES 10.4 and replication is inbound, the following versions are supported for the external primary server:

  • MariaDB Server 10.2

  • MariaDB Server 10.3

  • MariaDB Server 10.4

  • MySQL 5.7

When the SkySQL service uses ES 10.4 and replication is outbound, the following versions are supported for the external replica server:

  • MariaDB Server 10.4

  • MariaDB Server 10.5

For additional information, see "SkySQL Replication Operations".

Cross-Region Replicas

With Cross-Region Replicas for DR, data is replicated from a MariaDB Platform for Transactions service in Transactional Standalone or HA (Primary/Replica) topology to a different supported region.

For additional information, see "Cross-Region Replicas".

HTAP Replication

HTAP Replication is a feature of MariaDB Platform for Smart Transactions which selectively replicates row-based transactional data to a column-based data store, enabling real-time analytics.

For additional information, see "MariaDB Platform for Smart Transactions".