Hello the list ! I'm new to Slony-I, but I started to do some testing (I've completed the tutorial "Replicating Your First Database").
However, I'm wondering if (and how) it is possible to adapt Slony-I to my needs. To understand my goals, here is how I plan to use Slony-I : - The servers are distant (WAN). - I will handle an average of 100 distinct databases. - I will only setup two servers. - Each node will host at the same time 50 "master" databases, and 50 "slave" databases. So, in normal operation, 50 databases should the served by server "A", and the 50 other databases by server "B". Each server will also store 50 replicated databases from the other server. So, in case of switchover or failover, one server will then activate its 50 replicated databases, serving a total of 100 databases. I think I could easily define two "clusters" : - A cluster "part1" (for 50 databases), the "origin" being server "A", and the subscriber being server "B". - A cluster "part2" (for the 50 other databases), the "origin" being server "B", and the subscriber being server "A". Am I ok ? Now, instead of handling a total of 50 databases in each cluster, my wish is that each database should be threated individually. For example, if a database if corrupted, I should be able to do switchover for this database only. However, I realized that each "slon" instance need an average of 8.5 MB of memory (and 15 processes) !! As-is, it is prohibitive for my setup... Is there a mean to leverage this ?? Also, in parallel, I need to replicate files with Unison (one directory per database). Is it possible to keep the synchronisation of the files and of the databases in sync ? For example, is it possible to "cron" a replication of each database, followed by a replication of the associated files (and preventing the databases from replicating automatically without their files) ? I thank in advance everyone for any good advice ! Philippe Ferreira. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
