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 ?

Answer 1

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