Problem solve Get help with specific problems with your technologies, process and projects.

Setting limits to slave numbers in MySQL 5.0

MySQL expert Mike Hillyer describes how increasing the number of slaves will impact operations traffic on the master side.

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.

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.

Dig Deeper on Linux servers

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.