List:Replication« Previous MessageNext Message »
From:Rick James Date:September 21 2011 8:58pm
Subject:Re: confirm subscribe to replication@lists.mysql.com
View as plain text  
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

Thread
RE: confirm subscribe to replication@lists.mysql.comRicardo Freitas21 Sep
  • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
    • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
      • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
        • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
        • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
          • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
            • Re: confirm subscribe to replication@lists.mysql.comPrabhat Kumar21 Sep
            • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
              • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
                • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
                  • Re: confirm subscribe to replication@lists.mysql.comRicardo22 Sep
      • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
  • Re: confirm subscribe to replication@lists.mysql.comRick James21 Sep