|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: 2-way replication
From: Stefan Kuhn (stefan.kuhn
uni-koeln.de)
Date: Fri Nov 14 2003 - 08:29:55 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]