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

Re: [Linux-cluster] Help needed for mysql cluster

On Thu, Aug 30, 2012 at 8:18 AM, Rajendra Roka <rajenddra 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

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