List:Replication« Previous MessageNext Message »
From:Rick James Date:September 8 2008 5:33pm
Subject:RE: mysql Replication is too slow
View as plain text  
It may not be solvable.  Some issues to consider:

* Slave hardware should be at least as powerful as master.
* Slave executes the replication stream single-threaded, unlike the master.
* Row-based-replication may help
* When there are long-running queries Seconds_Behind_Master lies, but you say it is
consistently > 300 sec?
* Check settings of key_buffer_size, innodb_buffer_pool_size and RAM.  (Show us the values
on master and slave, we will critique)
* If possible "batch" INSERTs; this will speed things up greatly.  INSERT ... (a,b) VALUES
(1,2), (22,33), ...; 

> -----Original Message-----
> From: Timo [mailto:greycd@stripped] 
> Sent: Monday, September 08, 2008 2:38 AM
> To: replication@stripped
> Subject: mysql Replication is too slow
> Hi All:
> The Mysql version is 5.1, I have one master DB and four slave DB. Only
> replicate one DB. But when I run "show slave status\G", the
> "Seconds_Behind_Master " always lagerer than 300. I don't 
> know how to repair
> this problem.
> -- 
> Best regards
> 戚俊? Timo Qi
> msn: timo@stripped
> UNIX System Admin
mysql Replication is too slowTimo8 Sep
  • RE: mysql Replication is too slowRick James8 Sep
    • Re: mysql Replication is too slowMarcus Bointon8 Sep
      • RE: mysql Replication is too slowRick James8 Sep
        • ConsultingDatabase System17 Sep
          • RE: ConsultingRick James17 Sep
            • RE: ConsultingDatabase System17 Sep
              • Re: ConsultingMarcus Bointon17 Sep