We have a simple master slave replication. In master we are creating federated tables and querying it to do bulk insert to a local table. On the master server we are not getting any issues, But, on the slave side we are getting SQL Error : Got timeout reading communication packets on query. Default database : xyz. Query ‘INSERT into emp’
We have set max_allowed_packet to 200 Mb on both slave and master, ibdata is 4 Gb fixed. On the server we have enabled innodb_file_per_table.
Is this because, max_allowed_packet is low ? Or is there any particular variable we have to take care while using federated in master and replicating it ?