Oracle recently took another step forward towards the improvement of MySQL with the release of MySQL Cluster 7.2. The release comes chock full of improvements that further enhance MySQL Cluster’s core characteristics of offering low latency, high write scalability, and so-called “99.999% availability” in a cost-effective manner.
Customers seeking flexibility get that and more with MySQL Cluster 7.2, as its new Memcached API offers both SQL and NoSQL access. This gives customers the “best of both worlds,” so to speak, allowing them to conveniently execute key value operations and complex queries all from the same database.
Scalability has been enhanced in various ways, beginning with enhanced active/active replication that makes it easier for developers to detect and resolve conflicts across multiple clusters and eliminates the need for timestamp columns in applications. MySQL Cluster 7.2’s multi-site clusters allow for the existence of individual data notes in different data centers with the automatic sharding of databases between them. Additionally, data consistency and integrity among sites is maintained with quick automated failover and recovery via synchronous replication.
MySQL Cluster’s performance has become even better in version 7.2. The product promises up to 70x higher performance when executing complex queries thanks to adaptive query localization. This breakthrough allows more applications to leverage the power of real-time analytics across live data sets as well as other features offered under MySQL Cluster’s umbrella.
While previous versions of MySQL Cluster have been deemed user-friendly, version 7.2 takes things one step further by implemented shared user privilege tables. These tables consolidated previously distributed tables into the data nodes to allow access from all MySQL servers, making life easier for administrators. No longer do they need to define and maintain privileges on separate SQL nodes accessing the cluster.
The final improvement featured in MySQL Cluster 7.2 that’s worth mentioning is Oracle VM certification, which makes it an appealing choice for customers seeking a cloud deployment solution for communications and web applications. The inclusion of Oracle VM certification adds to pre-existing MySQL Cluster certifications with Oracle Linux and Oracle Solaris.
Beyond the release of MySQL Cluster 7.2, Oracle also announced the availability of MySQL Cluster Manager 1.1.4. Just as with MySQL Cluster 7.2, the latest release of Cluster Manager has been enhanced to make using and administering MySQL Cluster easier.
Tomas Ulin, Oracle’s VP of MySQL engineering, commented on the latest release: “MySQL Cluster 7.2 demonstrates Oracle's investment in further strengthening MySQL's position as the leading Web database. The performance and flexibility enhancements in MySQL Cluster 7.2 provide users with a solid foundation for their mission-critical Web workloads, blending the best of SQL and NoSQL technologies to reduce risk, cost and complexity.”