mysql Docker container service for Gearbox

This is the repository for the mysql Docker container implemented for Gearbox.

Repository Info

GitHub commit:

GitHub release(latest):

Supported versions and respective Dockerfiles

Service	GitHub Version	Docker Version	Docker Size	Docker Tags
mysql				(5.5.62, 5.5)
mysql				(5.6.48, 5.6)
mysql				(5.7.30, 5.7)
mysql				(8.0.20, 8.0, latest)

About this container.

A driving force behind Gearbox is to improve the user experience using software, and especially for software developers.

Our vision is to empower developers and other software users to quickly and easily use almost any version of a software service, command line tool or API without without first getting bogged down with installation and configuration.

In other words, our vision for Gearbox users is that software "just works".

Using this container.

This container has been designed to work within the Gearbox framework. However, due to the flexability of Gearbox, it can be used outside of this framework.

There are three methods:

Method 1: Using launch

launch is a tool specifically designed to interact with a Gearbox Docker container.

It provides three important functional areas, without any Docker container learning curve:

• Allows control over Gearbox Docker containers: stop, start, create, remove.
• Build, update, modify and release Docker images.
• Acts as a proxy for interactive commands within a Gearbox Docker container.

It also provides a functional SSH daemon for connecting remotely as well as a standard set of common tools and utilities.

Further launch documentation can be found here.

Download launch

launch is currently in beta testing and is included along with all Gearbox Docker repos. Once out of beta, it will be included within the Gearbox installation package.

For now, simply download the standalone launch binary for your O/S.

• Mac OSX 64bit
• Linux 64bit
• Windows 64bit

Running launch

There are many ways to call launch, either directly or indirectly. Additionally, all host environment variables will be imported into the container seamlessly. This allows a devloper to try multiple versions of software as though they were installed locally.

If a container is missing, it will be downloaded and created. Multiple versions can co-exist.

Install, create, and start the mysql Gearbox container.

./launch install mysql

Create, and start the mysql Gearbox container. Run a shell.

./launch shell mysql

Create, and start the mysql Gearbox container with version 5.5.62 and run a shell.

./launch shell mysql:5.5.62

./launch shell mysql:5.5.62 ls -l

./launch shell mysql:5.5.62 ps -eaf

Available commands

If mysql is symlinked to launch, then the Gearbox container will be determined automatically and the default command will be run. All available commands for a Gearbox container will be automatically symlinked upon installation.

./mysql

Running mysql Gearbox container default command. If a container has a default interactive command, arguments can be supplied without specifying that command.

./mysql -flag1 -flag2 variable

./launch mysql:5.5.62 -flag1 -flag2 variable

Gearbox containers may have multiple executables that can be run. The mysql Gearbox container has the following available commands:

• The default command will execute /usr/bin/mysql within the container.
• mysql - will execute /usr/bin/mysql within the container.
• mysql_config_editor - will execute /usr/bin/mysql_config_editor within the container.
• mysql_secure_installation - will execute /usr/bin/mysql_secure_installation within the container.
• mysql_ssl_rsa_setup - will execute /usr/bin/mysql_ssl_rsa_setup within the container.
• mysql_tzinfo_to_sql - will execute /usr/bin/mysql_tzinfo_to_sql within the container.
• mysql_upgrade - will execute /usr/bin/mysql_upgrade within the container.
• mysqladmin - will execute /usr/bin/mysqladmin within the container.
• mysqlbinlog - will execute /usr/bin/mysqlbinlog within the container.
• mysqlcheck - will execute /usr/bin/mysqlcheck within the container.
• mysqld_multi - will execute /usr/bin/mysqld_multi within the container.
• mysqld_safe - will execute /usr/bin/mysqld_safe within the container.
• mysqldump - will execute /usr/bin/mysqldump within the container.
• mysqldumpslow - will execute /usr/bin/mysqldumpslow within the container.
• mysqlimport - will execute /usr/bin/mysqlimport within the container.
• mysqlpump - will execute /usr/bin/mysqlpump within the container.
• mysqlshow - will execute /usr/bin/mysqlshow within the container.
• mysqlslap - will execute /usr/bin/mysqlslap within the container.

Remote connection

ssh - All Gearbox containers have a running SSH daemon. So you can connect remotely. To show what ports are exported to the host, use the following command.

./launch list mysql

Method 2: GitHub repo

Setup from GitHub repo

Simply clone this repository to your local machine

git clone https://github.com/gearboxworks/docker-mysql.git

Building from GitHub repo

make build - Build Docker images. Build all versions from the base directory or specific versions from each directory.

make list - List already built Docker images. List all versions from the base directory or specific versions from each directory.

make clean - Remove already built Docker images. Remove all versions from the base directory or specific versions from each directory.

make push - Push already built Docker images to Docker Hub, (only for Gearbox admins). Push all versions from the base directory or specific versions from each directory.

Runtime from GitHub repo

You can either build your container as above, or use it from DockerHub with these commands:

make start - Spin up a Docker container with the correct runtime configs.

make stop - Stop a Docker container.

make run - Run a Docker container in the foreground, (all STDOUT and STDERR will go to console). The Container be removed on termination.

make shell - Run a shell, (/bin/bash), within a Docker container.

make rm - Remove the Docker container.

make test - Will issue a stop, rm, clean, build, create and start on a Docker container.

Method 3: Docker Hub

Setup from Docker Hub

A simple docker pull gearbox/mysql will pull down the latest version.

Starting

start - Spin up a Docker container with the correct runtime configs.

docker run -d --name mysql-latest --restart unless-stopped --network gearboxnet gearbox/mysql:latest

Stopping

stop - Stop a Docker container.

docker stop mysql-latest

Remove container

rm - Remove the Docker container.

docker container rm mysql-latest

Run in foreground

run - Run a Docker container in the foreground, (all STDOUT and STDERR will go to console). The Container be removed on termination.

docker run --rm --name mysql-latest --network gearboxnet gearbox/mysql:latest

Run a shell

shell - Run a shell, (/bin/bash), within a Docker container.

docker run --rm --name mysql-latest -i -t --network gearboxnet gearbox/mysql:latest /bin/bash

SSH

ssh - All Gearbox containers have a running SSH daemon. So you can connect remotely.

Either use launch above or discover the port and SSH directly.

SSH_PORT="$(docker port mysql-latest 22/tcp | sed 's/0.0.0.0://')"
ssh -p ${SSH_PORT} -o StrictHostKeyChecking=no gearbox@localhost