MariaDB / MySQL Adapter

This adapter allows mapping existing tables on a remote MariaDB or MySQL database into the schema of Polypheny-DB. One adapter can map multiple tables. This allows push-down of larger portions of a query. While the schema must be static and cannot be changed with Polypheny-DB, the data on the remote tables can be updated independently of Polypheny-DB. Polypheny-DB connects to the remote database system as a client and providing full support for transactions.

Please note that for license reasons, this adapter is not part of packed releases.

Adapter Settings

The adapter has the following settings:

hostThe name or IP address of the remote MariaDB or MySQL instance.
portThe JDBC port number on the remote MariaDB or MySQL instance.
databaseThe name of the database containing the tables to be mapped.
usernameThe username to be used for authenticating at the remote MariaDB or MySQL instance.
passwordThe password to be used for authenticating at the remote MariaDB or MySQL instance.
maxConnectionsThe maximum number of concurrent JDBC connections.
transactionIsolationWhich level of transaction isolation should be used. Available options: SERIALIZABLE, READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ
tablesList of tables which should be imported. The names must to be separated by a comma.


The adapter can either be deployed using the Polypheny-UI (Adapters -> Sources) or using the following SQL statement:

   USING 'org.polypheny.db.adapter.jdbc.sources.MysqlSource' 
   WITH '{mode:"remote",database:"polypheny",host:"localhost",maxConnections:"25",password:"polypheny",username:"polypheny",port:"3306",transactionIsolation:"SERIALIZABLE",tables:"foo,bar"}'

Please make sure to adjust the settings according to your needs.

After the deployment, the specified tables are mapped into the public schema of Polypheny-DB. The tables and columns can be renamed. Furthermore, columns can be reordered and dropped (this is handled virtually; schema modifications are not forwarded to the remote database system). Dropped columns can be added again using the Polypheny-UI or the following SQL statement:

ALTER TABLE tableName ADD COLUMN physicalName AS name

physicalName thereby refers to the column name on the remote database system.