On Thu, Apr 11, 2002 at 09:46:18AM -0400, Marc Prewitt wrote: > We have a slightly smarter script which checks each slave to find > the furthest one behind and purges up to that number. However, it > currently figures out who the slaves are by checking a process > status on the master. Unfortunately, this doesn't work if one of > your slaves is down. So, I'm going to rewrite it to check the known > slaves.
Yeah, there are a lot of ways to skin that cat. I've debated trying to come up with something smarter, but never bothered. We've got a heartbeat mechansim monitoring all our slaves, so I get mail/paged if any one falls to far behind (more than 2 minutes). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,719,480,055 queries (312/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
