[DRBD-user] drbd + mysql issues

Ryan Manikowski ryan at devision.us
Tue May 4 16:59:46 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.


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/ce58d742/attachment.htm>


More information about the drbd-user mailing list