Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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:

  1. Is it possible to install the InnoDB plugin just on the master and not on the slave?
  2. Are there any other implications to installing the plugin?
  3. What parameters do I need to change in my.cnf to better utilize the plugin and the multi core options?
  4. Any recommended tutorial for installing the plugin?
share|improve this question

1 Answer 1

up vote 2 down vote accepted

Goto to the following folder

cd /usr/lib64/mysql/plugin
ls -l

If you see something like this

-rw-r--r-- 1 root root 11827298 Sep 13  2010 ha_innodb_plugin.a
-rwxr-xr-x 1 root root      962 Sep 13  2010 ha_innodb_plugin.la
lrwxrwxrwx 1 root root       25 Jun 23  2011 ha_innodb_plugin.so -> ha_innodb_plugin.so.0.0.0
lrwxrwxrwx 1 root root       25 Jun 23  2011 ha_innodb_plugin.so.0 -> ha_innodb_plugin.so.0.0.0
-rwxr-xr-x 1 root root  1204496 Sep 13  2010 ha_innodb_plugin.so.0.0.0

You have located the InnoDB Plugin files

Getting back to your question :

1.Is it possible to install the InnoDB plugin just on the master and not on the slave?

Yes

2.Are there any other implications to installing the plugin?

Once the plugin is installed and you configure my.cnf for the Master, do not use the options for InnoDB Plugin on another server where the plugin was not installed.

3.What parameters do I need to change in my.cnf to better utilize the plugin and the multi core options ?

Please see my past posts on this

4.Any recommended tutorial for installing the plugin?

Please follow the instructions from the MySQL Documentation on InnoDB Plugin Installation

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.