Matthew Geier wrote:
I'm trying to set up an active/passive failover for MySQL and have a
problem with getting cluster suite to start mysql. It just keeps
telling me to 'look in the logs' for a problem that isn't there.
The main issue seems to be that it decides that MySQL has failed and
I can't 'disable' it to 'enable' it. The disable command fails 'cause
MySQL isn't actually running anymore.
Oct 17 17:00:40 Aristotle1 clurgmgrd[7495]: <notice> Stopping service
MySQL
Oct 17 17:00:40 Aristotle1 clurgmgrd: [7495]: <info> Executing
/etc/init.d/mysqld stop
Oct 17 17:00:40 Aristotle1 mysqld: Stopping MySQL: failed
Oct 17 17:00:40 Aristotle1 clurgmgrd[7495]: <notice> stop on script
"MySQL" returned 1 (generic error)
Oct 17 17:00:40 Aristotle1 clurgmgrd: [7495]: <info> /dev/dm-9 is not
mounted
Oct 17 17:00:45 Aristotle1 clurgmgrd[7495]: <crit> #12: RG MySQL
failed to stop; intervention required
Oct 17 17:00:45 Aristotle1 clurgmgrd[7495]: <notice> Service MySQL is
failed
The only way I can get past this is manually mount the database file
system, manually create the IP address and start MySQL manually - then
tell the cluster manager to disable MySQL. Only even then it gets in a
wierd state and one let me re-enable MySQL again - only this time it
doesn't write anything useful in the logs.
Any one have any pointers ?. I'm not trying to load balance or
anything, just having a standby machine to take over if the first fails.
Hi Matthew,
See http://sources.redhat.com/cluster/faq.html#gfs_mysql and
http://sources.redhat.com/cluster/faq.html#rgm_wontrestart
Regards,
Bob Peterson
Red Hat Cluster Suite
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster