Each of the vendors in my application has their own database. Some vendors are divisions of other companies and have identical contact files. Is there a way, within mySQL, to automatically have any change in the vendor's master contact table replicate in the same table of the database of each associated vendor?
I know how to do this using PHP, but I want to avoid the major rewrite this would require. I am hoping for an all mySQL solution.
The tables are indentical in every respect, except that they are in different databases, all residing on the same server.
Note that this has to be done on a "by table" basis, since there are many other databases with similar tables that I don't want to link.
Start Free Trial
