MySQL 学生数据库
背景 School Corp. 有两个数据库，并有一个公共表：employees。这两个数据库位于该公司位于纽约和亚特兰大的办公室。客户端计算机连接到数据库以进行更改。如果员工在纽约办事处加入，则亚特兰大办事处也应该提供与他们相关的信息。这两个数据库都可以从公司办公室访问。作为数据库管理员，您需要检查公共表中是否进行了任何数据插入或修改，并且更改是否反映在两个位置。您将如何执行此操作？
问题： 1. 从提供的信息来看，员工表存在于两个单独的数据库中，但以某种方式链接在一起，以便在纽约数据库中的员工表中执行的更新会在亚特兰大数据库中创建更新...这怎么可能以这种方式连接两个数据库？
MySQL 手册（5.1 及更高版本）中是否有参考资料解释了通过“公共”表连接 2 个独立数据库的方法？
这是一种常见的做法吗（有 2 个单独的数据库通过一个公用表连接）
感谢您的时间和任何讨论。
Background School Corp. 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 the databases to make changes. If employees join at the New York office, the information pertaining to them should be available at the Atlanta office as well. The two databases are accessible from either of the company office. You as the database administrator need to check that any data inserts or modifications are made in the common table and the changes are reflected at both locations. How will you perform this operation?
Questions:
1. From the information provided it appears that the employees table is present in two seperate databases, but are somehow linked so that an update performed in the employees table in the NY db creates an update in the Atlanta database... How is it possible to connect two databases in this manner?
Is there a reference in the MySQL Handbook (5.1 and above) that explains the means for connecting 2 seperate databases through a "common" table?
Is this a common practice (having 2 seperate databases connecting through a common table)
Thank you for your time and any discussion.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
查看 MySQL 复制。
Look into MySQL Replication.