This file is used to demonstrate MySQL database in Docker Container

SimplilearnDevOpsOfficial · SimplilearnDevOpsOfficial · commit 8a318eef6775 · 2019-01-16T06:04:24.000Z
diff --git a/README.md b/README.md
@@ -0,0 +1,92 @@
+# Exercise 8.3 - Relational Database
+
+Create a relational database container and create and access the case study database.
+
+### Step 1
+
+Open the Cloud Platform Console at https://console.cloud.google.com. Go to Compute Engine and VM Instances.
+Start the VM if it isn’t running and connect using SSH.
+
+### Step 2
+
+Change to the lab directory.  
+`cd`  
+`cd devops-lesson-8/lab-8.3`  
+
+### Step 3
+
+Initialize directory structure
+
+Create a Docker data volume to hold the database.
+
+`docker volume create --name monitoring_data`  
+
+Confirm that the data volume was created.
+
+`docker volume ls`  
+
+Examine the script that will run and create the scase study database structure.
+
+`cat runserver_first`  
+
+Run the script to create a container with MySQL running and create the database.
+
+`./runserver_first`  
+
+You will need to monitor the logs to see when MySQL has completed creating
+the student database and is waiting for connections. This may take several minutes
+to complete.  
+`docker logs mysql`  
+
+When you see the following in the logs you may continue. Run the command until you see.
+
+`mysqld: ready for connections.`  
+
+Find the IP address of the server.  
+`docker inspect mysql`
+
+### Step 4
+
+Load data into the student database
+
+Examine the script that will run the MySQL client. Notice that we are using the same image.  
+`cat runclient`  
+
+Run the MySQL client container.  
+`./runclient`  
+
+You will be placed inside the client container running the Bash command shell.
+You can now type commands to use the database. You may need to change the IP address to that of the server.  
+`mysql -h 172.17.0.2 -u student -p monitoring`  
+
+You will be prompted for the password. Enter 'student' as the password  
+`Enter password:`  
+
+When you connect you will see the MySQL client prompt  
+`mysql>`  
+
+At the prompt read in the definition for the employee information.  
+`mysql> source /data/docker.sql;`  
+
+### Step 5
+
+Examine the database tables in the database by selecting the first 10 rows from each
+
+`mysql> show tables;`  
+
+Get the content of the docker table.  
+
+`mysql> select * from docker;`  
+
+Insert another row of data and query the table again.
+
+### Step 5
+ 
+Clean up after the lab
+
+ Exit from the MySQL client  
+`mysql> quit;`  
+
+ Exit from the client container  
+ `exit`  
+
diff --git a/runclient b/runclient
@@ -0,0 +1,4 @@
+#! /bin/bash
+
+docker run --rm -it  -v $(pwd)/sql:/data mysql:5.7 /bin/bash
+
diff --git a/runserver_first b/runserver_first
@@ -0,0 +1,31 @@
+#! /bin/bash
+#
+# File: runserver
+#
+# Purpose: Runs the MySQL server in a Docker container
+#
+# NB: Uses a Docker volume named mysql_data to contain database data
+#
+
+export MYSQL_IMAGE=mysql
+export MYSQL_VERSION=5.7
+export ROOT_PASSWORD=rootpw
+export STUDENT_USER=student
+export STUDENT_PASSWORD=student
+export STUDENT_DATABASE=monitoring
+export MYSQL_SERVER_CONTAINER_NAME=mysql
+export MYSQL_SERVER_EXTERNAL_PORT=3306
+export MYSQL_SERVER_INTERNAL_PORT=3306
+
+docker rm -f mysql
+
+docker run -d \
+  --name mysql \
+  -p $MYSQL_SERVER_EXTERNAL_PORT:$MYSQL_SERVER_INTERNAL_PORT \
+  -e MYSQL_DATABASE=$STUDENT_DATABASE \
+  -e MYSQL_USER=$STUDENT_USER \
+  -e MYSQL_PASSWORD=$STUDENT_PASSWORD \
+  -e MYSQL_ROOT_PASSWORD=$ROOT_PASSWORD \
+  -v monitoring_data:/var/lib/mysql \
+  ${MYSQL_IMAGE}:${MYSQL_VERSION}
+docker ps
diff --git a/runserver_first.save b/runserver_first.save
@@ -0,0 +1,32 @@
+i#! /bin/bash
+#
+# File: runserver
+#
+# Purpose: Runs the MySQL server in a Docker container
+#
+# NB: Uses a Docker volume named mysql_data to contain database data
+#
+
+export MYSQL_IMAGE=mysql
+export MYSQL_VERSION=5.7
+export ROOT_PASSWORD=rootpw
+export STUDENT_USER=student
+export STUDENT_PASSWORD=student
+export STUDENT_DATABASE=monitoring
+export MYSQL_SERVER_CONTAINER_NAME=mysql
+export MYSQL_SERVER_EXTERNAL_PORT=8080
+export MYSQL_SERVER_INTERNAL_PORT=8080
+
+docker rm -f mysql
+
+docker run -d \
+  --name mysql \
+  -p $MYSQL_SERVER_EXTERNAL_PORT:$MYSQL_SERVER_INTERNAL_PORT \
+  -e MYSQL_DATABASE=$STUDENT_DATABASE \
+  -e MYSQL_USER=$STUDENT_USER \
+wq
+  -e MYSQL_PASSWORD=$STUDENT_PASSWORD \
+  -e MYSQL_ROOT_PASSWORD=$ROOT_PASSWORD \
+  -v monitoring_data:/var/lib/mysql \
+  ${MYSQL_IMAGE}:${MYSQL_VERSION}
+docker ps
diff --git a/sql/docker.sql b/sql/docker.sql
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS docker;
+
+CREATE TABLE docker (
+   id         INT          NOT NULL AUTO_INCREMENT,
+   event_time DATETIME     NOT NULL,
+   severity   VARCHAR(40)  NOT NULL,
+   message    VARCHAR(200) NOT NULL,
+
+   PRIMARY KEY (id)
+) ;
+
+INSERT INTO docker (id,event_time,severity,message)
+VALUES (1,NOW(),'INFO','Initial configuration');
+

-Original file line number
+Diff line change
@@ @@ -0,0 +1,4 @@ @@
 +#! /bin/bash
++
 +docker run --rm -it  -v $(pwd)/sql:/data mysql:5.7 /bin/bash
++