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@xxxxxxxxx> wrote:
On Thu, Aug 30, 2012 at 1:23 PM, Rajendra Roka <rajenddra@xxxxxxxxx> 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@xxxxxxxxx>You're making things MUCH more complicated than it should be, you know.
>> 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.
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).
That's because you mix solutions that are not designed to sit well together.
>>>
>>> Current configuration is working fine since we have a single data store
>>> but that's preventing the functionality of V-Motion in Vmware environment.
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.
Choose either VMHA or redhat cluster on physical machine. Your choice.
>>> Is there any way we can have 2 identical copies of mysql database so if
>>> master/primary node goes down another one takes over?
--
Fajar
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
--
Regards,
Balaji.V
@+91 9952022099
-- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster