bnichols@xxxxxxxxxxxxxxx (Brad Nicholson) writes: > Bohdan Linda wrote: > >>I would have a slight offtopic question, this is issue only of pgsql or >>there are some other db solutions which have good performance when doing >>this kind of replication across the world. >> >> >> > It all depends on the quality of the connection Node A to Node B. If > connectivity is poor, then it is impossible to have good performance > doing anything across that connection. The "nifty magic" of asynchronous multimaster would be that you'd be able to have fast access at "Site Alpha" to "Node Alpha" as well as fast access at "Site Beta" to "Node Beta." That would, indeed, be valuable. That's why it's one of those "Holy Grail" things... It's Rather Hard, which is why there isn't a "Slony-III: The Wrath of Async MultiMaster" just yet. It would be valuable for someone to look into a replication system to support that sort of scenario. With the stipulation that there be some big, fiery dragons there ready to eat you and your data :-). -- (format nil "~S@~S" "cbbrowne" "ntlug.org") http://www3.sympatico.ca/cbbrowne/linuxdistributions.html "I'm guilty of a lot of things, but I didn't ever do that.'' -- Bill Clinton, on why he had astroturf lining the back of his pickup truck [In fact, he _DID_ do this, thus making life creepier than fiction...] ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
