MariaDB ColumnStore allows columnstore tables to be joined with non-columnstore tables (e.g. MyISAM tables) within a query. The non-columnstore table may be on the MariaDB ColumnStore system OR on an external server that supports MariaDB client connections.
To enable this process, the <CrossEngineSupport> section in Columnstore.xml is configured with connection information.
The following is an example entry in the Columnstore.XML configuration file to gain access to joined tables Single Server MariaDB ColumnStore install. The Host needs to be either 127.0.0.1 or 'localhost':
<CrossEngineSupport> <Host>127.0.0.1</Host> <Port>3306</Port> <User>mydbuser</User> <Password>pwd</Password> </CrossEngineSupport>
For a Multi-Node MariaDB Columnstore Installation, the Host needs to be the IP Address of the User-Module #1 or the Combination User/Performance Module #1.
If the MariaDB Client is is running on an external Server, then it would be the IP Address of that server.
For version 1.2.0 onwards the additional options in the <CrossEngineSupport> section are supported to add SSL/TLS encryption to the connections:
<TLSCA></TLSCA> <TLSClientCert></TLSClientCert> <TLSClientKey></TLSClientKey>
This change should be made while the ColumnStore server is down. In a multi node deployment, the change should be made on the PM1 node only as this will be replicated to other instances upon restart.
Check here on how to make changes via the command line to Columnstore.xml:
ERROR 1815 (HY000): Internal error: IDB-8001: CrossEngineSupport section in Columnstore.xml is not properly configured
ERROR 1815 (HY000): Internal error: fatal error in drizzle_con_connect()(23)(23)
ERROR 1815 (HY000): Internal error: fatal error executing query in crossengine client lib(17)(17)
grant create temporary tables on infinidb_vtable.* to [email protected];
mcsmysql -u mydbuser -p -h 127.0.0.1 > use mydb; > select * from innodb_table limit 10;
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.