HA (Primary/Replica)

The HA (Primary/Replica) topology is available on MariaDB SkySQL on AWS and GCP to meet the demands of 24 hours a day, 7 days a week, 365 days a year operation for production transactional workloads.

Component View

MariaDB Platform for Transactions (HA - Primary/Replica)

In this service:

  • MariaDB Enterprise Server provides a modern SQL RDBMS with high availability, pluggable storage engines, hot online backups, and audit logging.

  • InnoDB provides a row-based storage engine for ES that delivers excellent performance for transactional or online transactional processing (OLTP) workloads.

  • MariaDB Replication provides asynchronous or semi-synchronous replication for ES.

  • MariaDB MaxScale provides load balancing, HA, and automatic failover.

Service Details

The HA (Primary/Replica) topology on SkySQL delivers the following features:

Topology

HA (Primary/Replica)

Service

MariaDB Platform for Transactions

Workload Optimization

Transactional

Server

MariaDB Enterprise Server 10.5 or 10.4

Storage Engine

InnoDB

Storage

EBS Provisioned IOPS (AWS)
Zonal SSD Persistent Disk (GCP)

Number of ES Instances

1 Primary
1-5 Replicas

Number of MaxScale Instances

1 to 2

Replication

Asynchronous MariaDB Replication

Load Balancing

MariaDB MaxScale-powered Load Balancing

Failover

MariaDB MaxScale-powered Failover

Production-Ready

Yes

Development/UAT-Ready

Yes

The HA (Primary/Replica) topology uses EBS Provisioned IOPS disk (AWS), Zonal SSD Persistent Disk (GCP), the ACID-compliant InnoDB storage engine, and replication for High Availability (HA).

This topology features one Primary and 1 to 5 Replicas. MariaDB MaxScale is used for load balancing, automatic failover, and read scaling through read-write splitting.

For additional information on ES instance options, see "HA Instance Sizes".

For additional information on MaxScale instance options, see "MaxScale Redundancy".

Primary and Replicas are deployed in different zones within a region to provide isolation and to protect from physical failures. Cross-region replicas for Disaster Recovery (DR) are available on GCP for Power Tier customers.

This topology does not enable access to specific individual nodes.

Custom MaxScale configuration in the Configuration Manager may be applied only to the HA (Primary/Replica) topology on GCP.

InnoDB is the supported storage engine for customer-created tables in MariaDB Platform for Transactions services, which are dependent on the enhanced capabilities and compatibility of InnoDB for transactions, backups, crash recovery, replication, and other features.

Screenshots

Launch interface highlighting Transactional Service
Launch interface highlighting Primary/Replica selector

FAQ

These questions and answers pertain to the HA (Primary/Replica) topology.

For a complete list of questions and answers, see the SkySQL Frequently Asked Questions (FAQ) list.

What features does MariaDB Enterprise Server provide?

Features of MariaDB Enterprise Server include:

  • Enterprise-optimized builds with backports of critical fixes, improved code stability, and enterprise enhancements.

  • Compatibility with most programming languages and clients that work with MariaDB or MySQL, for off-the-shelf integration to your stack.

  • Online schema changes with InnoDB's Instant ALTER.

  • MariaDB Enterprise Audit for enhanced audit logging.

  • MariaDB Enterprise Backup for hot online backups.

What is the SLA?

See Service Availability (SLA) for complete details. Short answer, HA (Primary/Replica) topologies deliver 99.95% for most customers, and an elevated 99.995% for Power Tier customers.

What is configurable?

At time of service launch, region, instance sizes and storage sizes, MariaDB Enterprise Server version, and replica count are configurable.

After launch, MariaDB Enterprise Server and MariaDB MaxScale are configurable using SkySQL's Configuration Manager. A full list of configurable parameters is available.

Is inbound replication supported?

Inbound replication (to MariaDB SkySQL) is available. Additionally, cross-region replicas for disaster recovery are available to Power Tier customers.

How are backups performed?

Automated nightly backups are performed with MariaDB Enterprise Backup, which enables hot online backups. MariaDB Enterprise Backup breaks up backups into non-blocking stages so writes and schema changes can occur during backups.

How do I monitor my database?

SkySQL Monitoring provides real-time status and metrics. For the HA (Primary/Replica) topology, SkySQL Monitoring includes server-level and service-level monitoring, replication monitoring, and monitoring of the MariaDB MaxScale load balancer.

What support is available?

While all SkySQL instances include Standard Support, enhanced support plans are available to meet the needs of mission-critical deployments requiring 24x7 support. Enterprise and Platinum support plans are optional.

An option available to customers with Enterprise or Platinum support plans, SkyDBA further extends the premium support experience and the capabilities of your in-house DBAs with the backing from a global team of expert MariaDB DBAs, available 24/7 for the most severe (S1) issues. MariaDB's SkyDBAs manage your MariaDB SkySQL databases both proactively and reactively so you can focus on your core business.

What if I have other requirements?

SkySQL Power Tier is a premium service offering for MariaDB SkySQL customers who have the most critical requirements for uptime, availability, performance, and support.