Introduction
Learn how to use MariaDB and MySQL on Pantheon.
Pantheon provides direct access to your databases through our platform for debugging and importing large databases. Pantheon is standardized on MariaDB, but we also support MySQL database connections.
Each site environment (Dev, Test, and Live) has a separate database that requires unique credentials. Credentials are automatically included in your site configuration.
About MariaDB and MySQL
MariaDB originated as a fork of MySQL that included enhanced features and performance improvements. MariaDB and MySQL both use the MySQL protocol. However, MariaDB and MySQL have evolved into separate databases.
MariaDB provides a full database solution, including:
-
Temporal tables
-
Distributed SQL
-
Columnar storage
CMS Compatibility
This table shows the supported MariaDB version for each CMS:
| CMS | Supported MariaDB Version(s) |
|---|---|
| Drupal < 7.76 | 10.3 |
| Drupal ≥ 7.76 | 10.4 |
| Drupal < 8.5 | 10.3 |
| Drupal ≥ 8.6 | 10.4 |
| Drupal ≥ 9.0 | 10.4 or 10.6 |
| WordPress | 10.4 or 10.6 |
Users of Drupal 6 sites should consider upgrading to the latest version of Drupal for better support.
Considerations - Drupal
The default database version for new Drupal sites is MariaDB 10.4.
If your site has any older contrib modules that are not compatible with MariaDB 10.4, set the MariaDB version of the new site to 10.3 in your pantheon.yml file.
The latest version of Drupal requires MariaDB 10.3 or later. If you have a site that you plan to upgrade, confirm that the database has been upgraded to MariaDB 10.3 or 10.4 in all environments before you begin the upgrade.
Confirm that the database upgrade completed successfully using the steps at the beginning of Specify a Version of MariaDB.