the problem with REPLICATE syntax is that it has usability problems unless typed by a DBA directly. Suppose the CHECK TABLE or whatever is a part of a stored procedure, then the developer would have to add some extra logic to determine if we do 'CHECK TABLE' or 'REPLICATE CHECK TABLE'.?
I share your dislike for variable magic and for generalization of anything. How about SET REPLICATION OFF; CHECK TABLE ... a good analogy IMO: 1. SET AUTOCOMMIT ON; DELETE FROM foo; 2. set @auto_commit=0; DELETE FROM foo; 3. COMMIT DELETE FROM foo; 4. DELETE FROM foo WITH_COMMIT; of course a true revolutionary would try to implement one of the latter two solutions :) I could also imagine SET REPLICATION OFF; DELETE FROM foo; or its? @replicator.enable equivalent is a nice general solution even though it allows unsound application programming practices. Thank you, Michael Izioumtchenko -----Original Message----- From: Stewart Smith <[email protected]> To: Jay Pipes <[email protected]> Cc: drizzle-discuss Discuss <[email protected]>; [email protected] Sent: Wed, 1 Apr 2009 11:57 pm Subject: Re: [Drizzle-discuss] Replication behaviour with REPAIR, OPTIMIZE, and ANALYZE TABLE On Wed, Apr 01, 2009 at 03:03:42PM -0400, Jay Pipes wrote: > SET @replicator.enabled= FALSE; > /* do some commands... */ > SET @replicator.enabled= TRUE; minus minus I generally don't like variable settings that magically change behaviour... and I don't like the idea of generally disabling replication for some things - smells like good ways to shoot your foot off in having master and slave be consistent. I still prefer REPLICATE syntax... -- 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
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
