I'm in the middle of my little project here and i had some problem here, this is the detail of it.
I have 4 server, 3 server using for getting data from my sensor module and 1 is using for storing data. I try to using chained replication but it seems didn't work for me. I'm using multi master in 3 server and 1 slave in other server.
S1 <--> M2 <--> M3 <--> M4
Each server have different database, in
M2 I have database name
M3 = "PT100_2" and
M4 = "PT100_3", so I created 3 database on each server.
The problem is
M2 cannot receive replication with database
M4, even though
M3 is receiving
S1 even worst, it only can receive
M2, even though there is
"PT100_2" replication running on
M2, nothing either on
What I want is, storing all the database from
S1, that's all.
How can I achieve this? Is it really possible to doing this and I just do some mistakes in configuration?