[DRBD-user] MySQL in Primary/Secondary Mode

Rui Meireles rmeireles at tec.dsr.telecom.pt
Fri Jul 4 18:43:05 CEST 2008

Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.


Thanks for the quick reply.

I usually start/stop it using:
service mysqld start/stop

Probably the service wasn't properly started, or shutdown, and that file
(/var/lock/subsys/mysqld) was preventing it from starting up again. Next
time I'll know.

Thanks a lot!

Rui Meireles


-----Original Message-----
From: James R. Leu [mailto:jleu at inoc.com] 
Sent: sexta-feira, 4 de Julho de 2008 17:17
To: Rui Meireles
Cc: drbd-user at linbit.com
Subject: Re: [DRBD-user] MySQL in Primary/Secondary Mode

Responding in-line ...

On Fri, Jul 04, 2008 at 04:54:03PM +0100, Rui Meireles wrote:
> 
> Just a simple question...
> 
> I have 2 servers in Primary/Secondary mode in a RHEL5. Heartbeat manages
> several services, one of them is mysqld.
> 
> The only thing I did to accomplish this, was to move the directory
> /var/lib/mysql into my DRBD partition (/drbd/var/lib/mysql) and set the
> links in both servers:
> 
> ln -s /drbd/var/lib/mysql /var/lib/mysql
> 
> 
> Is this all that's necessary? Aren't there any more libraries that should
be
> moved?
> I'm asking this because I kept having this errors, and I don't know why:
> 
> [root at server1 ~]# service mysqld status
> mysqld dead but subsys locked

This is due to a stale 'mysqld' file in /var/lock/subsys/.

How are you starting/stopping the mysqld resource on the active/passive
nodes?  On my fedora machines /etc/init.d/mysqld create/removes
/var/lock/subsys/mysqld as part of start/stop

> Thanks
> 
> _______________________________________________
> drbd-user mailing list
> drbd-user at lists.linbit.com
> http://lists.linbit.com/mailman/listinfo/drbd-user

-- 
James R. Leu
Software Architect
INOC
608.204.0203
608.663.4555 fax
jleu at inoc.com
www.inoc.com

*** DELIVERING UPTIME ***




More information about the drbd-user mailing list