Setting Up Shared Database Container in Docker [3 methods]
#Docker #Containers #Database
Full steps can be found at https://i12bretro.github.io/tutorials...
The Objective
To setup a single database container that can be used with multiple applications and frontends.
Preparation
01. Pull the Docker images used in the examples by running the following commands in a terminal
mariadb
docker pull mariadb
phpmyadmin
docker pull phpmyadmin
wordpress
docker pull wordpress
Method 1 - Container Links
This method utilizes the --link flag. Container links are a "legacy feature" of Docker and may become deprecated in a future release. Further reading https://docs.docker.com/network/links/
01. Run the following commands in a terminal to setup the container stack using --link
create working directories
mkdir ~/docker/mariadb -p && mkdir ~/docker/wordpress -p
set permissions on working directories
sudo chown "$USER":"$USER" ~/docker -R
run the mariadb docker container
docker run -d --name mariadb -e MYSQL_ROOT_PASSWORD=r00tp@ss -v ~/docker/mariadb:/var/lib/mysql --restart=unless-stopped mariadb:latest
run phpmyadmin container linked to the mariadb container
docker run -d --name phpmyadmin --link mariadb -e PMA_HOST=mariadb -p 8080:80 --restart=unless-stopped phpmyadmin
connect to mysql CLI inside the mariadb container
docker exec -it mariadb mysql --user root -pr00tp@ss
create a new database and service account for wordpress
CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
GRANT ALL ON wordpress.* TO 'wordpress_rw'@'%' IDENTIFIED BY 'W0rdPr3ss!!';
FLUSH PRIVILEGES;
EXIT;
run the wordpress docker container
docker run -d --name wordpress --link mariadb -p 8880:80 -e WORDPRESS_DB_HOST=mariadb -e WORDPRESS_DB_USER=wordpress_rw -e WORDPRESS_DB_PASSWORD='W0rdPr3ss!!' -e WORDPRESS_DB_NAME=wordpress -v ~/docker/wordpress:/var/www/html --restart unless-stopped wordpress
02. Remove the created containers by running the following commands
remove the containers
docker rm wordpress -f && docker rm phpmyadmin -f && docker rm mariadb -f
remove working directories
sudo rm ~/docker/mariadb -R && sudo rm ~/docker/wordpress -R
Method 2 - Docker Networking
Create a Docker network and connect each of the containers to it so they can communicate.
01. Run the following commands in a terminal to setup the container stack using Docker networking
create working directories
mkdir ~/docker/mariadb -p && mkdir ~/docker/wordpress -p
set permissions on working directories
sudo chown "$USER":"$USER" ~/docker -R
create the docker network
docker network create containers
run the mariadb docker container
docker run -d --name mariadb -e MYSQL_ROOT_PASSWORD=r00tp@ss -v ~/docker/mariadb:/var/lib/mysql --network containers --restart=unless-stopped mariadb:latest
run phpmyadmin container
docker run -d --name phpmyadmin -e PMA_HOST=mariadb -p 8080:80 --restart=unless-stopped --network containers phpmyadmin
connect to mysql CLI inside the mariadb container
docker exec -it mariadb mysql --user root -pr00tp@ss
create a new database and service account for wordpress
CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
GRANT ALL ON wordpress.* TO 'wordpress_rw'@'%' IDENTIFIED BY 'W0rdPr3ss!!';
FLUSH PRIVILEGES;
EXIT;
run the wordpress docker container
docker run -d --name wordpress -p 8880:80 -e WORDPRESS_DB_HOST=mariadb -e WORDPRESS_DB_USER=wordpress_rw -e WORDPRESS_DB_PASSWORD='W0rdPr3ss!!' -e WORDPRESS_DB_NAME=wordpress -v ~/docker/wordpress:/var/www/html --network containers --restart=unless-stopped wordpress
02. Remove the created containers and network by running the following commands
remove the containers
docker rm wordpress -f && docker rm phpmyadmin -f && docker rm mariadb -f
remove docker network
docker network rm containers
remove working directories
sudo rm ~/docker/mariadb -R && sudo rm ~/docker/wordpress -R
Method 3 - Exposing Host Ports
Expose ports on the host into the container and connect other containers to the host's exposed port
01. Run the following commands in a terminal to setup the container stack using exposed ports on the host
create working directories
mkdir ~/docker/mariadb -p && mkdir ~/docker/wordpress -p
....Full steps can be found on GitHub [link at the top]
Connect with me and others ###
★ Discord: / discord
★ Reddit: / i12bretro
★ Twitter: / i12bretro