Database Server Types
Database Server Types¶
DDEV-Local supports most versions of MariaDB and MySQL database servers, but of course the two types are mutually exclusive.
The default database type is MariaDB, and the default version is currently 10.2, but you can use nearly any MariaDB version (5.5 through 10.5) and nearly any MySQL version (5.5 through 8.0). For example, you can use
ddev config --mariadb-version="" --mysql-version=5.7 to configure for MySQL 5.7.
In the config.yaml, either
mariadb_version should be left blank, for example:
mysql_version: "" mariadb_version: 10.5
mariadb_version: "" mysql_version: 8.0
- If you change the database type or version in an existing project, the existing database may not be compatible with your change, so you'll want to use
ddev export-dbto save a dump first.
- When you change database type, it's best to destroy the existing database using
ddev stop --remove-databefore changing, then use
ddev import-dbto import the db you already exported.
- Despite those warnings, the db container will do its best to upgrade if you're upgrading from compatible versions. For example, a change from MariaDB 10.1 to 10.4 is likely to work and upgrade correctly, but your mileage may vary. If you change from MySQL 8.0 to MariaDB 5.5, all hell will break loose and you'll have to
ddev stop --remove-data --omit-snapshotto get back where you were.
- Snapshots are always per database type and database version. So if you have snapshots from MariaDB 10.2 and you switch to MariaDB 10.5, don't expect to be able to restore the old snapshot.