Recently, the issue of how MySQL will develop after Oracle acquires Sun has been hot news. I am very happy to see that there will be a new version of mysql at this time. The original MySQL 5.4 has no link on the official website. It seems to be upgraded to Version 5.5 is out, and the official website also provides a guide for upgrading from 5.4 to 5.5. MySQL 5.5.0 is a so-called milestone version. This time it brings some interesting things. Let’s list them in order of importance (my subjective opinion):
Supports semi-synchronous replication. This is transferred from the early semi-sync patch of Google. It can achieve semi-synchronous replication of master-slave and integrate Innodb plugin 1.0.6.
Supports SQL standard SIGNAL and RESIGNAL statements to enhance XML functions. Supports LOAD XML statements to delete all data on a certain partition of a table through ALTER TABLE... TRUNCATE PARTITION. Added new partition syntax of TO_SECONDS function.
Key caches are now supported for indexes on partitioned MyISAM tables, using the CACHE INDEX and LOAD INDEX INTO CACHE statements
This version is not yet suitable for use in a formal environment. Think about it, maybe mysql mmm + mysql 5.5 can be used to provide services with better availability in the future, provided that it is stable enough, or is it a percona version?
Download: MySQL 5.5
-