Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Create new ibdata file on slave

krazyunikskrazyuniks EntrantInactive User Role Beginner
Hi,

I have a master-slave setup running on Amazon EC2. The innodb data file is 900GB. The master is vanilla mysql while the slave is the latest percona server. I am going to tweak the slave to get the best performance as possible then make it the master.

I would like to create a second ibdata file on the slave, on a different volume. Would this break replication at all (I will "stop slave" during this process)? I would guess it is fine if the slave has different configuration than the master. Just want to check.

Thanks for your help.

Comments

  • sterinsterin Mentor Inactive User Role Contributor
    No it will not break replication.

    MySQL replication is simply that the slave is redoing all sql queries that modify the data on master.

    So the master and the slave can have very different settings.
    The the only thing to watch out for is if you have made a change in the design of the table on the slave and then you drop and re create the table on the master at which point all modifications to the slave will of course be lost in the drop.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.