We have a MySQL database that we replicate to about a dozen clients
and we hope to be increasing that number to about 15-20. The database
has two tables. One is negligably small and changes maybe once a
month. The second is about 1.3 million rows and grows at the rate of
about 800-1000 rows per day. Both use MyISAM.
We've recently been seeing some performance issues with our
application that manages inserts and updates to the master database.
I have some questions on this front:
1) Does increasing the number of replication slaves increase query
latency on the master? We're considering tiering the replication if
it might help - replicate the master to two slaves, each of which
replicates to ten clients.
2) Is there a chance that the insert latency is coming from the fact
that the table is growing so long? At a certain point, even with
indexes, I imagine that the engine is going to have to do some linear
Thanks for any input!
"The good Christian should beware of mathematicians, and all those who
make empty prophecies. The danger already exists that the mathematicians
have made a covenant with the devil to darken the spirit and to confine
man in the bonds of Hell."
--St. Augustine, De Genesi ad Litteram, Book II, xviii, 37