Ok... If all you need is all the offices to have a copy the main database this should work. But if you need two way replication this is harder. Two way replication can be done in a loop but there can be problems with being out of sync!
V4.1 should be able to do full two way replication. Hope this helps Simon -----Original Message----- From: Remco Ploeg [mailto:[EMAIL PROTECTED]] Sent: 04 January 2002 16:14 To: Mysql (E-mail) Subject: replication The following question. We have got several office in Europe. Now I want to use 1 database in Rotterdam (main) en several other in the other countries (spain, france, portugal, belgium and germany). Know I want to synchronize those databases of the other offices with the 'big' database (mysql) in Rotterdam. Can I do that with Replication? Rotterdam (mysql) databases: 1.rdm 2.belgium f3.rance 4.port 5.germ France(mysql) Belgium(mysql) France(mysql) Portugal(mysql) Germany(mysql) these database must synchronize with the correspondenting database in Rotterdam, so france=france portugal=port. Can I do that with mysql. And do somebody have a got document how to do that, because I tried with the mysql help but when I do that, it does not replicate with the 2 test databases (there are connected but not synchronizing) Thanks in advance, Remco Ploeg The Netherlands --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
