MariaDB as Airlock IAM database

This page describes how to use an MariaDB database with the Airlock IAM database schema.

The chosen data layer has to be well managed and monitored. IAM is not responsible for the operation and backup/recovery. For production usage, the data layer should be clustered.


MariaDB version 10.2 or higher is required for full compatibility with the IAM database schema. See Techzone for information on using older MariaDB versions.

Database settings

In order to use Airlock IAM with MariaDB a JDBC connector/driver library is required.

The following MariaDB database settings may be useful:


Command Line


table names are used case insensitive

Note: use this option to avoid issues with older Demo Configurations using table names in upper case



Schema creation and upgrade

SQLs scripts for MariaDB databases are available here:

SQL File


Creates tables used for Airlock IAM.

Upgrades IAM 7.3 database schema for release IAM 7.4.

Upgrades IAM 7.4 database schema for release IAM 7.5.

Upgrades IAM 7.5 database schema for release IAM 7.6.

Upgrades IAM 7.6 database schema for release IAM 7.7.

Upgrades IAM 7.7 database schema for release IAM 7.8.

See DB Schema Migration IAM 8.0.

Inserts an administrator "admin" with password "password" (works with demo configuration).

For performance tuning hints, see: Performance tuning and scaling best practices

Further information and links