11. Docker – Implementation => CONTAINER LINK WITH MYSQL.

-

Docker – Implementation => CONTAINER LINK WITH MYSQL.



DOCKER PAGE :

https://hub.docker.com/_/mysql

 

00. docker pull mysql:5.7

01. docker images

02. docker run -p 3307:3306 --name=mysql_server -e MYSQL_ROOT_PASSWORD=root -e MYSQL_USER=root -e MYSQL_PASSWORD=root -d mysql:5.7 // this is woking.......................................

    docker run -p 3300:3306 --name mysql_server -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7  // this is woking.......................................

 

                                                OR

 

01. docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

    docker run -p 3307:3306 --name=mysql_server -e MYSQL_ROOT_PASSWORD=root -e MYSQL_USER=root -e MYSQL_PASSWORD=root -d mysql:5.7 // this is woking.......................................

    docker run -p 3300:3306 --name mysql_server -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7  // this is woking.......................................

02. docker images // VIEW ALLIMAGES AND SEE WHETHER mysql IS IN THERE

03. docker ps -a // VIEW ALL CONAINER PROCESS- RUNNING OR NOT. SEE mysql CONTAINER UP OR NOT.IF IT IS NOT, THERE IS SOME ERROR TO FIXED.

04. docker exec -it id_of_container bin/bash -------- sql //EXAMPLE : docker exec -it 55b8232bfc82 bin/bash

05. mysql -u root -p root  // mysql -u root -p PRESS ENTER AND GIVE PASSWORD[IN MY EXAMPLE(according to 01) IT IS root]

06. docker logs  mysql // TO SEE MYSQL LOGS

06. docker exec -i mysql-docker mysql -uroot -proot demo < demo_data.sql //TO QUERY DATA TO DB FROM EXTERNAL SQL FILE.

PROJECT LINK WITH MY SQL

docker run -t --link mysql-demo:mysql -p 8088:8080 spring-demo-docker

docker run -t --link mysql_server:mysql -p 9093:8083 --name springboot_prj3_mysql_cont -d springboot_prj3_mysql_img // this is working.......................................

 

docker start cdb413245aa1ec1c7e9747650c88b8fa2c18b00023e257650ea87cefc126b9e9

 

GO INSIDE THE DOCKER CONTAINER

docker exec -it idofcontainer bin/bash -------- sql

mysql -u root -p demo

Then query can be executed.

 

 ----EXTRA NOTE

//working but containers are not running error - Error response from daemon: Container is not running

docker run -p 3300:3301 --name=mysql -env="MYSQL_ROOT_PASSWORD=root" -env="MYSQL_PASSWORD=root" -d mysql:5.7

docker run -d -p 3300:3301 --name=mysql -env="MYSQL_ROOT_PASSWORD=root" -env="MYSQL_PASSWORD=root" -env="MYSQL_DATABASE=test" mysql:5.7

 

//

docker ps -a = view all container process - running and not

 

 

docker-compose -f docker-compose.yml up

docker-compose -f docker-compose.yml down

Comments

Post a Comment

Popular posts from this blog

02. Spring – Creating spring project clone it with GIT step by step.

-
Image
  Creating spring project clone it with GIT step by step. 01. Create an empty GIT repository and select a repository name. 02.   Check to add README.md and technology to add it inside the gitignire file0- it will include all the generated class when we complete the application. 03.      Copy the github repository URL. 04 . Open eclipse and go to,             Window – Show View – Other - Type git on the folder and select git repositories. 05.   Now clone this repository at your desired location in which we are going to keep the project specific file . a)         a)  Step One.             b)  Step  Two .          c)    Step Three. Both projects are generated as bellows           d) Step Four  Open the gitingnore file and ignore the target folder of the project. All the class files which are generate with compile the code are store in target folder. Class file can be generated. Because of that we don’t commit that folder to git.           e) Step Five Open window – preference – filter fo
Read more

02.What is MicroService?

-
Image
What is MicroService? MicroService යනු තනි application එකක් (Monolithic Application එකක්), එකිනෙක communicate කරගන පුළුවන් වෙන වෙනම deploy වන කුඩා කුඩා independent services වලට කැඩීමයි. Simply it is new way to develop application rather than traditional monolithic application. Companies which are using microservice.   Features of MicroService Architecture Small focused – main aim of microservice is simplicity.it can be rewrite in maintained without extra effort. Loosely coupled – development as well as deployment is quick. Language Neutral – few services can be Java, few is c# few can be python.it can be use depend on the service. Bounded Context – each microservice does not need to understand the implementation of the other microservice.
Read more

06.Mongo DB - Query part 2 (Aggregation)

-
Image
    Project can be download from         https://github.com/LahiruPriyankara/SpringBootAppTwo-MongoDB MongoDB Aggregation This groups values from multiple documents together and can perform variety of operations on that grouped data.it is going to return single result after the aggregation. Stages In Aggregation: Those operation are used in group of documents ( Used inside aggregation stages).  Unary Operation -  Unary operator perform operation for each documents. Type - Given the type of the filed. In the SQL we query select count and in the bracket Astrix this count for aggregation. It return the number of rows. This is same in mongoDB. db . employee . aggregate ([ { $group : { _id : "$gender" , genderCount : { $sum : 1 } } } ]) // $sum: 1 :1 - true db . employee . aggregate ([ { $group : { _id : "$gender" , maxAge : { $max : "$age" } } } ]) Bellow example is from  https://docs.mongodb.com/manual/aggregation/ Single Purpose Aggregation
Read more