MySQL AB, developer of the world’s most popular open source database, today announced the general availability of MySQL 5.0, the most sigificant product upgrade in the company’s ten-year history. Starting today, MySQL 5.0 can be downloaded under the open source GPL license at http://dev.mysql.com.
MySQL AB, developer of the world’s most popular open source database, today announced the general availability of MySQL 5.0, the most sigificant product upgrade in the company’s ten-year history. Starting today, MySQL 5.0 can be downloaded under the open source GPL license at http://dev.mysql.com.
The new MySQL 5.0 combines enterprise-grade reliability and performance with advanced SQL 2003 standard-compliant features, making it the most cost-effective database solution for business-critical applications. The product’s new functionality will be especially familiar to database developers and DBAs of proprietary relational database systems — allowing IT departments to ease the integration and transition of their data, applications and skill-sets.
MySQL 5.0 delivers dozens of new enterprise features, including:
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;
…
Please log in to view this content.
Not Yet a Member?
Register with LinuxMagazine.com and get free access to the entire archive, including: