I have a Master/Slave Replication Setup, both servers run MySQL 5.1.61.
I want to upgrade the master server to a stronger machine with the following:
- 2 processors - 6 cores each
- 48GB of RAM
To utilize both processors I need to install the InnoDB Plugin
I have a few questions:
- Is it possible to install the InnoDB plugin just on the master and not on the slave?
- Are there any other implications to installing the plugin?
- What parameters do I need to change in my.cnf to better utilize the plugin and the multi core options?
- Any recommended tutorial for installing the plugin?