Introducing our new CEO Don Johnson - Read More

elestio/mariadb

Verified Publisher

By Elestio

Updated about 23 hours ago

Mariadb, verified and packaged by Elestio

Image
Databases & Storage
1

10K+

elest.io

DiscordElestio examplesBlog

MariaDB, verified and packaged by Elestio

A better community platform for the modern web.

MariaDBMariaDB is a Opensource relational Database.

mariadb

Deploy a fully managed MariaDB on elest.io The open source relational database.

deploy

Why use Elestio images?

  • Elestio stays in sync with updates from the original source and quickly releases new versions of this image through our automated processes.
  • Elestio images provide timely access to the most recent bug fixes and features.
  • Our team performs quality control checks to ensure the products we release meet our high standards.

Usage

Git clone

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

Docker-compose

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:
Environment variables
VariableValue (example)
SOFTWARE_VERSION_TAGlatest
SOFTWARE_PASSWORDyour example
TEST_URLhttp://yourdomain:24581
MYSQL_DATABASEyour-db-name
MYSQL_USERyour-db-user
MYSQL_PASSWORDyour-db-pass
PMA_HOSTmariadb
PMA_PORT3306
PMA_USERroot
UPLOAD_LIMIT500M
MYSQL_USERNAMEyour-mysql-name

Maintenance

Logging

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

Backup and Restore with Docker Compose

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.

Links

Docker Pull Command

docker pull elestio/mariadb