MariaDB

Lade officially supports deploying MariaDB databases.

Supported Versions

The following MariaDB versions are supported and receive security updates:

• 11.6
• 11.4
• 11.2
• 10.11
• 10.6
• 10.5

Provisioning MariaDB

A MariaDB addon can be provisioned with the CLI:

$ lade addons create mariadb --name mydb

You will be prompted to select an available plan, region, and version.

Attaching to Your App

Your MariaDB addon can be attached to your app with the CLI:

$ lade addons attach mydb --app myapp

When your addon is attached, the DATABASE_URL and MARIADB_URL environment variables will be added to your app.

You can confirm these environment variables were added to your app with the lade env list command.

Accessing Your Database

To access your database remotely, you will need to enable public access on your addon. You can view settings with the lade addons show command. The addon URI will follow the format:

mariadb://<user>:<password>@<host>:<port>/<dbname>

You can access your remote database with the mysql command:

$ mysql -u <user> -p<password> -h <host> -P <port> <dbname> --ssl
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 11.6-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [dbname]>