Hello,
I am trying to see if replication (or some open source software) can help me....
I have a multiple external databases that have the exact same table structure. They need to be merged into a central database on a nightly basis. The only difference between the external and central database table structure is that every table in the central database has an additional column indicating which external database the row came from.
I've looked into replication on the mysql website (also google groups) and it seems that replication only supports a loop type structure ( A>B>C>A). I am using more of a A > C < B type structure. I am trying to stay away from using queries and inserts into the central database if possible.
If anyone has dealth with this scenario before or know a good place to look, please let me know.
Murray
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
