[Linux-cluster] Help needed for mysql cluster

[H.Bala Ji]

Hi,

I also expecting to implement the mysql cluster. Please help out and give
us the implementation steps.

Thanks,
Balaji.V

On Thu, Aug 30, 2012 at 12:16 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
>



-- 
Regards,
*Balaji.V*
@+91 9952022099
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20120830/d38355ca/attachment.htm>