MySQL Forums
Forum List  »  Replication

Re: how many slave can work normally in mysql?
Posted by: Rick James
Date: November 26, 2016 10:49PM

I've seen 20 Slaves to one Master work fine. I suspect hundreds is possible. The one limitation is network bandwidth -- the binlog needs to be copied across the network from the one Master to every Slave.

If you need to go beyond that, use "Relays". For example, have a Master replicating to 30 servers, each of which are replicating to 30 more. That gives you 900 Slaves (not counting the 30 relays).

So, since there is no limit on the number of Relay layers, there is actually not limit on the number of Slaves.

Options: ReplyQuote


Subject
Views
Written By
Posted
1086
November 25, 2016 01:19AM
Re: how many slave can work normally in mysql?
624
November 26, 2016 10:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.