Re: [HACKERS] Slony-I for circular replication
The isbn is 0-13-659707-6. I'm very interesting in study (and implement) a generic framework for replication in a project of the university. Gustavo. On 4/1/06, Guido Barosio [EMAIL PROTECTED] wrote: Heya, Do you have the isbn of the book? Would be great. Cheers, G.- On 4/1/06, Gustavo Tonini [EMAIL PROTECTED] wrote: Ozsu show us some solution for the problem in the book Principles of distributed database systems. On 4/1/06, D'Arcy J.M. Cain darcy@druid.net wrote: On Fri, 31 Mar 2006 17:57:25 -0300 Gustavo Tonini [EMAIL PROTECTED] wrote: why there's no way to make multi-master replication generic? Well, that's the material for a paper but the simplest example I can suggest is serial. How do multiple machines insert into a database table with a sequential primary key? -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Guido Barosio --- ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Slony-I for circular replication
Ozsu show us some solution for the problem in the book Principles of distributed database systems. On 4/1/06, D'Arcy J.M. Cain darcy@druid.net wrote: On Fri, 31 Mar 2006 17:57:25 -0300 Gustavo Tonini [EMAIL PROTECTED] wrote: why there's no way to make multi-master replication generic? Well, that's the material for a paper but the simplest example I can suggest is serial. How do multiple machines insert into a database table with a sequential primary key? -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Slony-I for circular replication
The world rejoiced as [EMAIL PROTECTED] (Gustavo Tonini) wrote: Ozsu show us some solution for the problem in the book Principles of distributed database systems. Would it be telling to outline some of the solutions he suggests? -- (format nil [EMAIL PROTECTED] cbbrowne gmail.com) http://linuxdatabases.info/info/slony.html Rules of the Evil Overlord #189. I will never tell the hero Yes I was the one who did it, but you'll never be able to prove it to that incompetent old fool. Chances are, that incompetent old fool is standing behind the curtain. http://www.eviloverlord.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Slony-I for circular replication
On Thu, Mar 30, 2006 at 10:15:21AM -0500, D'Arcy J.M. Cain wrote: I had to do multi-master replication for a major project and we wound up writing our own replication system. The problem is that this sort of thing really has to be based on your own business rules. There is no way to make it generic. At least, that was the conclusion we came to. Maybe true, but certainly a lot of the framework should be generic, no? There's *a lot* of people who ask about multi-master replication. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Slony-I for circular replication
On Fri, 31 Mar 2006 09:35:31 -0600 Jim C. Nasby [EMAIL PROTECTED] wrote: On Thu, Mar 30, 2006 at 10:15:21AM -0500, D'Arcy J.M. Cain wrote: I had to do multi-master replication for a major project and we wound up writing our own replication system. The problem is that this sort of thing really has to be based on your own business rules. There is no way to make it generic. At least, that was the conclusion we came to. Maybe true, but certainly a lot of the framework should be generic, no? Possibly. Unfortunately I did the work under NDA. I should check and see how much I can talk about. I may at least be able to present a paper discussing the basic ideas. Hmm. Maybe for the Toronto conference? There's *a lot* of people who ask about multi-master replication. Yah, we were one of them. :-) -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] Slony-I for circular replication
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Slony-I for circular replication
On Thursday 30 March 2006 08:34, Bojidar Mihajlov wrote:
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?
Sounds like you want some kind of synchronous federated multi-master
repication... which Slony-I wont do and I don't know of any system that will.
You might be able to get some of that functionality using views and multiple
replication sets, but that conversation really ought to take place on a more
appropriate list, like the Slony list for example.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [HACKERS] Slony-I for circular replication
On Thu, 30 Mar 2006 09:22:38 -0500 Robert Treat [EMAIL PROTECTED] wrote: On Thursday 30 March 2006 08:34, Bojidar Mihajlov wrote: 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? Sounds like you want some kind of synchronous federated multi-master repication... which Slony-I wont do and I don't know of any system that will. You might be able to get some of that functionality using views and multiple replication sets, but that conversation really ought to take place on a more appropriate list, like the Slony list for example. I had to do multi-master replication for a major project and we wound up writing our own replication system. The problem is that this sort of thing really has to be based on your own business rules. There is no way to make it generic. At least, that was the conclusion we came to. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 6: explain analyze is your friend
