Just to add - the replacement for DBMirror.pl automatically works out
the schema in use and will replicate using DBmirror from 7.x or from
8.x (table names all changed!). This is done transparently.
I also wrote a short article at
http://www.whitebeam.org/library/guide/TechNotes/replicate.rhtm
sday, May 13, 2004 4:10 PM
Subject: Re: [GENERAL] dbmirror
> Does dbmirror do that? No, it does not. It also doesn't support
> promoting a slave database to a master; that has to be done manually, so
> I wouldn't consider that too big a problem.
>
> Worse in my opinion is th
Does dbmirror do that? No, it does not. It also doesn't support
promoting a slave database to a master; that has to be done manually, so
I wouldn't consider that too big a problem.
Worse in my opinion is that sequences don't get updated... so a slave
that tries to do an insert on a replicated t
On Wed, May 12, 2004 at 05:53:05PM -0700, Gregory S. Williamson wrote:
> Fred --
>
> Yes, the slave database(s) can be safely used in a R/O mode,
Does it also block write transactions in those slaves? The ability
for clients to write into the slave replicated tables is a problem,
because it ma
