On Wed, 4 May 2005 20:49:59 -0400 Vlad <marchenko@xxxxxxxxx> wrote: > Hello, > in need to increase reliability of the service (and perhaps eventually > offload main DB server) we are looking to setup replication for the > database server. I found two solutions: > Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php ) > PGCluster ( http://pgfoundry.org/projects/pgcluster ) > I found that PgCluster supports multi-muster mode, which we can > benefit from, but it's not required for "backup" which is #1 goal at > the moment. > If anyone used those solutions, compared performance, reliability, etc > - please share your experience / thoughts. i think you need to be more specific about your replication requirements. async multi master is problematic in any case. it can be useful in certain circumstances, but for generically duplicating a large database, it's generally the wrong answer. you should probably focus on single master/multi slave setups, there are useful solutions in that space. richard -- Richard Welty rwelty@xxxxxxxxxxxxxxx Averill Park Networking Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security "F=ma : it's not just a good idea, it's the law" ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
