How many slaves can be set with MySQL 5.0? We plan to set a configuration with a single master on many boxes serving as slaves, but we have to know tha maximum number of slaves that can be set to avoiding troubles on the master side.
Requires Free Membership to View
Generally traffic from slave machines has a minimal impact on the master. The presence of more slaves generally accompanies an increase in INSERT/UPDATE/DELETE operations on the master as traffic increases. The capacity of a given master depends on its configuration and capabilities, but I can say that I have seen configurations with dozens of slaves to a single master. Those looking to decrease load on the master can use a tiered approach, with some slaves feeding others.
This was first published in May 2006
Join the conversationComment
Share
Comments
Results
Contribute to the conversation