Oracle has announced what it labels as a Development Milestone Release (DMR) of MySQL Cluster 7.3.
Widely labelled as the “world’s most popular” open source database due toits high performance, high reliability and ease of use, MySQL is used by Facebook, Google, Adobe, Alcatel Lucent and Zappos (to name five) to run what are specifically called out as “high volume web sites” as well as the firms’ business-critical systems.
The new MySQL Cluster 7.3 DMR will introduce native support for Foreign Keys.
NOTE: In the context of relational databases, a foreign key is that part of a database that comes from another database table and refers to or targets a specific key. Foreign key’s usually target the primary key in the target database i.e. the unique identifying column that specifies the core use of the database.
MySQL is described as the “database of choice” for a software applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python) today.
Oracle says that foreign key support will enable users to extend the benefits of MySQL Cluster into a broader range of “packaged applications and custom deployments” by simplifying data models and application logic.
“Oracle invests to deliver MySQL solutions powering the next generation of web, mobile and embedded applications,” said Tomas Ulin, vice president of MySQL engineering, Oracle. “The new MySQL Cluster features make it a great choice for a broader range of highly demanding web and telecom services, deployed either on premise or in the cloud.”
Mexican Facebook game runs on MySQL
“By deploying MySQL Cluster Carrier Grade Edition technologies to power our market-leading ‘La Vecindad de El Chavo del 8’ Facebook game, we have been able to scale to over 3 million users in just six months, while reducing our DBA overhead by 80 percent,” said Ricardo Rocha, CEO, Playfulplay.com.
Being as this is Oracle it may not surprise you to learn that MySQL also comes in a commercially supported “paid for” version. Oracle has also just announced new commercial extensions for MySQL Enterprise Edition with additional technology focused on auditing and compliance.