I'm currently setting up mySQL replication.
I need to get data from three places.
So for example, I have
NEED DATA DATA
server1 - database1
server2 - database2
server3 - database3
STORAGE DATA
server4 - database4
I need this for reporting purposes.
I read that you cannot connect to more than one host. Therefore, saying that I am going to try the "main chain" topology, because I think I understand what is happening with this.
So, the data stream will look like this:
server1 → server2 → server3 → server4
server2 server3 , , -log, , 4.
?