Thanks for the details Shawn. So row based replication would avoid server side LOAD DATA on slave. Unfortunately, the Master is using MySQL ver 5.0, so I don't think it can use row based replication.
- thanks, N On Thu, Jan 30, 2014 at 7:48 AM, shawn l.green <shawn.l.gr...@oracle.com>wrote: > Hello Neubyr, > > > On 1/29/2014 7:16 PM, neubyr wrote: > >> I am trying to understand MySQL statement based replication with LOAD DATA >> LOCAL INFILE statement'. >> >> According to manual - >> https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html - >> LOAD DATA LOCAL INFILE is replicated as LOAD DATA LOCAL INFILE, however, I >> am seeing it replicated as 'LOAD DATA INFILE'. >> >> I was wondering why slave isn't getting LOAD DATA LOCAL INFILE statements. >> Appreciate any help on this. >> >> Master is using MySQL 5.0 and slave is using MySQL 5.6. >> >> -thanks, >> N >> >> > The slave is not receiving the file from your local disk. When that file > arrives at the master (due to your LOAD DATA LOCAL ..) it is stored in the > binary log and copied (via replication) to the slave where the slave > performs a server-side LOAD DATA... . This is how STATEMENT-based > replication operates. > > Does that make better sense? > > -- > Shawn Green > MySQL Senior Principal Technical Support Engineer > Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. > Office: Blountville, TN > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
