Q

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.

This was first published in May 2006
This Content Component encountered an error

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close