Setting Up Shared Database Container in Docker [3 methods]

#Docker #Containers #Database

Full steps can be found at https://i12bretro.github.io/tutorials/0858.html

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: https://discord.com/invite/EzenvmSHW8 ★ Reddit: https://reddit.com/r/i12bretro ★ Twitter: https://twitter.com/i12bretro ... https://www.youtube.com/watch?v=NaFqHgP_oVY