This blog post\u00a0describes setting up LAMP stack using containers via docker on different servers. Both the MySQL and Apache docker containers will be hosted on different hosts. We will be using WordPress as the application on the\u00a0LAMP\u00a0stack.<\/p>\n
The containers will be created using Dockerfile. Dockerfiles are the easiest way to configure images, which will be further used to create the containers. Dockerfile can be created on any location. They do not require a specific path or folder structure to be followed. Here we will be using ~\/docker\/mysql for MySQL Dockerfile and ~\/docker\/apache for Apache Dockerfile.<\/p>\n
The Dockerfile used in this article is as below:-<\/p>\n
[js]FROM dockerttnd\/mysqlinfra:2.0
\nMAINTAINER AS Support rahul.jaiswal@tothenew.com
\nADD my.cnf \/etc\/mysql\/
\nADD mysql.sh \/
\nRUN chmod +x mysql.sh
\nADD setup.sql \/
\nADD run.sh \/
\nRUN chmod +x run.sh
\nExpose 3306
\nCMD [&quot;\/run.sh&quot;]
\n[\/js]<\/p>\n
Details regarding the options used in above Dockerfile :-<\/p>\n
1.\u00a0FROM <\/strong>: This specifies the base image from which the MySQL image will be built and further customized. The \u201cdockerttnd\/mysqlinfra:2.0\u201d image will be automatically downloaded. This image has MySQL installed on the container. [js]#!\/bin\/bash 5. RUN chmod +x mysql.sh<\/strong> : In this step we are setting up permissions for mysql.sh to executable. [js] privateipofapachehost<\/strong> is the private IP of host server on which Apache container will be running. [js]#!\/bin\/bash 8. RUN chmod +x run.sh <\/strong>: Setting the permissions for run.sh script to executable. The MySQL container Dockerfile is complete.<\/p>\n Now, we need to create the image using the above Dockerfile. The following image will be used to create MySQL container :- [js]docker build -t mysql ~\/docker\/mysql\/. [\/js]<\/p>\n 2. Create the container using MySQL image built using the above command.<\/p>\n [shell]docker run -itd \u2013restart=always \u2013name mysqldb -v \/data\/mysql:\/var\/lib\/mysql -p 3306:3306 mysql[\/shell]<\/p>\n Explanation of above options :-<\/p>\n 1.\u00a0–restart<\/strong> : This option specifies the restart policies for the container. The restart policy has three options:- The MySQL container is up now. The same can be verified by using command \u00a0 Now, let’s create the Apache web container on the other server.<\/p>\n [js]FROM ubuntu:latest ** ip must be the private ip of the host server of containing the mysql container.<\/em><\/p>\n Now, let’s build the image similar to as we build MySQL image with Dockerfile :-<\/p>\n [js]docker build -t apache ~\/docker\/apache\/.[\/js]<\/p>\n Running the apache container :-<\/p>\n [js]docker run \u2013itd \u2013restart=always \u2013name web -p 80:80 apache [\/js]<\/p>\n Now, the setup is up. We can test the setup by browsing the public IP of the Apache container.<\/p>\n This blog post\u00a0describes setting up LAMP stack using containers via docker on different servers. Both the MySQL and Apache docker containers will be hosted on different hosts. We will be using WordPress as the application on the\u00a0LAMP\u00a0stack. Use-case The containers will be created using Dockerfile. Dockerfiles are the easiest way to configure images, which will […]<\/p>\n","protected":false},"author":563,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3},"categories":[1],"tags":[2310,2311,2309],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/26033"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/563"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=26033"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/26033\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=26033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=26033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=26033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2.\u00a0MAINTAINER AS <\/strong>: This specifies the maintainer\/creator of the images created by the above docker file.
\n3. ADD<\/strong>: my.cnf \/etc\/mysql\/ : ADD option adds the files required for configuration. Here we are providing our my.cnf to be used by MySQL instance. You can use your own my.cnf. The my.cnf is added to \/etc\/mysql\/ location using the above command.
\n4.\u00a0ADD mysql.sh<\/strong> : Now, we are adding\u00a0mysql.sh to the final container. This script contains post install configurations to be applied. The mysql.sh script is as below :-<\/p>\n
\nset -x
\nexec &amp;amp;&amp;gt; test.txt
\nmysql_install_db &amp;amp;
\nsleep 5
\n\/usr\/bin\/mysqld_safe &amp;
\nsleep 6
\n\/usr\/bin\/mysql -uroot &amp;gt;test.txt
\n\/bin\/bash [\/js]<\/p>\n
\n6.\u00a0ADD setup.sql \/<\/strong> : This file contains DB and user settings which will be used by the Apache image to connect to MySQL container.<\/p>\n
\n&lt;pre&gt;&lt;pre&gt;use mysql;
\ncreate database wordpress;
\ngrant all on wordpress.* to ‘wordpress1’@’privateipofapachehost’ identified by ‘password’;
\nflush privileges;[\/js]<\/p>\n
\n7.\u00a0ADD run.sh \/<\/strong> : Adding the run.sh script which will be our entry point script for initiating the configurations for MySQL container.<\/p>\n
\n \/mysql.sh &gt; test.txt [\/js]<\/p>\n
\n9.\u00a0Expose 3306<\/strong> : Exposing the MySQL port of the MySQL container to the host server.
\n10. CMD [“\/run.sh”]<\/strong> : CMD command sets the initial command\/script which will be called when our container is started.<\/p>\n
\n1. Build the image using the above\u00a0Dockerfile.<\/p>\n
\nno<\/strong>= Do not restart container on exit [default].
\non-failure<\/strong>= restart only if container exits with non-zero exit status.
\nalways<\/strong>=always restart container if the container is not running.
\n2. -v<\/strong> : This option mounts the host directory to container.
\n3. -p 3306:3306 <\/strong>: The -p 3306:3306 parameter in the docker run command maps the default MySQL port (3306) of the container with the IP of the host server, so that the Apache web container created in the further steps is able to connect to the database server.<\/p>\ndocker ps<\/code>.<\/p>\nApache Server Docker file<\/strong><\/h3>\n
\nRUN apt-get update
\nRUN apt-get -y install apache2 php5 php5-mysql
\nRUN cd \/var\/www
\nRUN apt-get install wget -y
\nRUN wget http:\/\/wordpress.org\/latest.tar.gz
\nRUN tar -xzvf latest.tar.gz -C \/var\/www\/
\nRUN cp \/var\/www\/wordpress\/wp-config-sample.php \/var\/www\/wordpress\/wp-config.php
\nRUN sed -i ‘s\/database_name_here\/wordpress\/’ \/var\/www\/wordpress\/wp-config.php
\nRUN sed -i ‘s\/username_here\/wordpress1\/’ \/var\/www\/wordpress\/wp-config.php
\nRUN sed -i ‘s\/password_here\/password\/’ \/var\/www\/wordpress\/wp-config.php
\nRUN sed -i &quot;s\/localhost\/ip of the host server of mysql container\/g&quot; wordpress\/wp-config.php &lt;em&gt;\/\/***&lt;\/em&gt;
\nRUN cd \/etc\/apache2\/sites-enabled\/
\nRUN sed -i ‘s\/\\\/var\\\/www\\\/html\/\\\/var\\\/www\\\/wordpress\/’ \/etc\/apache2\/sites-enabled\/000-default.conf
\nCMD [&quot;apache2ctl&quot; ,&quot; -DFOREGROUND&quot;] [\/js]<\/p>\nReferences :-<\/em>
\n <\/em>
\n <\/em><\/h4>\n","protected":false},"excerpt":{"rendered":"