MySQL AB to Highlight Subselects and other New Features in Upcoming MySQL Version 4.1 at CeBIT

MySQL Partners Emic Networks, BakBone Software and Maguma to Exhibit at MySQL CeBIT Booth

NÜRTINGEN, Germany - (March 4, 2003) - MySQL AB, developer of the world's most popular Open Source database, will highlight subqueries and other new features of the upcoming MySQL database Version 4.1 at the CeBIT conference, March 12-19 in Hannover, Germany. MySQL's presence at CeBIT will be increased with MySQL-related solutions from partners Emic Networks, BakBone Software and Maguma at the MySQL CeBIT booth.

MySQL Version 4.1 represents a major upgrade to the MySQL database software.

In addition to the standard MySQL features such as full support for transactions, Version 4.1 will integrate improvements that enhance MySQL's architectural foundation for building heavy-load commercial applications.

Subqueries Add Advanced Querying Capabilities

MySQL Version 4.1 will include support for SQL subqueries, also called subselects or nested queries, a powerful feature that lets users search complex data with ease and efficiency. With subqueries, users can achieve query consolidation by nesting one query inside another query, creating a resource otherwise unavailable for searching in a single statement. Subqueries allow users to query within a result set, creatively limit the result set or correlate results with an otherwise unrelated query in a single call to the database.

MySQL Version 4.1 will also include a more highly optimized MySQL server library that has a smaller memory footprint and performs significantly faster when embedded in third-party software.

Enhanced Secure Socket Layer Support

MySQL 4.1 will further enhance the support for encrypted communication between clients and the MySQL server using OpenSSL (an Open Source Secure Socket Layer library), greatly increasing security against malicious intrusion and unauthorized access. This allows MySQL client applications to securely exchange information with a MySQL server across untrusted communication links (e.g. an application using the Internet to perform queries directly on a MySQL server behind a company firewall).

Other features in MySQL Version 4.1 will include:

• Support for Unicode through the UCS2 and UTF8 international charactersets, making it easier to store and manipulate internationalized data;
• Support for a subset of GIS data types as proposed by the OpenGIS consortium, which can be used to do efficient searches in maps and other geometrical data
• Support for up to 64 gigabytes of memory in 32-bit Windows (AWE memory) using the InnoDB storage engine
• Better performance through in-memory tables using B-Tree indices.
• New, faster client/server protocol which will support prepared statements, bound parameters, and bound result columns, binary transfer of data, progress notes for long running commands, and warnings.
• Online help for server functions from command-line

Partners at the MySQL CeBIT booth

MySQL is pleased to announce MySQL partners Emic Networks, BakBone Software and Maguma as co-exhibitors at CeBIT. These companies develop third-party solutions that complement and enhance MySQL products.

Emic Networks offers the industry's leading, patent-pending high-availability, fault tolerance and clustering software for application and hardware vendors. Emic will be showing the Emic Application Cluster (EAC) for MySQL server and Apache Web server at CeBIT. EAC combines multiple physical MySQL servers, working as one logical, high performance MySQL server. It takes full advantage of available resources and balances the workload between clustered nodes. For more information about Emic Networks, please visit http://www.emicnetworks.com.

BakBone Software is an international data storage software company that develops and globally distributes high-performance data backup/recovery solutions to the network storage and open systems markets. BakBone develops a popular backup plug-in for MySQL databases for the Linux, FreeBSD and Microsoft Windows NT platforms, giving the user a high performance, reliable and ease-to-use backup and recovery of a running system to protect enterprise data. For more information about Bakbone Software, please visit http://www.bakbone.com

Maguma is a young, innovative software manufacturer of enterprise tools for web applications based on Open Source. With its first commercial product, the development environment Maguma Enterprise Environment for PHP, the software company offers a solution for the faster, easier and more cost-efficient construction of complex and dynamic web applications. With this, Maguma supports the use of PHP in enterprise environments. The headquarters of the company is in Bozen, Italy. For more information about Maguma, please visit http://www.maguma.com

In addition to a strong presence at CeBIT and other industry conferences, the MySQL European community can learn more about MySQL through local training classes, MySQL seminars throughout Europe, and by referencing the MySQL reference manual, which is now available in German and Russian.

About MySQL

MySQL AB develops, markets and supports the MySQL database server, the world's most popular open source database. With an estimated 4 million installations and over 27,000 downloads per day, MySQL is quickly becoming the core of many high-volume, business-critical applications. Major corporations such as Yahoo!, Lucent Technologies, Sony Pictures Digital Entertainment, Motorola, NASA, Silicon Graphics, HP and Xerox rely on the ultra-fast, highly-reliable MySQL database. MySQL is available under the free software/open source GNU General Public License (GPL) or a non- GPL commercial license. For more information about MySQL, please go to www.mysql.com.

# # #

MySQL is a registered trademark of MySQL AB in Sweden and is a trademark of MySQL AB in the USA and other countries. Other products mentioned are the trademarks of their respective corporations.