[Linux-cluster] Help needed for mysql cluster

[Rajendra Roka]

I don't mean to use mixed system. I am currently using 2 node redhat
cluster in vmware with RDM. The reason behind this is high avaliabliy in
MySQL. Not sure how Vmware able to handle the high availabily in this case?
How can I make 2 nodes MySQL servers in vmware  that runs in failover mode
without using Redhat or DRBD cluster ??

We want 2 nodes just in-case if we need to perform maintenance in one node
another node takes over. We want identical copy in each box since we will
not have direct access to iSCSI or storage. The idea is to get rid the RDM
device. We don't want in load balance mode but master/slave works for our
environment.

I found problem with DRBD implementation here since we have only one nic
card(vlan) patched in this box.

Please suggest.

On Thu, Aug 30, 2012 at 4:46 PM, Fajar A. Nugraha <list at fajar.net> wrote:

> 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
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120830/39f3e4b6/attachment.htm>