I have MySQL servers A, B, C, and D. Server A is the MySQL master who receives the write traffic, and my applications look at B + C for reads (current slaves). I have replication forwarding ALL database events from A --> B and then from B ---> C. Server B is a slave to A, but a "master" to C. There are about 14 databases being tracked in the bin-logs. So, I would like to setup replication to AWS Aurora (the future D server), but I only want to replicate ONE database to it, from server C. So my setup would ideally look like this:
A ----> B ----> C ----> D (aws aurora w/ 1 database)
How do I tell server C to become a replication master and only replicate ONE database to server D (aws aurora)? I hope this makes sense.