Slony-I for circular replication
От | Bojidar Mihajlov |
---|---|
Тема | Slony-I for circular replication |
Дата | |
Msg-id | 20060330132720.53509.qmail@web36114.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: Slony-I for circular replication
|
Список | pgsql-general |
Hi All; Can Slony-I be used for circular replication (A <replicates> B <replicates> A) or there is some kind of problem with locking or anything else? If I avoid insert conflicts will the following scenario succeed for the updates : A: X.balance-= 5 B: X.balance-= 3 A receives the update from B (X.balance -= 3) B receives the update from A (X.balance -= 5) or it will lead to deadlock ? Nodes A and B will reside at different geografical locations. I'll use only node A to service both locations in the most time and B for redundancy. But the case of broken connection between node A and B could lead to scenarios like latter because then A and B will service their own location. Could such a scenarios be detected and logged ? What happen in case of a conflict (dublicated primary key/update deleted) ? Could the performed action be managed ? Regards, Bozhidar Mihaylov __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
В списке pgsql-general по дате отправления: