MySQL 5.0

MySQL AB has announced the release of MySQL 5.0, their most significant upgrade of the world’s most popular open source database in its ten-year history. This version includes enterprise features requested by the community and eliminated some of the Gotchas.

Some of the new enterprise features in MySQL 5.0:

  • Stored Procedures and SQL Functions — to embed business logic in the database and improve performance.
  • Triggers — to enforce complex business rules at the database level.
  • Views — to ensure protection of sensitive information.
  • Cursors — to allow easier database development and reference of large datasets.
  • Information Schema — to provide easy access to metadata.
  • XA Distributed Transactions — supports complex transactions across multiple databases in heterogeneous environments.
  • SQL Mode — provides server-enforced data integrity for new and existing data.
  • New Federated and Archive Storage Engines — MySQL’s unique pluggable storage engine architecture allows greater flexibility, functionality and performance by making it easy to swap database engines in and out, based on users’ application requirements.
  • New Migration Toolkit — A new graphical toolkit that completely migrates all data and objects from Oracle, Microsoft SQL Server, Microsoft Access and other database platforms to MySQL
  • Instance Manager — new management assistant that allows remote starting/stopping of any MySQL Server, as well as remote editing of configuration files, reading of error and query logs, and more.
  • Updated Connectors and Visual Tools — new high-performance versions of MySQL’s ODBC, Java and .NET database drivers are now available, along with updated versions of the MySQL Query Browser and MySQL Administrator.

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model.

Announcement can be read here. MySQL 5.0 can be downloaded here.

For more technology news and gadget reviews, follow us on Facebook, Twitter and Instagram
  • After InnoDB has been bought by Oracle, at least now, MySQL starts to look like a true enterprise RDBMS.

  • That’s some sort of an issue now in MySQL community. Everybody is guessing what will happen if Oracle, a competitor of MySQL, changes the license.

  • Wow, finally the much awaited stored procedures and triggers goes into production… this will really give Oracle and SQLServer a run for their money 😀

    then again, the purchase of INNODB by Oracle does cast a dark cloud into the whole open sourc-“iveness” of MySQL… considering that INNODB was one of the keys in making it at par with other industry grade DB’s because of it’s transaction-safe features… sooo, BerkleyDB anyone? :D… then again compared to INNODB I’ve read that it’s a tad bit slow 😀

  • it is either one of the two:
    1. Oracle kills InnoDB, and hence, MySQL through licensing or technological restrictions.
    2. Oracle makes MySQL its zombie “subsidiary” by making MySQL suck up all innovations Oracle has to give which results to an ever-more lock-up to Oracle technology.

    Either way, Oracle wins, technically and strategically.

  • It’s about time they should push another one of their product acquired from SAP, MaxDB. Oracle will not just stand there waiting one of their competitor eating their market share little by little. I expect them to drop the bomb one of these days.

    I can’t understand why didn’t mysql bought InnoDB in the first place. Oh well…

  • Oracle just released a free version of 10g… to answer ver 5.0 and a soon to be released free version of sequel server…