Michael, It seemed to replicate just fine. At least in test. (5.1.22RC). I believe that we are using statement level replication which might be triggering the trigger on the slave node. I noticed that the triggers themselves also replicatated to the slaves, which is something I didn't expect. Gary
________________________________ From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Thu 2/21/2008 8:06 AM To: mysql@lists.mysql.com Cc: Gary W. Smith; Baron Schwartz Subject: Re: Column level replication q? On Wed, Feb 20, 2008 at 10:48 AM, Gary W. Smith <[EMAIL PROTECTED]> wrote: > Well, I created the lookup table, created my two triggers (as nothing is ever > updated, just added or removed) and did a bulk one time load and it seems to > work. Now I just need to replicate that to the other server. I'll have to > find my easy button and press it a few times. > > In fact, on the other end, we don't even need to have the same table names. > So we can replicate it just like this with no problem. > > Thanks for the links, > I am curious: I thought that data written by triggers was not replicated, replicating instead the action to call the trigger. I seem to recall that several approaches to logically replicate triggers have been tried, where are we at these days? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful.
