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

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



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


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