Skip to main content

Using Docker Container for MySQL Service

Problem

Suppose you are working on a project that relies on Mysql service but you do not want to install MySQL to your system. Using a Docker image can be a good solution. Remember that you can use many services through Docker containers.

Steps

1- Install docker 

Docker Community Edition can be freely downloaded from the official page. It requires registration.
https://www.docker.com/community-edition

Install docker image. It may require a restart, if it does, do so.

In case any problems occur that prevent Docker for Windows from starting check trouble shooting page.

https://docs.docker.com/docker-for-windows/troubleshoot/

In Windows 10, hypervisor launch type needs to be "auto".  In order to check current status bcdedit command can be used via PowerShell (Administrator Mode). In order to set to "auto" following command can be used.


bcdedit /set hypervisorlaunchtype auto


2- Find the Relevant Container

Go to Docker Store. Type Mysql. Select an appropriate container. In the container page, on the left, there is a command to pull the docker image to your system. Also, right below the command, there is a link to list available tags. Tags are the possible versions that can be installed. For the latest available image, "latest" tag can be used.

3- Pull the Image

Open a command prompt and use suggested command to pull the image.

docker pull mysql

4- Run the Container

Type run command to start the container.

docker run -p 3306:3306 --name dmysql -e MYSQL_ROOT_PASSWORD=MY-PASSWORD -d mysql:tag
  • "tag" is the version information. Check tags available in the container page.
  • "MY-PASSWORD" is to be replaced by the desired root password.
  • "-p" flag determines the port to expose to host environment. 
Now run ps command, you should see the MySQL process running.

docker ps

5- Configure the Application 

Configure your application which will connect to the MySQL service. Username is root and password is the one given replaced MY-PASSWORD.

For the JDBC url use the following:

jdbc:mysql://localhost:3306/testdb

testdb is the name of the db to connect to.

6- Clean the Container

After you are done with the container stop and remove it.

docker stop dmysql
docker rm dmysql


Conclusion

Docker containers are very useful for many use cases. Providing a local service is just an example.

We used the service and removed it afterward without any modifications to the host system.
Labels:

Comments

Post a Comment

Popular posts from this blog

Obfuscating Spring Boot Projects Using Maven Proguard Plugin

Introduction Obfuscation is the act of reorganizing bytecode such that it becomes hard to decompile. Many developers rely on obfuscation to save their sensitive code from undesired eyes. Publishing jars without obfuscation may hinder competitiveness because rivals may take advantage of easily decompilable nature of java binaries. Objective Spring Boot applications make use of public interfaces, annotations which makes applications harder to obfuscate. Additionally, maven Spring Boot plugin creates a fat jar which contains all dependent jars. It is not viable to obfuscate the whole fat jar. Thus obfuscating Spring Boot applications is different than obfuscating regular java applications and requires a suitable strategy. Audience Those who use Spring Boot and Maven and wish to obfuscate their application using Proguard are the target audience for this article. Sample Application As the sample application, I will use elastic search synch application from my GitHub repository.
4 comments
Read more

Hadoop Installation Document - Standalone Mode

This document shows my experience on following apache document titled “Hadoop:Setting up a Single Node Cluster”[1] which is for Hadoop version 3.0.0-Alpha2 [2]. A. Prepare the guest environment Install VirtualBox. Create a virtual 64 bit Linux machine. Name it “ubuntul_hadoop_master”. Give it 500MB memory. Create a VMDK disc which is dynamically allocated up to 30GB. In network settings in first tab you should see Adapter 1 enabled and attached to “NAT”. In second table enable adapter 2 and attach to “Host Only Adaptor”. First adapter is required for internet connection. Second one is required for letting outside connect to a guest service. In storage settings, attach a Linux iso file to IDE channel. Use any distribution you like. Because of small installation size, I choose minimal Ubuntu iso [1]. In package selection menu, I only left standard packages selected.  Login to system.  Setup JDK. $ sudo apt-get install openjdk-8-jdk Install ssh and pdsh, if not already i
3 comments
Read more

Java: Cost of Volatile Variables

Introduction Use of volatile variables is common among Java developers as a way of implicit synchronization. JIT compilers may reorder program execution to increase performance. Java memory model[1] constraints reordering of volatile variables. Thus volatile variable access should has a cost which is different than a non-volatile variable access. This article will not discuss technical details on use of volatile variables. Performance impact of volatile variables is explored by using a test application. Objective Exploring volatile variable costs and comparing with alternative approaches. Audience This article is written for developers who seek to have a view about cost of volatile variables. Test Configuration Test application runs read and write actions on java variables. A non volatile primitive integer, a volatile primitive integer and an AtomicInteger is tested. Non-volatile primitive integer access is controlled with ReentrantLock and ReentrantReadWriteLock  to compa
Post a Comment
Read more