是否可以将2个数据库MySQL连接在不同的服务器上？ 像一个可访问的备份

Question

I have this technical task, 2 times this week.

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.

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

Answer 1

You can use distributed tables in MySQL whenever FEDERATED engine is used.

• MySQL -- Joins Between Databases On Different Servers Using 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 :)

Or use internal replication engine if it suits.