2

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 ?

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

1 Answer 1

2

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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