My Docker Compose Collection

Alvinditya Saputra included in Documentation

2021-08-15 945 words 5 minutes

Contents

Basic command

1
2
docker-compose -f $FILENAME up -d
docker-compose -f $FILENAME down -v

Kafka CLI

Download docker compose configuration using curl

1
curl -o kafka-cli.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/kafka-cli.yaml

This yaml kafka-cli.yaml will create a new container zookeeper and exposed port 2181 on host port. Also create a new container kafka and exposed port 29092, 9092 and 9101 on host port.

Redis

By default there are 16 databases (indexed from 0 to 15) and you can navigate between them using select command. Number of databases can be changed in redis config file with databases setting.

Download docker compose configuration using curl

1
curl -o redis.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/redis.yaml

This yaml redis.yaml will create a new container redis and exposed port 6379 on host port.

Redis CLI

Run redis-cli

1
docker exec -it redis redis-cli

Select the Redis logical database having the specified zero-based numeric index. New connections always use the database 0.

Change database.

1
select [INDEX]

Set and get key

1
2
set [KEY_NAME] [VALUE]
get [KEY_NAME]

Another Redis Desktop Manager

Install Another Redis Desktop Manager with homebrew. You can run with following command on your terminal.

1
2
brew install cask 
brew install --cask another-redis-desktop-manager

Open the application, and should looks like below.

Another Redis Desktop Manager dashboard

Another Redis Desktop Manager add new key.

MySQL

Download docker compose configuration using curl

1
curl -o mysql.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/mysql.yaml

This yaml mysql.yaml will create a new container mysql and exposed port 3306 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume mysql-data to persist data then run docker-compose

1
docker volume create mysql-data

MySQL CLI

Run this command to run MySQL command on container. Default user is root and password SevenEightTwo782 you can change the password in yaml file.

1
docker exec -it mysql bash

Basic command:

Login into database, then type your password
1
mysql -u root -p
Get list of databases
1
show databases;

Create database and use database

1
2
create database $DB_NAME;
use $DB_NAME;

PostgreSQL

Download docker compose configuration using curl

1
curl -o postgresql.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/postgresql.yaml

This yaml postgresql.yaml will create a new container postgresql and exposed port 5432 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume postgre-data to persist data then run docker-compose

1
docker volume create postgre-data

Postgre SQL CLI

Run this command to run PostgreSQL command on container. Default user is postgres and password SevenEightTwo782 you can change the password in yaml file.

1
docker exec -it postgresql bash

Basic command:

Login into database
1
psql -Upostgres -w
Get list of databases
1
\l

Create database and use database

1
2
create database $DB_NAME;
\c $DB_NAME

SQL Server

Download docker compose configuration using curl

1
curl -o sqlserver.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/sqlserver.yaml

This yaml sqlserver.yaml will create a new container sqlserver and exposed port 1433 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume sqlserver-data and sqlserver-user to persist data then run docker-compose

1
docker volume create sqlserver-data && docker volume create sqlserver-user

SQL Server CLI

Run this command to run SQL Server command on container. Default user is sa and password SevenEightTwo782 you can change the password in yaml file.

1
docker exec -it sqlserver /opt/mssql-tools/bin/sqlcmd -U sa -P SevenEightTwo782

Basic command:

Get list of databases
1 2
select name from sys.databases go
Create database and use database
1 2
create database $DB_NAME go

RabbitMQ

Download docker compose configuration using curl

1
curl -o rabbitmq.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/rabbitmq.yaml

This yaml rabbitmq.yaml will create a new container rabbitmq and exposed port 5672 and 15672 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume rabbitmq-data and rabbitmq-log to persist data then run docker-compose

1
docker volume create rabbitmq-data && docker volume create rabbitmq-log

RabbitMq Management

Default RabbitMQ management user is guest and password is guest. Go to localhost:15672 to acess RabbitMQ management.

Sonarqube

Download docker compose configuration using curl

1
curl -o sonarqube.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/sonarqube.yaml

This yaml sonarqube.yaml will create a new container sonarqube and exposed port 9000 and 9002 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume to persist data then run docker-compose

1
docker volume create sonarqube-data && docker volume create sonarqube-extensions && docker volume create sonarqube-logs && docker volume create sonarqube-temp

Sonarqube Management

Default Sonarqube management user is admin and password is admin. Go to localhost:9000 to acess Sonarqube management and then change the default password first.

MongoDB

Download docker compose configuration using curl

1
curl -o mongodb.yaml https://raw.githubusercontent.com/piinalpin/docker-compose-collection/master/mongodb.yaml

This yaml mongodb.yaml will create a new container mongodb and exposed port 27017 on host port.

Create network my-network if does not exists

1
docker network create my-network

Create volume to persist data then run docker-compose

1
docker volume create mongodb-data && docker volume create mongodb-config

MongoDB CLI Run this command to run MongoDB command on container. Default user is root and password SevenEightTwo782 you can change the password in yaml file.

1
docker exec -it mongodb mongo -u root -p SevenEightTwo782 --authenticationDatabase admin <SOME_DATABASE>

Basic command:

Get list of databases
1
show dbs
Create database and use database
1 2
use some_db db

Create collection

1
db.createCollection('some_collection');

Insert row

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
db.some_db.insertMany([
    {
        _id: 1,
        first_name: "Maverick",
        last_name: "Johnson",
        gender: 1
    },
    {
        _id: 2,
        first_name: "Calvin",
        last_name: "Joe",
        gender: 1
    },
    {
        _id: 3,
        first_name: "Kagura",
        last_name: "Otsusuki",
        gender: 0
    }
]);

Find row
1
db.some_db.find();

Update row

1
2
3
4
5
db.test.updateOne({_id: 1}, {$set: {
    first_name: "Maverick",
    last_name: "Johnson Updated",
    gender: 1
}});