Re: MySQL Replication

[Paul Baker <pbaker@xxxxxxxxxxxxxxx>]

Michael McConnell wrote:
> Keep in mind, there are no *real time* replication methods available for
> MySQL. Running with MySQL's building Replication commonly results (at least
> with a 6 gig / 400 megs changing) in as much as 1 hour of data
> inconsistency. The only way to get true real time is to use a shared storage
> array.
MySQL builtin replication is supposed to be "realtime" AFAIK. It should 
only fall behind when the slave is doing selects against a database that 
causes changes to wait until the selects are complete. Unless you have a 
select that is taking an hour, there is no reason it should fall that 
far behind. Have you discussed your findings with the MySQL developers?
--
=======================================================================
Paul J. Baker                                Internet Systems Developer
pbaker@xxxxxxxxxxxxxxx                                  Where2GetIt.com
phone 847-498-0111x234
fax   847-480-7422
=======================================================================