Currently, I have a production setup which consists of one Primary server and one Replica server, lets call them Primary1 and Replica1. All databases from Primary1 are replicating to Replica1.
Now, I have to introduce the second replica server, let's call it Replica2, which will be taking just one DB from Replica1.
So, the final look should be>
Primary1 -> Replica1 -> Replica2
On the Replica1, I configured log-slave-updates and configured log-bin. I was thinking of configuring binlog-do-db on the Replica1.
Replica2 configuration is pretty straight forward.
Now, the question is, are those 3 parameters (log-slave-updates, log-bin and binlog-do-db) on Replica1 enough to complete the setup I'm trying to achieve or do you have some other ideas?