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
You can use distributed tables in MySQL whenever FEDERATED engine is used.
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.
What you need is a service like google cloud,
First you would create VM instance and load balance the mysql connection between two databases.
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