From the perspective of the release of MySQL 5.5, the new version of open source database is upgraded.

BKJIA selection] Although Oracle's acquisition of Sun transaction is still waiting for the final result, the industry is also very worried about the future fate of the open-source database MySQL BKJIA Editor note: in order to allow the EU to approve transactions more quickly, oracle issued a statement earlier this month and made ten commitments on MySQL. However, Sun developers are still working hard to develop the open source database. One of the fruits of their work is the latest MySQL 5.5 milestone 2 Developer version. The new version introduces many new features, some of which were initially prepared for MySQL 6.0.

 

For the last two years, the MySQL Community has been discussing MySQL 6.0. A recently released MySQL stable version is version 5.1, which made its debut a year ago after it was controversial and postponed.

Following the launch of MySQL 5.1, the MySQL development team changed the new version mode to support a more rapid and stable version upgrade cycle. Later, some features planned to be available in version 6.0 were unveiled in advance.

Sun spokesman Steve Curry pointed out, "as part of this new model, we have implemented many features originally planned for version 6.0 in MySQL 5.5 in advance, mySQL 6.0 will be available in the future, but we have not decided which new features it will include."

Kerui said he believes that users will be excited by the many new features in the MySQL 5.5 milestone, includingPerformance and scalability Improvement.

◆ The semi-synchronous replication function is added to MySQL 5.5. In addition to the default asynchronous replication function, MySQL users now have another replication function available.

According to the MySQL 5.5 statement, "before the session for executing the replication transaction is returned, the Master end suspends the execution and commit until the slave end confirms that it has received and recorded the replication transaction ." In contrast, in the asynchronous replication function, the Master directly records events without knowing whether the slave actually processes the replication transaction.

◆ MySQL 5.5 adds the improved partitioning syntax. In this new version of the database, there are many new database partition function options, including the user-defined range columns Partition Function options.

"When you partition a table based on range columns or list columns, you can define ranges or lists based on the values of multiple COLUMNS. up to 16 COLUMNS can be associated ."

◆ MySQL 5.5 milestone edition also supports SQL standard SINGAL and RESINGNAL statements. Both the SINGNAL statement and the RESINGNAL statement ensure that an error state can be returned to the database Hander.

"There is no SINGNAL," the MySQL official statement said. If you want an error to be returned by a program, you must resort to a roundabout solution, such as deliberately pointing to a good table. RESINGNAL can handle errors and return error messages. Otherwise, information about Handler activation will be damaged by executing an SQL statement in Handler ."

From MySQL 5.1 to MySQL 5.5

Currently, MySQL 5.5 milestone is a developer version and is not suitable for use in a formal production environment. But this does not mean Sun does not want people to try this new version. Ke Rui said that the work of MySQL 5.5 testers is very important and can help Sun receive feedback and estimate the progress.

If you want to upgrade from the current version 5.1 to the development version 5.5, you do not have to explore the upgrade method. Ke Rui said, "we are providing a lot of transplant materials to help users complete the upgrade process and encourage them to get familiar with the new features. We do not want users to have any trouble in this process."

As for the official release of MySQL 5.5 when the current developer milestone version was ended, kerui said it was not finalized.

"In the future, we will have a clearer idea after receiving initial feedback from the community, customers, and internal QA," he said. With this new milestone version model, we are striving to improve all database functions. The initial user feedback is satisfactory, but it is too early to say when the official release will be made. We are glad to bring this new version to the community and they will tell us how to develop this software ."

Original article: MySQL 6 Features Roll Into MySQL 5.5 Milestone Author: Sean Michael Kerner