The update makes the MariaDB cloud database ready for high availability workloads.
Open source database vendor MariaDB has updated its SkySQL cloud database platform with new capabilities. The company announc ed the general availability of the new version in a blog post this week.
Naman Shah, Senior Product Manager, MariaDB, detailed the new release. “We are pleased to announce the general availability of the Distributed SQL database service on MariaDB SkySQL,” he wrote.
“Distributed SQL, powered by MariaDB Xpand, partitions data into slices and synchronously writes data to scaled-out database nodes,” hah explained. “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.”
Shah added that this SkySQL release uses the Performance Topology for Distributed SQL where MariaDB MaxScale provides load balancing and high availability failover for MariaDB Xpand nodes.
Introducing: Zone Awareness
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, according top Shah.
Xpand on SkySQL distributes redundant copies in different zones within a cloud region. Even if an entire zone fails, the customer doesn’t lose data because SkySQL stores at least one copy of the data in another zone. The company calls this “Zone Awareness.”
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 to spread across zones in a cloud region for higher availability.
The SkySQL Distributed SQL service is currently available on GCP and AWS.