Re: Replication for reporting

2008-05-21 Thread Ben Clewett
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

RE: Replication for reporting

2008-05-21 Thread Yong Lee
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