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 ?

  • 1
    Yes you can use innodb_file_per_table = 1 for your slaves. – Abdul Manaf Jul 1 '15 at 14:20
  • 1
    @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 1 '15 at 14:52
  • @AbdulManaf you should make it an answer. – RolandoMySQLDBA Jul 1 '15 at 15:01
  • @RolandoMySQLDBA , Verace : Added as answer – Abdul Manaf Jul 2 '15 at 4:24

Yes you can use innodb_file_per_table = 1 for your slaves.

Additionally take below points in your consideration

  1. 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

  2. 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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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