List:General Discussion« Previous MessageNext Message »
From:neubyr Date:January 30 2014 10:40pm
Subject:Re: LOAD DATA in replication
View as plain text  
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.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.
>>
>> -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
>
>

Thread
LOAD DATA in replicationneubyr30 Jan 2014
  • Re: LOAD DATA in replicationAntonio Fernández Pérez30 Jan 2014
  • Re: LOAD DATA in replicationshawn l.green30 Jan 2014
    • Re: LOAD DATA in replicationneubyr30 Jan 2014
  • link-bughsv30 Jan 2014