Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

How to update more than one MySQL databases simultanously fom different systems.

Hello,
I am making a project based on a Distributed Environment Computing, where I have total 11 Servers, and the Client connects to all 11 Servers to upload certain files. Here I am required to maintain a Database on each Server which contains exactly the same information of all the clients(this makes the database redundant but it is required by the project as one of the goals of the project is to eliminate "Single point of failure").

The things proceed like this : The client connects to all the servers and uploads the files, and when a file is uploaded at one server, it (the server) should inform all other servers that the file for the client has been successfully uploaded on it. This should be done by all the servers when the file is uploaded on them, thus at the end all have the same information for the client.

So can anyone tell me a good solution to accomplish this task.

Info:

I am using MySQL for database.
Language Used : C++ (Not VC++)
IDE Used : VC++ 2005

Pawan
[1041 byte] By [ppuniversal] at [2007-11-11 10:22:16]
# 1 Re: How to update more than one MySQL databases simultanously fom different systems.
See if these help:
http://www.howtoforge.com/mysql_database_replication
http://sqlbusrt.sourceforge.net/
Phil Weber at 2007-11-11 23:43:21 >