dble_quick_start_docker.md

Quick Start(docker)

1. Prepare

• install docker (in server)
• install MySQL client tool (server or local)

2. Install

Run command as below:

docker network create -o "com.docker.network.bridge.name"="dble-net" --subnet 172.18.0.0/16 dble-net
docker run --name backend-mysql1 --network bridge --ip 172.18.0.2  -e MYSQL_ROOT_PASSWORD=123456 -p 33061:3306 --network=dble-net -d mysql:5.7 --server-id=1
docker run --name backend-mysql2  --network bridge --ip 172.18.0.3 -e MYSQL_ROOT_PASSWORD=123456 -p 33062:3306 --network=dble-net -d mysql:5.7 --server-id=2
sleep 30 # may need more time
docker run -d -i -t --name dble-server --ip 172.18.0.5 -p 8066:8066 -p 9066:9066 --network=dble-net  actiontech/dble:latest

Now we build a docker network. It contains two MySQL containers which map port 3306 to port 33061 and 33062 on the Docker host.
We map TCP port 8066 and 9066 in the dble container to the same port on the Docker host.

sleep is waiting for dble and MySQL to initialize.

3. Connect and use

We have set two users for quick start in docker.
8066 port: root/123456
9066 port: man1/654321
You can view other configs and table structure.

Try connect MySQL/dble by using MySQL client tool. If you want to connet from local,just change the IP.

#connect dble server port
mysql -P8066 -u root -p123456 -h 127.0.0.1 
#connect dble manager port
mysql -P9066 -u man1 -p654321 -h 127.0.0.1
#connect mysql1
mysql -P33061 -u root -p123456 -h 127.0.0.1 
#connect mysql2
mysql -P33062 -u root -p123456 -h 127.0.0.1

Enjoy testing.

4. Clean

clean resources:

docker stop backend-mysql1
docker stop backend-mysql2
docker stop dble-server
docker rm backend-mysql1
docker rm backend-mysql2
docker rm dble-server
docker network rm dble-net