You might be able to do it with the federated engine:
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Fire a trigger on your main tables which update some row in a foreign
MySql database used for accounting. I've not tried this but the theory
is sound.
Ben
Andrey Dmit
yes, one master to multiple slaves.
I believe u can set up multiple mysql instances on a single machine with
each mysql instance collecting from a different master.
Yong.
-Original Message-
From: Andrey Dmitriev [mailto:[EMAIL PROTECTED]
Sent: May 21, 2008 11:29 AM
To: mysql@lists.mys