MySQL Cluster 6.4 is a fantastic piece of software with new features such as:
- Multi-threaded Support. A new configuration parameter,
MaxNoOfExecutionThreads=[2,4,8]allows you to set how many cores the data node should utilize.
MaxNoOfExecutionThreads=2for two core machines
MaxNoOfExecutionThreads=4for quad core machines
MaxNoOfExecutionThreads=8for eight core machines
With 8 you will get 4 query handling threads! Can you beat Jonas' 1M reads on a single box?
- Online add node - allows you to scale online! I will publish a procedure how to do this very soon. Currently the Configurator and the Sandbox do not support this.
- Windows Support (I have not tried this and not 100% of the quality, nor how to build it, but it should be there).
- Snapshot backup -
START BACKUP, [SNAPSHOTSTART | SNAPSHOTEND]
SNAPSHOTEND- the backup contains the database at backup end time (default and same as behavior in previos releases)
SNAPSHOTSTART- the backup contains the database at backup start time