MySQL AB announced the launch of MySQL 5.0 on Monday. The much-anticipated upgrade is available for download under the open source GPL license. The new version looks to be loaded with new features too.
“We are quite proud to deliver this new version of MySQL — as it includes the most-requested features from our users, customers and partners,” said Marten Mickos, CEO of MySQL AB. “With their feedback, we have been able to provide important enterprise-class features while staying true to MySQL’s renowned heritage of high-performance, reliability and ease-of-use.”
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;
— 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.
Over 30 enterprise software and database tool vendors have expressed support for MySQL 5.0. These third-party partners’ products and platforms will be certified for MySQL Network, the company’s commercial database subscription service.
They include Acronis, ActiveGrid, Actuate BIRT, Agresso, Alphasoftware, Arkeia, Business Objects, Embarcadero Technologies, Emic Networks, Four J’s, GoldenGate Software, HP, IBM, Informatica, Jaspersoft, NEC System Technologies, Novell, Pentaho, Quest Software, Samsung SDS, SAP, SourceLabs, SpikeSource, SSA Global, Steeleye, Sumisho, Sun Microsystems, SugarCRM, Zend, and Zimbra.
“MySQL 5.0 represents a huge leap in features and functionality for the MySQL database,” said Gunter Rombauts, European IT manager for Chicago Metallic. “As a worldwide leader in metal ceiling systems, it’s critical that our database supports heavy-duty enterprise applications with speed and reliability. We are looking forward to using MySQL 5.0 as a key component of Chicago Metallic’s global IT infrastructure.”
John Stith is a staff writer for murdok covering technology and business.
