I have two different MySQL instances that I would like to 'slave' to a third instance. (so I can do easy joins on the third instance)
mysql1> show databases db1 db2 mysql2> show databases db3 db4 mysql3> show databases db1 db2 db3 db4
I've looked at maatkit (percona toolkit) pt-table-sync but people say it can corrupt data. (It apparent removes and re-adds data to generate inserts)
pt-archiver sort of works for 'snapshots', but db1 is approximately 6GB and copying the whole thing over is a lot more data than really needed. The real time updates are only about 100MB a day.
The natural concept to me would be to allow mysql3 to run as a replica slave of BOTH mysql1 and mysql2, but that doesn't seem to be an option in MySQL
Tungsten Replicator seems to allow for this type of data sync, but it seems a bit unwieldy to configure and I'm concerned about reliability.
Does anyone have other solutions they've used for this problem?