Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL Replication (Multiple Master & 1 slave)
- Thread starter elg3ne
- Start date
MySQL only supports One master and many slaves.
Having more masters is however not logical as you would have to have masters server update from another master, therefore acting as slaves.
That would be some sort of peer replication that it is not implemented in MySQL
What are you trying to achieve by teh way?
I am sure there is a different solution.
Bye
Qatqat
Life is what happens when you are making other plans.
Having more masters is however not logical as you would have to have masters server update from another master, therefore acting as slaves.
That would be some sort of peer replication that it is not implemented in MySQL
What are you trying to achieve by teh way?
I am sure there is a different solution.
Bye
Qatqat
Life is what happens when you are making other plans.
It is possible to have multiple masters, provided they can be connected to singly.
We use it to check multiple client sites, and store all the data in the corporate (slave) DB.
If this will work for you, you want: CHANGE MASTER TO. See the manual on MySQL.com
Hope that helps.
m.
We use it to check multiple client sites, and store all the data in the corporate (slave) DB.
If this will work for you, you want: CHANGE MASTER TO. See the manual on MySQL.com
Hope that helps.
m.
- Status