This DMR introduces native support for foreign keys. Long part of the SQL standard, foreign keys allow cross indexing of tables. Due to various architecture constraints in the clustered architecture, MySQL Cluster has not offered foreign keys, which left the work of tying together database tables to the application layer. Support for foreign keys should reduce the workload of the application developer, as well as provide a more foolproof method of securing database access to appropriate users.
"We know a lot of customers wouldn't consider a cluster without foreign keys," Ulin said. "It also adds a level of assurance when developing a program."
MySQL Cluster 7.3 also features a new installer that can optimize workloads and automatically discover resources offered by the servers, such as the CPU architecture and the number of processor cores per machine.
Oracle has also updated its commercial version of the database, MySQL Enterprise Edition, with two new extensions. The software now provides the ability to provide reports for auditing and compliance. This extension offers policy-based monitoring and logging of all actions on a database. The second extension provides high availability (HA) safeguards, including automatic failover and replication.
The extension are available at no cost as part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition.