You might be able to do it with the federated engine:
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
Andrey Dmitriev wrote:
> Is it true that a single mysql server can be a slave to only one master?
> So if you need to replicate a dozen databases into a single reporting
> server, you need to have a chain of a dozen servers in between? Someone
> shared that to me, but it didn't make much sense.
> In oracle we have the following options to replicate:
> Snapshots (also known as materialized views) for individual tables
> Standby (similar to mysql, but replicates the entire db)
> Streams (pick whatever you need out of sql stream)
> So for reporting purposes from multiple db's, you'd mostly likely pick
> snapsohts or streams.