Page 1 of 1

Cluster

Posted: Sun Feb 25, 2007 5:32 am
by user___
Hi guys,
I have two MySQL Servers and when an update is done on the first the same update should be done on the second. I want to develop a cluster but becauses it is my first attempt I do not have the sufficient info on how to do it.
I thought of a solution like this:
Open a site;
Create a connection;(And stick to it because this is the place where the application decides whether to connect to the first to the second one)
When a query like "insert, update, delete, etc." is executed on the first Server the same should be done on the second and vice versa;

I am not sure whether this is a good solution but I would appreciate any kind of help.

Posted: Sun Feb 25, 2007 7:10 am
by Weirdan
check out replication