Page 1 of 1

Replication

PostPosted: 25. June 2009 18:32
by psyko57
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 ;)

Re: Replication

PostPosted: 03. July 2009 20:47
by glitzi85
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

Re: Replication

PostPosted: 03. July 2009 20:51
by glitzi85
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