Oracle has introduced MySQL Cluster 7.2, which is designed to cost-effectively deliver high availability, high write scalability and low latency for demanding web-based and communications products and services. According to Oracle, with SQL and NoSQL access through a new Memcached API, MySQL Cluster provides the "best of both worlds" - allowing key value operations and complex SQL queries within the same database.
Also now generally available is the latest release of the MySQL Cluster Manager, version 1.1.4, which enhances the ease of use and administration of MySQL Cluster.
"MySQL Cluster 7.2 demonstrates Oracle's investment in further strengthening MySQL's position as the leading web database," says Tomas Ulin, vice president of MySQL Engineering, Oracle. "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."
Key enhancements in MySQL Cluster 7.2 include adaptive query localization, which delivers up to 70x higher performance when executing complex queries, and results in more applications benefiting from the capabilities of MySQL Cluster. In addition, NoSQL access to MySQL Cluster via the Memcached API enables users to speed up key value read and write operations.
Supporting scalability, multi-site clusters allow individual data nodes to be located in different data centers, with databases automatically sharded between them. Synchronous replication maintains data consistency and integrity between sites, with fast and automated failover and recovery. Enhanced active / active replication simplifies conflict detection and resolution across multiple active clusters, eliminating the requirement for developers to maintain a timestamp column in their applications.
And, to improve ease of use and administration, shared user privilege tables consolidate previously distributed tables into the data nodes, making them accessible from all MySQL servers. This new feature removes the need for administrators to define and maintain privileges on each SQL node accessing the cluster.
The new release is certified with Oracle VM, as well as with Oracle Linux and Oracle Solaris.
More information about MySQL Cluster 7.2 is available from Oracle.