[SOLVED] Simple active-passive clustering in HA

[tanveer]

Dear All,

I need some help from your end regarding clustering.

The scenario is: I have two RHEL5 box with apache and mysql-5. I want to make clustering in between them for the above two service.

Now I installed HA in both and its running fine that is when master goes down slave takes over the virtual IP and services too.

But the problem is with MySQL service. I did active-active clustering in both nodes for mysql as when master comes back it can take the updates from slave. But here the PROBLEM rises as HA stops/releases the resources in slave before master starts so MASTER can't take the updates from slave.

Now how to get that update from slave and also I have to keep the mysql service running in both servers for synchronization which is not aligned with HA policy though.

Please help.

[jledhead]

I have never done mysql clustering but if I did this is how I would do it
Mark's IT Blog: MySQL 5 High Availability with DRBD 8 and Heartbeat 2

using drbd

[tanveer]

wow. that was a great link.

Anyway, I found the solution. Just keep the pain in this case mysql out of HA will solve the issue.

[Inspired by House TV series.]