Question about triggers

2009-02-02 Thread Tobias Stocker
Hy there, I'm planing to to build a small partial replication on MySQL 5.0 using the Spread Toolkit and the Message API for MySQL. Therefore I'll create a trigger (on insert) which fetches the row and sends it to the message group XY. I was wondering if there is a way to tell MySQL in an SQL

Re: Question about triggers

2009-02-02 Thread Baron Schwartz
Send the value of @@server_id in the message, and make sure each server has a unique value for that. Compare the value in the received message to the value in the server and see whether you should stop the loop. On Mon, Feb 2, 2009 at 4:38 AM, Tobias Stocker tobias.stoc...@ch.netstream.com