Fri Dec 1 09:29:40 PST 2006
- Previous message: [Slony1-general] Recommended maximum slaves per master
- Next message: [Slony1-general] Recommended maximum slaves per master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
* David Fetter <david at fetter.org> [061201 18:06]: > On Fri, Dec 01, 2006 at 11:52:04AM -0500, Jan Wieck wrote: > > On 12/1/2006 11:09 AM, David Fetter wrote: > > > > Statement based replication in an MVCC system is error prone! > > > > Just consider the following little flow of events: > > > > X1: begin; > > X1: set transaction isolation level read committed; > > X2: begin; > > X2: set transaction isolation level read committed; > > X1: update foo set bar = 1 where baz = 5; > > X1: commit; > > X2: update foo set bar = 2 where baz < 20; > > X2: commit; > > > > In a concurrent environment, you have a race condition between X1's > > update and X2's update. How do you know exactly which one happened > > first in the database? > > > > And now add 10 other transactions updating foo to that. > > Alrighty. The problem at hand is, "how do I get 1024 copies of a > database?" Do you have some insight into how to do this with Slony-I? Shipout the sql statements needed via slon -a Distribute them yourself. Andreas
- Previous message: [Slony1-general] Recommended maximum slaves per master
- Next message: [Slony1-general] Recommended maximum slaves per master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list