MySQL 5.5 is entering beta; some new exciting stuff.
It‘s been a long time, from my point of view, since MySQL was out with something exciting.
Since version 5.0 back in 2005 we mainly saw bug fixes. Version 6.0 is in development for years and I am not sure if it heads anywhere
(see the following post). So the following new article from MySQL was very encouraging.
Below is a partial feature that I found interesting.
1. InnoDB Becomes Default Storage Engine and InnoDB improvemts:
well it’s about time; why spend so match time on writing new storage engines!
I guess the acquiring of MySQL by Oracle had some benefits.
2. Semi-Synchronous Replication and Replication Heartbeat:
You can choose to have commits on the master node wait until at least one slave has logged the relevant events for the transaction. You can configure the heartbeat period. If the message is not received, the master knows that the slave node has failed. This will not spare the use of third-party heartbeat solutions but can improve the reliability of replication.
3. Performance Schema:
The Performance Schema feature involves an optional schema, named performance_schema, with tables that you can query to see intimate details of low-level MySQL performance. Well this is not new it was called the profiler back in 5.1 but I guess that now it will be more mature