Background School Corp. It has two databases with a common table, employees. These two databases are located at the company's offices in New York and Atlanta. Client computers connect to databases to make changes. If employees join the New York office, information related to them should also be available at the Atlanta office. Two databases are available from any company office. You, as the database administrator, should verify that any insertions or changes to the data are made in a common table, and the changes are reflected in both locations. How do you perform this operation?
Questions: 1. From the information provided, it appears that the employee table is present in two separate databases, but is somehow related to the fact that the update performed in the employee table in NY db creates an update in the Atlanta database ... How is it is it possible to connect two databases in this way?
Is there a link in the MySQL manual (5.1 and above) that explains how to connect two separate databases via a “common” table?
This is common practice (with two separate databases connecting via a common table)
Thanks for your time and for any discussions.
source
share