Ask the Expert

Setting limits to slave numbers in MySQL 5.0

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: