Replication

[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

[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

[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