mysql linked server | Mysql one server to another mysql server linked

Mysql Linked Server

** Here is no server-to-server link feature. This is Paid version of Oracle feature. ** 

So you can user FEDERATED Storage Engine

For more Information to go through:
https://universalmaple.blogspot.com/2018/11/how-can-i-enable-federated-engine-in.html