Re: How to create DB link in MySQL
Posted by: Peter Brawley
Date: September 12, 2020 03:57PM

Again, the preferred way is to replicate data to a server that has all data required for such a query.

Failing that, the "Federated" storage engine allows limited inter-server functionality.

Otherwise you'll need to bring the two datasets together in the buffers of an app (PHP, C# &c) and emulate the Join logic there.

Options: ReplyQuote

Written By
September 12, 2020 09:08AM
September 12, 2020 09:32AM
Re: How to create DB link in MySQL
September 12, 2020 03:57PM
February 22, 2021 08:31AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.