Is there any specific reason for not able to use slave parallel workers while working with lower version of master which not supports parallel workers and higher version of slave which supports parallel workers. Here i am trying MASTER ( 5.5.28 ) and slave (5.6.19)
See this presentation MySQL Replication High Performance: Multi-Threaded Slaves and Group Commit
It is stated with respect to the multi threaded replica (MTS):
- Row Based Replication is supported even if replicating from a Master without MTS knowledge (e.g., from a 5.5 MySQL master).
- Statement Based Replication requires a 5.6 master.
Re questions from @vidyadhar:
I don't know if replica performance will be worse if the master is 5.5. I haven't tried that. I don't mean to sound flippant, but if performance is so important to you, why wouldn't you upgrade to 5.6?
Regarding statement based replication and multi-threaded replica, I have not tested that combination. But I have not read any requirement to use row based binlog format for MTS. I assume it would work fine, because the MTS delegates events to replica worker threads based on the database, and every event in the binlog identifies the default database for the event, whether the event is in row based or statement based format.