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.
On Thu, Jan 30, 2014 at 7:48 AM, shawn l.green <shawn.l.green@stripped>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.
> 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