We worked around the problem by using safe_mysqld. (We were just running mysqld directly.) What safe_mysqld does is to launch mysqld and then hang around in the background. If mysqld ever dies unexpectedly, it immediately restarts it. If mysqld is explicitly killed, e.g., with "mysqladmin shutdown", safe_mysqld doesn't restart it.
We are still seeing the mysqld die a couple of times a day for no apparent reason, but now it gets automatically restarted. This brings up an interesting question. Is MySQL replication so unreliable that it needs a watchdog like safe_mysqld? Is anyone else seeing frequent, unexplained restarts of MySQL in a replication (or even standalone) environment? Is this peculiar to NetBSD? Inquiring minds want to know. Al __________________________________ Al Johnson Network Storage Solutions voice 865.675-4070 ext 2 cell 865.604.5869 [EMAIL PROTECTED] -----Original Message----- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:11 PM To: [EMAIL PROTECTED] Subject: Re: MySQL Quits in Replication From: "Al Johnson" <[EMAIL PROTECTED]> > Nothing in the MySQL error logs. Don't know what you are refering to > as the "replication log". There is no binlog for the slave and there > are no other logs in the data directory or log directory. Is this > something that has to be enabled? I was referring to the slave's replication binlogs, but it appears you don't have them (they'd be on the slave in the MySQL data directory, afaik). I don't know much about replication setup, I'm only going by our setup here. Sorry I can't be of more help! -- denonymous www.coldcircuit.net --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
