Replication

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Replication

Postby psyko57 » 25. June 2009 18:32

Hello everybody,

I've a network with one server and many clients (like 5-10).

Each client have a database onboard and the server too.
The server does not modify the database but the clients always do (most of acces is in write mode ...)


How can i do replication in order to have all database synchronized at any time ?

Thank you ;)
psyko57
 
Posts: 1
Joined: 25. June 2009 18:26

Re: Replication

Postby glitzi85 » 03. July 2009 20:47

Are we talking about MySQL?

That's only possible, if you direct all write access to the server. In this case you can use replication. The master (read/write) database will reside on the server, the slaves (read-only) will reside on the clients.

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: Replication

Postby glitzi85 » 03. July 2009 20:51

Multimaster-Replication would also be a possibility: http://www.onlamp.com/pub/a/onlamp/2006 ... ation.html
I just don't know whether this will work with more than two master :?:

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests