Right now, we have a MySQL 5.5 master which replicates all 10 of its databases to two slave servers, slave1 and slave2. I want to offload some processing to slave1, so I want to move two databases from master to slave1, and then have slave1 replicate to slave2.
So: For 8 databases: Master -> Slave1, Master -> Slave2
For 2 databases: Slave1 (which is master for these two) -> Slave2
How do I go about doing this easily? I don't want replicated changes that come to Slave1 from Master to be passed on to Slave2. Is this a matter of setting up Slave2 to have two masters (but masters of non-overlapping databases), and use something like
--replicate-do-db on Slave1 to determine which databases it passes on to Slave2...?