MySQL Forums
Forum List  »  Replication

Re: slow slave server
Posted by: Partha Dutta
Date: September 26, 2005 10:13AM

campbell palmer wrote:
> Hi,
> I'm having a problem where if my slave server
> crashes it takes days for it to catch up to the
> master server. I populate close to 1 gig per day
> on the master server, and if the slave ever breaks
> it takes nearly 1 day to catch up for every day it
> has missed. This prevents our slave from being
> functional for extended periods of time. Are
> there tweaks I'm missing that can greatly increase
> the slave server? Both servers are gigabit
> ethernet connected and both servers are using raid
> 5 version of veritas. The slave server has quad
> 800 Mhz cpus as well. I cannot figure out how to
> improve performance.
>
> Master server is Mysql 4.0.12
> Slave server is Mysql 4.1.14
>
> Thanks!
>
>
>
> Edited 1 times. Last edit at 09/20/05 04:42PM by
> campbell palmer.


Not too sure if there are any more tunables that can be helpful. Remember that the slave server is single threaded, so there is only one thread applying SQL statements from the relay log. You may have to beef up the slave server.

Partha Dutta
Senior Consultant, MySQL Inc.

http://www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5508
September 20, 2005 02:40PM
Re: slow slave server
2879
September 26, 2005 10:13AM
2515
September 29, 2005 02:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.