On 6/1/06, Patrik Wallstrom <[EMAIL PROTECTED]> wrote:
Easy setup: two mysql 5 servers, one running master, the other one is
slave. The database have triggers to create history of rows in history
tables.
What is expected from the slave? Is it expected to run the triggers,
as well as receiving the new row in the history table? Or should it
really run the trigger at all? The history is already done on the
master...
The slave will receive the BINLOG, whatever comes there will be
executed. There are no "triggers" reaction since it would cause
inconsistency for sure, something the devs would not allow. If you
have any more questions check:
http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-replication-faq.html
--
patrik_wallstrom->foodfight->[EMAIL PROTECTED]>+46-733173956
http://www.gnuheter.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
