[DRBD-user] drbd + mysql issues

Joe Warren-Meeks joe at encoretickets.co.uk
Tue May 4 17:39:07 CEST 2010

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


 

How odd, it all seemed to work fine in testing..

 

Thanks kindly for pointing it out.

 

However, is there any where I can look to find out why drbd failed from
master to backup? I can't find anything which would indicate why?

 

Kind regards

 

 -- joe.

 

From: drbd-user-bounces at lists.linbit.com
[mailto:drbd-user-bounces at lists.linbit.com] On Behalf Of Ryan Manikowski
Sent: 04 May 2010 16:00
To: drbd-user at lists.linbit.com
Subject: Re: [DRBD-user] drbd + mysql issues

 

On 5/4/2010 10:33 AM, Joe Warren-Meeks wrote: 

Apologies,
 
Running on Ubuntu 8.04LTS
 
Using:
ii  drbd8-utils                           2:8.0.11-0ubuntu3
RAID 1 over tcp/ip for Linux utilities
ii  heartbeat                             2.1.3-2
Subsystem for High-Availability Linux
ii  fuse-utils                            2.7.2-1ubuntu2.1
Filesystem in USErspace (utilities)
ii  libfuse2                              2.7.2-1ubuntu2.1
Filesystem in USErspace library
 
Version: 8.0.11 (api:86)
GIT-hash: b3fe2bdfd3b9f7c2f923186883eb9e2a0d3a5b1b build by phil at mescal,
2008-02-12 11:56:43
 
/etc/drbd.conf 
 
global { usage-count yes; }
common { syncer { rate 40M; } }
resource r0 {
        protocol C;
        net {
                cram-hmac-alg sha1;
                shared-secret "xxxxx";
        }
        on d1 {
                device    /dev/drbd1;
                disk      /dev/cciss/c0d1p1;
                address   10.10.xxx.xxx:7789;
                meta-disk internal;
        }
        on d2 {
                device    /dev/drbd1;
                disk      /dev/cciss/c0d1p1;
                address   10.10.xxx.xxx:7789;
                meta-disk internal;
        }
}
 
/etc/ha.d/haresources:
d1 drbddisk Filesystem::/dev/drbd1::/data::ext3 mysql 10.10.xxx.xxx
 
  


<snip>

Your /etc/ha.d/haresources file appears to have the incorrect syntax. It
should look more like:

d1    drbddisk::drbd1 \
        Filesystem::/dev/drbd1::/data:ext3 \
        mysql \
        IPaddr::10.10.xxx.xxx/<netmask>/<interface>


The errors you posted regarding mysqld not being able to locate the db
directory may be caused by the mysql daemon starting prior to the drbd
device being mounted. In that case, you may want to utilize the 'Delay'
script in ha.d/rc.d/. Here is an example:

d1    drbddisk::drbd1 \
        Filesystem::/dev/drbd1::/data:ext3 \
        Delay::2 \
        mysql \
        IPaddr::10.10.xxx.xxx/<netmask>/<interface>


It appears very likely your problem is not being caused by DRBD, but
rather by the heartbeat configuration.




-- 
        Ryan Manikowski
 
 
]] Devision Media Services LLC [[
        www.devision.us
 ryan at devision.us | 716.771.2282
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20100504/6a98633e/attachment.htm>


More information about the drbd-user mailing list