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.