[Linux-cluster] Help needed for mysql cluster

[Fajar A. Nugraha]

On Thu, Aug 30, 2012 at 1:23 PM, Rajendra Roka <rajenddra at gmail.com> wrote:
> Thanks for your reply.
>
> I am looking for help in Redhat cluster not the third party heartbeat.


>> On Thu, Aug 30, 2012 at 8:18 AM, Rajendra Roka <rajenddra at gmail.com>
>> wrote:
>>>
>>> Currently we have mysql cluster running in RHEL 6.3 with 2 vmware guest
>>> and using a single share storage through RDM(Raw Device Mapping)
>>>
>>> We don't need high performance multi master environment, but we want to
>>> enable high availablity just incase of one server goes down for mentenence
>>> or any other purpose second node takes over.


You're making things MUCH more complicated than it should be, you know.

For that simple goal, ONE of these should work:
- vmware's VMHA, with shared storage
- redhat cluster with shared storage, on phyisical nodes
- redhat cluster + drbd, with local storage (synchronized using drbd)

Don't try to mix those. At least not until you have the required
knowledge and experience (which, from your post, I assume you don't).

>>>
>>> Current configuration is working fine since we have a single data store
>>> but that's preventing the functionality of V-Motion in Vmware environment.

That's because you mix solutions that are not designed to sit well together.

If you simply use a mysql VM with shared storage and let vmware handel
the HA, it will work and is a supported configuration.

If you simply use Redhat cluster on physical machine and create either
a mysql resource or a VM resource (kvm/xen running mysql) with shared
storage, it will work and is a supported configuration.

However you decide to use redhat cluster on top of vmware. It can
work, but is not supported.

>>> Is there any way we can have 2 identical copies of mysql database so if
>>> master/primary node goes down another one takes over?

Choose either VMHA or redhat cluster on physical machine. Your choice.

-- 
Fajar