Ben Ricker wrote:
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned
EMAIL
PROTECTED]>,
rs.com> "'[EMAIL PROTECTED] '" <[EMAIL
PROTECTED]>
cc:
05/18/2004
Are you using only MyISAM or InnoDB tables? With the InnoDB tables you have
the possibility of data not yet being committed. Either way, unless you can
flush, lock and perform the dump and transfer all in one swoop you risk
incosistency using this method.
-Original Message-
From: Ben Rick
