Am Friday 14 November 2003 14:51 schrieb nm: > I set a 2-way replication with 2 servers > One is accessed and used for both select and updates. The other one is > backup > set to work through a failover software.. if the first server is down. > So the backup server can easily update the other server when it comes up > again. > Do you see any collision possibilities? Only one server is really used.
I have been using 2-way replication on production machines for quite a while and never had any problems. In our case, all machines are used, primary key creation is done in the application and there will never be same pks used on different machines. HTH Stefan -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
