[ale] database conversion

[James P. Kinney III]

On Thu, 2005-02-10 at 10:16 -0500, Christopher Fowler wrote:
> One method I thought of was to create a system in which there is
> wrappers my code uses that will send inserts to multiple servers. 
> Problem is that this system is not very robust.

I have been considering that method as well. The drawbacks are
intermittent connectivity (fixable with a secondary script to cache and
retry when connectivity returns) the overall size of the originating
codebase (Interchange is freaking HUGE!)
> 
> On Thu, 2005-02-10 at 09:51, James P. Kinney III wrote:
> > More brainstorming (after a mail crash yesterday!)
> > 
> > Postgresql 8 has a pretty good Write Ahead Logging. A seperate project I
> > am looking at is to use the WAL as a way to syncronize two databases
> > that are not in a mirror mode of any type.
> > 
> > The scenario: Main DB has the _real_ web transactions, user list,
> > products, etc.  Second machine gats a clone of the main machine at a
> > point in time. Second machine is hauled to a trade show where the net
> > access is (or lack) prevents a direct line to the main db.
> > 
> > Second machine runs the transaction locally after a checkpoint in the
> > WAL is set. After the show, the WAL is replayed back into the main
> > machine to merge in the transactions from the satellite unit.
> > 
> > Other than the obvious issues of duplicated transactions (not likely
> > except for possibly adding a new user) and the sequence id's for the
> > transactions (I will have to double check that the sequencing id's are
> > only used as record counters), are there any "gotcha's" that others have
> > run across in anything similar?
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part