MySQL is "world's most popular" open source database

| 1 Comment
| More

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.

1 Comment

Actually, MySQL lagged behind other open source databases, such as PostgreSQL, for a very long time in its lack of support for certain core pieces of relational database functionality e.g. transactions. MySQL's popularity was partly built on its widespread use for very simple databases e.g. content management systems for websites, rather than its suitability for more sophisticated applications, where PostgreSQL was often a more appropriate choice (and still is, IMHO).

Incidentally, there is nothing new about the "paid for" version of MySQL - there was commercial "enterprise" version of MySQL long before Oracle acquired it.

Leave a comment

(You will need either to sign in or enter a valid email address to comment.)

About this Entry

This page contains a single entry by Adrian Bridgwater published on October 1, 2012 10:04 PM.

French PM: Allons à l'open source was the previous entry in this blog.

Oracle OpenWorld & JavaOne: fun facts is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Categories

Archives

-- Advertisement --