0
votes
1answer
30 views

DRBD/Corosync mysql clutser

I have configured HA cluster on two nodes host1 and host2. host1 is master and host2 is slave. If I shutdown host1 then host2 never comes up as master until I restart openais service. Some time I ...
0
votes
0answers
29 views

Repair tables after pacemaker + drbd migration/failover

I have a master/slave pacemaker/drbd cluster that handles mysql, apache, and some other stuff. I'd like to have mysql automatically repair tables (mysqlcheck -A --auto-repair or similar) after ...
0
votes
0answers
191 views

DRBD show StandAlone on Primary node after secondary node attach with it?

I am using Centos5.4 & DRBD8.2.6 heartbeat2.1.3 & one java program with Mysql & Asterisk1.6.2.6. On DRBD disk i put 2 service Asterisk & Mysql. SO if DRBD Disk not up both services ...
2
votes
5answers
670 views

DRBD with MySQL

Question about using DRBD to provide HA for MySQL. I need to be sure that my backup MySQL instance is always going to be in a functional state when the failover occurs. What happens, for example, ...
1
vote
0answers
150 views

DRBD heartbeat's resource role trouble in centos 5.4 by mysql files owner change?

I am using 2 machines with centos,mysql,drbd,heartbeat,asterisk. node 1 has hdc :SAMSUNG HD160JJ/P, ATA DISK drive kernel version 1 SMP Tue Aug 21 17:50:26 EDT 2012 kernel release ...
1
vote
1answer
319 views

Pacemaker corosync 2-node with a 3rd for quorum

I'm having trouble figuring out how to configure a 2-node setup with a third simpler one for quorum. It seems to think all the nodes have the capability to act as a full fallback node, when I only I ...
1
vote
1answer
459 views

STONITH with a DRBD/Pacemaker/Corosync 2 node cluster

So I am seeing a lot of conflicting viewpoints out there on using STONITH with a 2-node DRBD/Pacemaker/Corosync cluster for replicating MySQL data. The example I could find on the Pacemaker website ...
2
votes
1answer
4k views

DRBD Not syncing between my nodes

Some version info: Operating system is Ubuntu 11.10, on EC2, kernel is 3.0.0-16-virtual and the application info is: Version: 8.3.11 (api:88) GIT-hash: 0de839cee13a4160eed6037c4bddd066645e23c5 build ...
3
votes
1answer
726 views

DRBD Not starting on Fresh AWS 64-bit Ubuntu 11.10

I followed these instructions precisely (I've done this from scratch using 11.04 and 11.10 with the same results using AMI's ) (using 11.04) Community AMI: ami-e016ca89 ...
0
votes
1answer
446 views

DRBD Replication failure

A couple of weeks ago I setup a 2 nodes CRM system with one of the resources managed being MySQL over DRBD. Today for maintenance reasons I restarted both nodes but now they can't connect to each ...
0
votes
2answers
690 views

mysql with DRBD on rackspace

I am trying to set up a failover secondary MySQL server that is a mirror of my primary MySQL server using DRBD. The problem is that I am on a rackspace cloud server and I need a second partition on ...
3
votes
3answers
700 views

Mysql replication using drbd and heartbeat

I am setting up a backup server for an already existing Ubuntu server setup. I'm running DRBD (protocol C) together with heartbeat, which is configured so that in case of an error the MySQL5 Server ...
0
votes
2answers
2k views

MySQL differential dump? Other strategy for restore?

Is it possible to generate a differential dump with mysqldump - between two databases, or, ideally, between a database and a dumped version of that database? Here's the issue I've got - I have an ...
0
votes
5answers
1k views

MySQL replication using DRBD, distributed lock manager?

I need to implement Linux-HA configuration in two servers. I've decided to use DRBD for block level replication on both hosts, mainly for MySQL data replication. As I understand, in DRBD ...
4
votes
3answers
2k views

Data loss due to MySQL DRBD Heartbeat failover script

Using DRBD version: 8.2.6 (api:88/proto:86-88) Here is the contents of /etc/ha.d/haresources db1 192.168.100.200/24/eth0 drbddisk::mysql Filesystem::/dev/drbd0::/drbd::ext3::defaults mysql ...