> what are the differences between those 2 replication methods ? > what should be my concerns for choosing between them ? > 10x
I assume you refere to "Streaming" as Streaming Replication+pgpool-II master-slave/streaming replication mode. - Streaming is async. Your applications might be aware of this. The result of SELECT from standby servers might be behind from primary. - Streaming is async. A committed transaction on primary is not guranteed to be committed in standby in certain cases. - Streaming is probably faster than pgpool-II replication mode in write intensive transactions. Probably the write performance of streaming rep is somewhere between pgpool-II replication mode and Slony-I(slony seems to be faster than streaming with the price of replication lag). - pgpool-II replication mode has some limitations in terms of usable SQL statements. Streaming has not this limitation. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
