MariaDB

Overview

Field	Value
Purpose	Shared MySQL-compatible relational database
Business function	Persistent application data
Owner	IT Operations; database ownership to be verified
Criticality	High
Image	mariadb:11.5

Architecture

MariaDB is reachable by Adminer and other authorized clients on the backend Docker network.

Installation

Docker Compose at /root/mariadb/docker-compose.yml.

Configuration

• Data: /root/mariadb/data:/var/lib/mysql
• Network: backend
• Container port: 3306
• Restart policy: always
• Environment: MARIADB_ROOT_PASSWORD, MARIADB_HOME

Operational Procedures

cd /root/mariadb
docker compose logs --tail=200 mariadb
docker exec mariadb mariadb-admin ping -uroot -p
docker compose restart mariadb
docker compose pull
docker compose up -d

Create logical dumps with mariadb-dump before upgrades and verify a restore into a non-production database.

Troubleshooting

• Check logs, disk capacity, credentials, and database grants.
• Confirm the client is on backend.
• Do not delete InnoDB files to resolve a startup error.

Related Systems

• Adminer
• Docker Engine