Using LOAD TABLE FROM MASTER
where the master
is running MySQL 4.1 and the slave is running MySQL 5.0 may
corrupt the table data, and is not supported. (Bug#16261)
The LOAD DATA
INFILE
statement's CONCURRENT
option is not replicated; that is, LOAD DATA CONCURRENT
INFILE
is replicated as
LOAD DATA
INFILE
, and LOAD DATA CONCURRENT LOCAL
INFILE
is replicated as
LOAD DATA LOCAL
INFILE
. (Bug#34628)
The following applies only if either the master or the
slave is running MySQL version 5.0.3 or older: If on
the master a LOAD
DATA INFILE
is interrupted (integrity constraint
violation, killed connection, and so on), the slave skips the
LOAD DATA
INFILE
entirely. This means that if this command
permanently inserted or updated table records before being
interrupted, these modifications are not replicated to the
slave.
User Comments
Add your own comment.