MySQL

MySQL is able to be used as an external data source. Either an entire database or a single table may be added as a data source.

External database

An entire MySQL database can be added using the CREATE EXTERNAL DATABASE command.

There are two equivalent formats. In both formats, database-name will be the name of the database inside GlareDB. This cannot be qualified, and must be unique across all other databases in the deployment.

External database long format

CREATE EXTERNAL DATABASE <database-name>
 FROM mysql
 [TUNNEL <tunnel-name>]
 OPTIONS (
  host = '<host>',
  port = '<port>',
  user = '<user>',
  password = '<password>',
  database = '<database>',
 );

External database long format options

External database compact format

CREATE EXTERNAL DATABASE <database-name>
 FROM mysql
 [TUNNEL <tunnel-name>]
 OPTIONS (
  connection_string = '<connection-string>',
 );

External database compact format options

External table

Adding an external table can be done through the CREATE EXTERNAL TABLE command.

There are two equivalent formats. In both formats, table-name will be the name of the database inside GlareDB. table-name may optionally be qualified with a schema name.

External table long format

CREATE EXTERNAL TABLE <table-name>
 FROM mysql
 [TUNNEL <tunnel-name>]
 OPTIONS (
  host = '<host>',
  port = '<port>',
  user = '<user>',
  password = '<password>',
  database = '<database>',
  schema = '<schema>',
  table = '<table>',
 );

External table long format options

External table compact format

CREATE EXTERNAL TABLE <table-name>
 FROM MySQL
 [TUNNEL <tunnel-name>]
 OPTIONS (
  connection_string = '<connection-string>',
  schema = '<schema>',
  table = '<table>',
 );

External table compact format options