>Would the INSERT ... SELECT query slow down the replication process?
yes it may increase replication lag but how long this is likely to take? few seconds or mins? if it takes longer then it would clog replication stream and small and fast updates which go after it in MySQL binary log can’t proceed but it also depends on binary log format, if you use ROW binlog format then this query may be faster.
>3. As I understand that it is not recommended to have replication setup in different MySQL versions.
We are not recommended to have replication setup in between 5.1.45 and 5.5.12
If replication slave is using new version of MySQL, in your case Master database is using 5.1.45 and replication slave is using 5.5.12. The setup should work because 5.5 does understand all binary log formats that 5.1 supports. So it should work but if you use MySQL 5.5 with master database and 5.0 with replication slave in this case replication may not work.
>1. Skip table in replication process
If you use 'ROW' binlog format then temporary tables are not replicated ( by default so you don't need to use replication filter options) but in the case where you copy contents of temporary tables to the perm table would replicatei.e.
INSERT INTO perm_table
SELECT * FROM tmp;
Edited 3 time(s). Last edit at 07/18/2012 04:46AM by Aftab Khan.