mysql replication and innodb_file_per_table

Question

Is it possible for the master (5.1) to have innodb_file_per_table = 0 and for the slave (5.1 or 5.5) to have innodb_file_per_table = 1 ?

Yes you can use innodb_file_per_table = 1 for your slaves. — Abdul Manaf, Jul 01 '15 at 14:20
@AbdulManaf - that's good to know. I'm giving the question +1. You should write that up as an answer, preferably with some sort of reference/link. — Vérace, Jul 01 '15 at 14:52

score 2 · Accepted Answer · edited Jun 15 '20 at 09:05

2

Yes you can use innodb_file_per_table = 1 for your slaves.

Additionally take below points in your consideration

If you have same version on MySQL on both Master and Slave. You can directly take backup and setup replication from Master to Slave by adding innodb_file_per_table = 1 on slave in my.cnf

Please have a look at How to set Master Slave replication
If you have different version of MySQL , Please make sure that you are taking backup properly because different version would have mismatches in System tables (MySQL Database).

Please have a look answer by @RolandoMySQLDBA for How to take backup properly

edited Jun 15 '20 at 09:05

Community

answered Jul 02 '15 at 04:22

Abdul Manaf

Thank you and thank you for your links, very useful. I will try today. – sivann Jul 02 '15 at 06:20
@sivann : If you found it useful you can mark it as correct answer. – Abdul Manaf Jul 02 '15 at 06:37
Yes of course I will when replication starts; the DB is several TB and took a bit longer :-) – sivann Jul 04 '15 at 08:44

1 Answers1