Re: replication general question

2005-06-23 Thread Gleb Paharenko
Hello. I haven't heard about periodical MySQL jobs, but Unix boxes usually have some midnight cron jobs (updating of locate database for example). [EMAIL PROTECTED] wrote: > > I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with > boat loads of ram. They are

Re: replication general question

2005-06-23 Thread jabbott
I don't think network latency would be an issue. This is within a protected network dmz so it has it's own switch. Here is the nagios script stuff. Might be more than what you need but let me know if you are able to use some of it. I have two on the server. first, I have: [EMAIL PROTECTED]

Re: replication general question

2005-06-23 Thread Atle Veka
What type of drives to you have on your system? That is often more important than CPU speed. My guess is that there are nightly maintenance crons slowing down disk access. I have never monitored replication via the seconds-behind-master function as we do not use 4.1, so I can't speak for how accur

replication general question

2005-06-23 Thread jabbott
I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with boat loads of ram. They are not real busy servers but they have some pretty good sized tables, one of them with a few million rows. My question is, I have Nagios setup to monitor the seconds behind master on the bac