Galera topology is available on MariaDB SkySQL in GCP to provide a low-management overhead cloud database solution for users of MariaDB Enterprise Cluster, MariaDB Cluster, or Galera Cluster.
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.
Galera Cluster provides certification-based replication for InnoDB.
MariaDB MaxScale provides load balancing, HA, and automatic failover.
The Galera topology on SkySQL delivers the following features:
MariaDB Enterprise Server 10.5 or 10.4
Zonal SSD Persistent Disk
Number of Instances
3, 5, 7, or 9 cluster nodes
Number of MaxScale Instances
1 to 2
MariaDB MaxScale-powered Load Balancing
MariaDB MaxScale-powered Failover
The Galera topology uses Zonal SSD Persistent Disk, the ACID-compliant InnoDB storage engine, and Galera Replication for High Availability (HA).
This topology features 3, 5, 7, or 9 cluster nodes. MariaDB MaxScale is used for load balancing, automatic failover, and read scaling through read/write splitting. MaxScale selects one node to operate as the Primary Server and treats the other nodes as Replica Servers.
For additional information on ES instance options, see "Galera Instance Sizes".
For additional information on MaxScale instance options, see "MaxScale Redundancy".
This topology does not enable access to specific individual nodes.
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. MariaDB Enterprise Cluster, powered by Galera, depends on InnoDB.
These questions and answers pertain to the Galera 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 configurable?
Is inbound replication supported?
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 Galera topology, SkySQL Monitoring includes server-level and service-level monitoring, Galera 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.