1 message in com.mysql.lists.mysqlMySql cluster
FromSent OnAttachments
Ditto kolankanny14 May 2004 00:45 
Subject:MySql cluster
From:Ditto kolankanny (Dkol@dwk.net)
Date:05/14/2004 12:45:01 AM
List:com.mysql.lists.mysql

Hello,

I am not a guru in mysql. Please somebody help me, Weather what I have done is correct or not.

I created a replication cluster in mysql using two machines. machine A replicates to Machine B

machine B replicates to Machine A. and heartbeat is used to give a service ipaddress.

I tested it and its working. but it is now in a test platform and having nothing in it, no much tables or records.

when A is master it is replicating to B and when A is down Harbert give the service IP to B and clients having database from B. and working with B . and when A is back B replicates to A.

Presently it is working, whatever changes creating to A or B is replicating to the other.

my question is weather it will work even if there is a loot of records and tables or in a heavy load situations ???

Thanks and Regards