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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]