After Oracle acquired Sun, it could be said that it was a very popular question about how the MySQL database would develop. Of course, it was a good thing that MySQL could come up with a new version at this time, the original MySQL 5.4 version is missing links on the official website. It seems that it was upgraded to MySQL 5.5.
MySQL 5.5.0 is a milestone version. This time it brings some interesting things and I am subjective to the extent of importance:
Semi-synchronous replication is supported, which is switched from the earlier google semi-sync patch to achieve semi-synchronous replication of master-slave.
Integration with Innodb plugin 1.0.6
Supports SQL standard SIGNAL and RESIGNAL statements
Enhanced XML functionality and support for load xml statements
You can use alter table... truncate partition to delete all data of a TABLE in a PARTITION.
Added the TO_SECONDS function.
New partition syntax
- 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 suitable for official environments. Maybe mysql mmm + mysql 5.5 can be used in the future to provide better availability services, provided that it is stable enough or percona version?
The above content is an introduction to the MySQL 5.5 release. I hope you will get some benefits.