slow slave server

[campbell palmer]

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.