MySQL Forums
Forum List  »  Replication

slow slave server
Posted by: campbell palmer
Date: September 20, 2005 02:40PM

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 time(s). Last edit at 09/20/2005 02:42PM by campbell palmer.

Options: ReplyQuote


Subject
Views
Written By
Posted
slow slave server
5506
September 20, 2005 02:40PM
2878
September 26, 2005 10:13AM
2513
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.