elestio/mysql

Verified Publisher

By Elestio

Updated about 1 month ago

Mysql, verified and packaged by Elestio

Image
Data Science
Databases & Storage
Security
1

50K+

elest.io

DiscordElestio examplesBlog

MySQL, verified and packaged by Elestio

MySQL is an open-source relational database management system (RDBMS). Many of the world's largest organizations rely on it to power their high-volume websites, business-critical systems and packaged software. It runs on almost all platforms, including Linux, UNIX and Windows.

Deploy a fully managed MySQL on elest.io if you want automated backups, reverse proxy with SSL termination, firewall, automated OS & Software updates, and a team of Linux experts and open source enthusiasts to ensure your services are always safe, and functional.

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

Docker-compose

Here are some example snippets to help you get started creating a container.

version: "3"
services:
mysql:
    image: elestio/mysql:${SOFTWARE_VERSION_TAG}
    restart: always
    command: mysqld --default-authentication-plugin=mysql_native_password --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --max_connections=1000 --gtid-mode=ON --enforce-gtid-consistency=ON
    environment:
        MYSQL_ROOT_PASSWORD: ${SOFTWARE_PASSWORD}
    ports:
        - 172.17.0.1:3306:3306
    volumes:
        - ./data:/var/lib/mysql

pma:
    image: phpmyadmin
    restart: always
    links:
        - mysql:mysql
    ports:
        - "172.17.0.1:24581:80"
    environment:
        PMA_HOST: mysql
        PMA_PORT: 3306
        PMA_USER: root
        PMA_PASSWORD: ${SOFTWARE_PASSWORD}
        UPLOAD_LIMIT: 500M
        MYSQL_USERNAME: root
        MYSQL_ROOT_PASSWORD: ${SOFTWARE_PASSWORD}
    depends_on:
        - mysql
Environment variables
VariableValue (example)
SOFTWARE_PASSWORDyour-password
SOFTWARE_VERSION_TAG8.0 or latest

Access

You can access the Web UI at: http://your-domain:24581

Maintenance

Logging

The Elestio MySQL 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/mysql