I have this technical task, 2 times this week.
我有这个技术任务，本周2次。
Task consist to link, connect and work with 2 Databases on different servers. Inject the datas from the old DB into the new DB. As this the old DB is use like an accessible backup and the new server will be more light, just get the datas when it needs.
任务包括链接，连接和使用不同服务器上的2个数据库。将旧数据库中的数据注入新数据库。因为旧数据库像可访问备份一样使用，新服务器将更轻，只需在需要时获取数据。
I saw there is relational DB-tables but it needs to be on the same server no ?
我看到有关系数据库表，但它需要在同一台服务器上没有？
Does an online Cloud works this way ?
在线云是否以这种方式工作？
Thanks
谢谢
Noe
诺埃
2 个解决方案
#1
0
You can use distributed tables in MySQL whenever FEDERATED engine is used.
每当使用FEDERATED引擎时，您都可以在MySQL中使用分布式表。
- MySQL -- Joins Between Databases On Different Servers Using Python?
- MySQL - 使用Python在不同服务器上的数据库之间连接？
- I need to join table from other database and sometimes other server
- 我需要从其他数据库和有时其他服务器连接表
- Join tables from two different server
- 从两个不同的服务器加入表
Otherwise you have to create application that will connect both databases and transfer data between them. With any programming language. Even with MS Access :)
否则，您必须创建将连接两个数据库并在它们之间传输数据的应用程序。使用任何编程语言。即使使用MS Access :)
Or use internal replication engine if it suits.
或者如果适合，请使用内部复制引擎。
#2
0
What you need is a service like google cloud,
你需要的是像谷歌云这样的服务，
First you would create VM instance and load balance the mysql connection between two databases.
首先，您将创建VM实例并对两个数据库之间的mysql连接进行负载平衡。
Note** If you want faster or more lean mysqls calls, you should try indexing. try the link below @http://www.infoworld.com/article/2616674/database-administration/10-essential-performance-tips-for-mysql.html
注意**如果你想要更快或更精简的mysqls调用，你应该尝试索引。试试以下链接@http：//www.infoworld.com/article/2616674/database-administration/10-essential-performance-tips-for-mysql.html
#1
0
You can use distributed tables in MySQL whenever FEDERATED engine is used.
每当使用FEDERATED引擎时，您都可以在MySQL中使用分布式表。
- MySQL -- Joins Between Databases On Different Servers Using Python?
- MySQL - 使用Python在不同服务器上的数据库之间连接？
- I need to join table from other database and sometimes other server
- 我需要从其他数据库和有时其他服务器连接表
- Join tables from two different server
- 从两个不同的服务器加入表
Otherwise you have to create application that will connect both databases and transfer data between them. With any programming language. Even with MS Access :)
否则，您必须创建将连接两个数据库并在它们之间传输数据的应用程序。使用任何编程语言。即使使用MS Access :)
Or use internal replication engine if it suits.
或者如果适合，请使用内部复制引擎。
#2
0
What you need is a service like google cloud,
你需要的是像谷歌云这样的服务，
First you would create VM instance and load balance the mysql connection between two databases.
首先，您将创建VM实例并对两个数据库之间的mysql连接进行负载平衡。
Note** If you want faster or more lean mysqls calls, you should try indexing. try the link below @http://www.infoworld.com/article/2616674/database-administration/10-essential-performance-tips-for-mysql.html
注意**如果你想要更快或更精简的mysqls调用，你应该尝试索引。试试以下链接@http：//www.infoworld.com/article/2616674/database-administration/10-essential-performance-tips-for-mysql.html