drbd-user March 2010 archive
Main Archive Page > Month Archives  > drbd-user archives
drbd-user: [DRBD-user] Broken mysql replication

[DRBD-user] Broken mysql replication

From: Jordi Espasa Clofent <jespasac_at_nospam>
Date: Mon Mar 15 2010 - 10:30:14 GMT
To: drbd-user@lists.linbit.com

Hi all,

I've a master mysql cluster composed by node0 (the active) and node1
(the passive), which share de mysql data using drbd. I get the high
avaliability with heartbeat, of course. No problem here, all work fine.
If I shudown the active one (node0), drbd and heartbeat assure the mysql
high avaliability.

node2 is a simple mysql slave; it uses the virtual IP shared between
node0 and node1 for replication.

The detected problem is:

- I launch a massive INSERTs (databaseX.tableN) script against virtual IP.
- I shutdown node0; node1 takes the control. During the downtime, the
script is hanging, obviously
- I check the tableN in node1 and the same table in node2... and they've
a different number of records. The result is the mysql replication is
broken.

¿Why? ¿Maybe I need some drbd tuning?

Here is my drbd.conf in node0/node1:

cat /etc/drbd.conf
resource r0 {
   protocol C;
   startup { degr-wfc-timeout 120; }
   disk { on-io-error detach; }
   net { timeout 60; connect-int 10; ping-int 10;
          max-buffers 2048; max-epoch-size 2048; }
   syncer { rate 10M; }

   on kvm-node0.srv.cat {
     address 192.168.2.245:7788;
     disk /dev/hda1;
     device /dev/drbd0;
     meta-disk "internal";
   }

   on kvm-node1.srv.cat {
     address 192.168.2.246:7788;
     disk /dev/hda1;
     device /dev/drbd0;
     meta-disk "internal";
   }
}
_______________________________________________
drbd-user mailing list
drbd-user@lists.linbit.com
http://lists.linbit.com/mailman/listinfo/drbd-user