From: Rick James Date: September 21 2011 8:58pm Subject: Re: confirm subscribe to replication@lists.mysql.com List-Archive: http://lists.mysql.com/replication/2216 Message-Id: <4E7A500B.2060601@yahoo-inc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 9/21/11 11:21 AM, Ricardo Freitas wrote: > with values along the 5500 records > per minute, I was wondering what implications, performance wise, does a > master-slave replication system have. Not a problem. That's only 100qps. I deal with systems having a dozen slaves and higher qps. I do recommend that you tune your caches adequately: http://mysql.rjweb.org/doc.php/memory and that you use batch INSERTs or LOAD data for rapid inserting -- you can often get 10x the performance. -- Rick James - MySQL Geek