[Linux-cluster] Help needed for mysql cluster

[Rajendra Roka]

Thanks for your reply.

I am looking for help in Redhat cluster not the third party heartbeat.

Anybody has successful implementation of similar case?

Thanks,
Raj

On Thu, Aug 30, 2012 at 11:11 AM, Mohd Irwan Jamaluddin <mij at irwan.name>wrote:

> 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.
>>
>> Current configuration is working fine since we have a single data store
>> but that's preventing the functionality of V-Motion in Vmware environment.
>>
>> To avoid this problem, I would like to develop a cluster with local
>> storage(i.e. vm's local storage rather than using RDM). Our databases are
>> not really bigger and we never have performance issue here.
>>
>> Is there any way we can have 2 identical copies of mysql database so if
>> master/primary node goes down another one takes over? I don't care if there
>> is right solution in master/slave mysql environment.
>>
>> as long as that works in high avaliablity. I've heard about DRBD but not
>> sure if that is the right solution in database environment.
>>
>>
>> Please help.
>>
>>
> DRBD for MySQL is not a bad idea. I suggest you to read
> http://dev.mysql.com/doc/refman/5.0/en/ha-drbd.html
>
> This is my experience a long time ago: http://blog.irwan.name/?p=118
>
> --
> 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/3b673ccc/attachment.htm>