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.
Cluster
Moderator: General Moderators
check out replication