The Ultimate Guide to High Availability with MariaDB

Comments - Cross-Engine join on external server

6 years, 5 months ago Andrew Hutchings
Re: Cross-Engine join on external server [Answer]

Technically it is possible but we do not officially support it. To do this you would need identical InnoDB schemas on the local sever for all the tables on the remote so the parser can execute the query. You might be better off using the CONNECT engine or similar and doing a local cross-engine join to that.

 
6 years, 5 months ago Mike Thibodeau
Re: Cross-Engine join on external server

Thanks Andrew! Once set up can I use a cross-engine join in and update or delete statement or is it only permitted in select statements?

 
6 years, 5 months ago Andrew Hutchings
Re: Cross-Engine join on external server

It is only used for SELECT statements. INSERT, UPDATE and DELETE are processed using regular storage engine calls.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.