Scribd
Upload
57 views7 pages

Assignment Answer Data Volumes

This document discusses using named volumes in Docker to persist MySQL database data. It shows how to [1] start a MySQL container with a named volume, [2] insert test data into the database, and [3] restart the container pointing to the same volume to verify the original data is still present. Named volumes allow database data to survive the removal and recreation of containers for stateful applications like MySQL.

Uploaded by

Shuaib Mohammed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
57 views7 pages

Assignment Answer Data Volumes

This document discusses using named volumes in Docker to persist MySQL database data. It shows how to [1] start a MySQL container with a named volume, [2] insert test data into the database, and [3] restart the container pointing to the same volume to verify the original data is still present. Named volumes allow database data to survive the removal and recreation of containers for stateful applications like MySQL.

Uploaded by

Shuaib Mohammed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

DOCKER

Assignment Answer : Named Volumes


Docker : Data Management

➤ Create mysql container with some specific version with


Volume named mysql-db
➤ Start Mysql Container

docker container run - -name=mysqltest mysql
➤ Start Mysql with admin password

docker run --name=test-mysql --
env="MYSQL_ROOT_PASSWORD=mypassword" mysql
➤ Remove existing Container and Start Again
➤ Verify MqSQL Container
Docker : Data Management

➤ Stop/remove mySQL Container and Start with user Defined


Volumes

docker run --name=test-mysql --
env="MYSQL_ROOT_PASSWORD=mypassword" - -mount
source=mysql-db, target=/var/lib/mysql mysql
➤ Verify mysql Containers
➤ Go to MySQL DataBase and Create Data
Docker : Data Management

➤ Go to MySQL DataBase and Create Data


➤ Inspect container to find the IP
➤ Get the Running Port
➤ Install MySQL client package.

apt-get install mysql-client
➤ Execute Command to login MySQL DB
➤ mysql -u root -p <password> -h <hostIP> -P <port>

mysql -u root -p mypassword -h 172.17.0.20 -P 3306
Docker : Data Management

➤ Create DataBase

CREATE DATABASE databasename;
➤ Create Table in DataBase

CREATE TABLE Persons ( PersonID int, LastName varchar(255),
FirstName varchar(255), Address varchar(255), City varchar(255) );
➤ Insert Some Data into the Table

INSERT INTO Persons (PersonID, LastName, FirstName, Address,
City)VALUES (14, 'B. Erichsen', ’Tom’, ‘Skagen 216’, 'Norway');

INSERT INTO Persons (PersonID, LastName, FirstName, Address,
City)VALUES (17, 'Zbyszek', ’Wolski’, ‘Keskuskatu 45’, ‘Finland');
➤ Verify DataBase

Select * From Persons;
Docker : Data Management

➤ Stop and Remove the Running Container.


➤ Start a New MySQL Container with earlier Data Volumes.

docker run —name=test-mysql-secound --
env="MYSQL_ROOT_PASSWORD=mypassword" - -mount
source=mysql-db, target=/var/lib/mysql mysql
➤ Go to the DataBase
➤ Verify the Data, user have created in earlier Container.
Will see you in Next Lecture…

See you in next lecture …

You might also like