[Opensource] db-replication

[Michael Rimov]

At 08:53 AM 12/11/2002 +0000, you wrote:
>Hi there,
>Does someone know if there is any possibility to make (n>=2 - way)
>replications between databases on n >= 2 machines?
>We want to improve the reliability of our webservice termidat.de
>using two absolutely identical machines with diffent url's, so
>that the user can visit yyy.de if xxx.de is broken down vice versa.
>in normal operatig state (both are up) it shoudn't matter, which
>machine is used.
>For us it is not possible to use the low-level replication deliverd with the
>DB, because a) some special cases must be treated by hand. (contratictory
>data entered in the time-window before replication has finished) and
>b) communication must be secure (encrypted). c) we don't want to be bound
>to the limit of 2 machines.
>autoincrements and atomicity of transations are no problem.

Well, a crude, but effective way would be to create your own dbobject that 
overrides the 'write' methods to write to each database rather than just 
one.  If you want to get sophisticated, you can multi-thread it so that the 
writes take place in parallel.
                                                         -Mike