List:General Discussion« Previous MessageNext Message »
From:Tom Worster Date:November 30 2009 5:25pm
Subject:Re: Is LOAD INDEX INTO CACHE replicated?
View as plain text  
Thank you for the answer. This makes sense.

As such, the questions of preloading the key buffer in a replication system
are probably resolved. I think I can safely put CACHE INDEX and LOAD INDEX
INTO CACHE statements in the --init-file of both masters and slaves.

tom


On 11/29/09 8:39 AM, "Johan De Meersman" <vegivamp@stripped> wrote:

> They're not data modification statements, so no, they're not replicated.
> 
> On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster <fsb@stripped> wrote:
> 
>> Are SQL statements like CACHE INDEX or LOAD INDEX INTO CACHE replicated?
>> 
>> If so, is there a way to prevent that replication?
>> 
>> If a slave mysqld restarts, wouldn't it need to execute CACHE INDEX and
>> LOAD
>> INDEX INTO CACHE statements from its --init-file?
>> 
>> And if a master mysql restarts, would the slave execute CACHE INDEX and
>> LOAD
>> INDEX INTO CACHE statements the master reads from its --init-file and
>> writes
>> to the big-log?
>> 
>> tom
>> 
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>> 
>> 


Thread
Is LOAD INDEX INTO CACHE replicated?Tom Worster29 Nov
  • Re: Is LOAD INDEX INTO CACHE replicated?Johan De Meersman29 Nov
    • Re: Is LOAD INDEX INTO CACHE replicated?Tom Worster30 Nov