mysql cluster

strubbldesign · 09-04-2009, 06:59 AM

hi everyone!

i am looking for a realy good howto to make a high availability mysql master slave cluster

the problem is that i have only one server with xenserver and two virtual guestOS Centos 5.3

on one i have to make the master on the other one i have to make the mysql slave

I am using only one eht0 device

schould i create a nother one for heartbeat?

i apritiate any help

the thread http://www.linuxquestions.org/questi...th-mon-752602/

is also mine and cant help me further...

kind reguards

strubbl

EricTRA · 09-04-2009, 07:06 AM

Hello,

I've done a similar setup some time ago using guides from HowToForge. I found they were correct, very clear and easy to follow.

MySQL Database replication
Master Master replication (easy enough to 'adapt' for master-slave).

My setup involves two virtual servers running Debian, both with one NIC, and MySQL in master-master replication.

If you're handy with CentOS (don't have experience with it) then you should be able to substitute the installation commands from the latter HowTo I provided above.

Kind regards,

Eric