We are pleased to announce the general availability of the Distributed SQL database service on MariaDB SkySQL cloud database. Distributed SQL, powered by MariaDB Xpand, partitions data into slices and synchronously writes data to scaled-out database nodes. Since data can be read from and written to multiple nodes, Distributed SQL brings linear read and write scale while maintaining strong consistency and ACID compliance for transactions.
This SkySQL release uses the Performance Topology for Distributed SQL where MariaDB MaxScale provides load balancing and high availability failover for MariaDB Xpand nodes.
The SkySQL Distributed SQL service is currently available on GCP and AWS. When launching a new service, you can select from 3, 6, 9, 12, 15 or 18 Xpand nodes. Once a service is running, you can also scale out or in, again in multiples of 3 nodes, to meet your varying workload demands. Finally, you can select from 2 to 5 MaxScale nodes for load balancing, redundancy, and max connection scaling.
Launch a Distributed SQL service in SkySQL on GCP or AWS
Launch a Distributed SQL service with up to 18 Xpand nodes and 5 redundant MaxScale instances
Zone Awareness for Distributed SQL
MariaDB Xpand can tolerate single node failures because Xpand stores redundant copies of data across multiple database nodes. Distributed SQL takes this a step further as Xpand on SkySQL distributes redundant copies in different zones within a cloud region. Even if an entire zone fails, no data is lost because at least one copy of the data is stored in another zone. We call this Zone Awareness.
Data slices are distributed across cloud zones to improve availability
General Availability of Galera Topology
Galera on SkySQL provides a certification-based replication solution for InnoDB transactional workloads. This service is now Generally Available on GCP.
When launching a Transactions service with the Galera topology, you can configure 3, 5, 7 or 9 cluster nodes improving the read scalability of your service. All Galera nodes use the same instance types and are spread across zones in a cloud region for higher availability.
Similar to other multi-node SkySQL services, the Galera topology leverages MaxScale for load balancing, failover and read scaling.
Launch a Transactions service in the Galera topology
MariaDB MaxScale is an advanced database proxy providing high availability, security and integration capabilities to all multi-node SkySQL services. To best support the needs of mission-critical production workloads, MariaDB SkySQL now includes a MaxScale Redundancy option which deploys multiple MaxScale load balancers for high availability.
When launching a Transactions service in HA (Primary/Replica) or Galera topologies, or an Analytics service, you can select two MaxScale nodes to improve the fault tolerance of your services. When launching a Distributed SQL service, you can select from 2 to 5 MaxScale nodes to improve redundancy and scaling of concurrent connections. You also have an option to select the MaxScale instance size. While one MaxScale instance is included at no additional cost, redundant MaxScale instances will be shown as a separate line item.
Launch a Transactions service with HA with 3 replicas and MaxScale redundancy
New SkySQL Features on AWS
User-configurable Provisioned IOPS
SkySQL uses Provisioned IOPS volume types on AWS to provide a predictable, high performance storage option. When launching a new service in SkySQL on AWS, you can provision IOPS per GB of selected storage. The SkySQL Portal will show the estimated cost of Provisioned IOPS as a separate line item.
Launch a Transactions service with HA (Primary/Replica) on AWS with 1000 GB Storage and 10 IOPS per GB
Support for AWS PrivateLink
AWS PrivateLink provides private connectivity between your VPCs and SkySQL services on AWS. PrivateLink offers the benefits of reduced network latency and improved security, and is easy to scale and maintain.
Private connectivity between SkySQL services and your VPC
Try MariaDB SkySQL Today
We are excited about this major feature-rich release of MariaDB SkySQL and hope you’ll give it a spin.
Sign up for MariaDB SkySQL today.