Cluster

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
user___
Forum Contributor
Posts: 297
Joined: Tue Dec 05, 2006 3:05 pm

Cluster

Post 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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

check out replication
Post Reply