The database. A Drupal, Laravel or WordPress project gets MariaDB unless it asks for MySQL or PostgreSQL; a PHP, Go or Node.js project gets a database only by asking.
It can run on the web server or move onto a machine of its own (see Shapes). Either way, your application reaches it the same way.
Transactions run at READ-COMMITTED, which is what Drupal recommends.
Connecting to it
Read the environment; do not commit credentials:
DB_HOST the service name
DB_PORT 3306
DB_DRIVER mysql
DB_NAME
DB_USER
DB_PASSWORD
DATABASE_URL all of it as one connection string
The database, its user and its password are made for the environment and never
change. See Variables for the full list. A Drupal site's
settings.vallic.php reads all of it for you.
Changing it
A version change is one way: a database that has opened its files with a newer MariaDB will usually refuse an older one.
vallic.yaml cannot change which database you run: moving from one to another
is a migration. Ask support.
From your own computer, vallic tunnel <env> db opens it on 127.0.0.1:3306 for a desktop client or a browser. See Tunnels.
Versions
| Version | Status |
|---|---|
11.8 |
Supported, and the default |
11.4 |
Supported |
10.11 |
Supported |
Pin the version, not the build: name 11.8 and the platform matches it to the
current build, so a security rebuild reaches you without anybody editing a
repository.
The version you name is the one your environment runs from the next deploy. This service keeps data, and not every version can read another's — before you change it, read Changing a service's version.
What you can change
In vallic.yaml — what each one does is on Service settings:
services:
- mariadb:
version: '11.8'
environment:
MYSQL_MAX_ALLOWED_PACKET: …
MYSQL_INNODB_BUFFER_POOL_SIZE: …
MYSQL_MAX_CONNECTIONS: …
MYSQL_SLOW_QUERY_LOG: …
MYSQL_LONG_QUERY_TIME: …
Anything not on this list refuses the deploy, naming the variable — rather than being accepted and quietly ignored.
Thank you. Good to know it helped.
Thanks — tell us what was missing. Open a ticket from Support in the console, and we answer on the ticket. Open the console