On Wed, Apr 01, 2009 at 12:11:11PM -0400, Jay Pipes wrote: > By administrative commands, I mean the ones in the subject line, and > more. To be exact: > > OPTIMIZE TABLE > ANALYZE TABLE > CHECK TABLE > REPAIR TABLE > FLUSH > RELOAD > CHECKSUM > BACKUP > RESTORE > RESET > LOAD INDEX INTO CACHE > KILL > CACHE INDEX > > What about these?
Maybe we need a REPLICATE keyword to make this explicit? I don't think that the majority of these should, for 99.9% of the time be replicated. CHECKSUM, BACKUP, RESET, LOAD INDEX INTO CACHE, KILL especially. As for CHECK, REPAIR. If it's a bug, then you only *may* have hit it on multiple machines... more likely hardware fault eating your bits... so only need it on one. My idea: default: don't replicate administrative commands htat don't change "rows" (where "rows" includes what would be in datadictionary tables) option to prefix with REPLICATE, which does replicate the command. i.e. injects it into the binlog so slaves downstream will get the command. -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
