Re: Help needed for mysql cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Aug 30, 2012 at 1:23 PM, Rajendra Roka <rajenddra@xxxxxxxxx> 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@xxxxxxxxx>
>> 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

--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster


[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux