elestio/mariadb
Mariadb, verified and packaged by Elestio
10K+
A better community platform for the modern web.
MariaDBMariaDB is a Opensource relational Database.
Deploy a fully managed MariaDB on elest.io The open source relational database.
You can deploy it easily with the following command:
git clone https://github.com/elestio-examples/mariadb.git
Copy the .env file from tests folder to the project directory
cp ./tests/.env ./.env
Edit the .env file with your own values.
Run the project with the following command
docker-compose up -d
You can access the Web UI at: http://your-domain:3306
Here are some example snippets to help you get started creating a container.
version: "3.3"
services:
mariadb:
image: elestio/mariadb:${SOFTWARE_VERSION_TAG}
volumes:
- data:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: ${SOFTWARE_PASSWORD}
MYSQL_DATABASE: ${MYSQL_DATABASE}
MYSQL_USER: ${MYSQL_USER}
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
ports:
- "172.17.0.1:3306:3306"
restart: on-failure
pma:
image: phpmyadmin/phpmyadmin
restart: always
links:
- mariadb:mariadb
ports:
- "172.17.0.1:24581:80"
environment:
PMA_HOST: ${PMA_HOST}
PMA_PORT: ${PMA_PORT}
PMA_USER: ${PMA_USER}
PMA_PASSWORD: ${SOFTWARE_PASSWORD}
UPLOAD_LIMIT: ${UPLOAD_LIMIT}
MYSQL_USERNAME: ${MYSQL_USERNAME}
MYSQL_ROOT_PASSWORD: ${SOFTWARE_PASSWORD}
depends_on:
- mariadb
volumes:
data:
Variable | Value (example) |
---|---|
SOFTWARE_VERSION_TAG | latest |
SOFTWARE_PASSWORD | your example |
TEST_URL | http://yourdomain:24581 |
MYSQL_DATABASE | your-db-name |
MYSQL_USER | your-db-user |
MYSQL_PASSWORD | your-db-pass |
PMA_HOST | mariadb |
PMA_PORT | 3306 |
PMA_USER | root |
UPLOAD_LIMIT | 500M |
MYSQL_USERNAME | your-mysql-name |
The Elestio MariaDB Docker image sends the container logs to stdout. To view the logs, you can use the following command:
docker-compose logs -f
To stop the stack you can use the following command:
docker-compose down
To make backup and restore operations easier, we are using folder volume mounts. You can simply stop your stack with docker-compose down, then backup all the files and subfolders in the folder near the docker-compose.yml file.
Creating a ZIP Archive For example, if you want to create a ZIP archive, navigate to the folder where you have your docker-compose.yml file and use this command:
zip -r myarchive.zip .
Restoring from ZIP Archive To restore from a ZIP archive, unzip the archive into the original folder using the following command:
unzip myarchive.zip -d /path/to/original/folder
Starting Your Stack Once your backup is complete, you can start your stack again with the following command:
docker-compose up -d
That's it! With these simple steps, you can easily backup and restore your data volumes using Docker Compose.
docker pull elestio/mariadb