Database Typed

MySQL

8

docker run \
--name mysql-8 \
-e MYSQL_ROOT_PASSWORD=root \
-e TZ=Asia/Shanghai \
-p 3306:3306 \
-v /usr/local/applications/mysql/data:/var/lib/mysql \
-v /usr/local/applications/mysql/config:/etc/mysql/conf.d \
-v /usr/local/applications/mysql/logs:/logs \
-d mysql:8

5.7

docker run \
--name mysql57 \
-e MYSQL_ROOT_PASSWORD=root \
-e TZ=Asia/Shanghai \
-p 3306:3306 \
-v /usr/local/applications/mysql/data:/var/lib/mysql \
-v /usr/local/applications/mysql/config:/etc/mysql/conf.d \
-v /usr/local/applications/mysql/logs:/logs \
-d mysql:5.7

Mariadb

docker run --detach \
-p 3306:3306 \
--name mariadb \
--env MARIADB_USER=maria \
--env MARIADB_PASSWORD=root \
--env MARIADB_ROOT_PASSWORD=root mariadb:10.7

MongoDB

docker run -d --name mongo -p 27017:27017 \
-v /app/mongo/data/db:/data/db \
-v /app/mongo/data/configdb:/data/configdb \
-e MONGO_INITDB_ROOT_USERNAME=admin -e MONGO_INITDB_ROOT_PASSWORD=123456 \
mongo --auth

Clickhouse

compose-latest

vim /opt/clickhouse/docker-compose.yml

version: '3.8'

services:
clickhouse-server:
image: clickhouse/clickhouse-server
container_name: clickhouse-server
ports:
- "8123:8123"
- "19000:9000"
volumes:
- ./ch_data:/var/lib/clickhouse
- ./ch_logs:/var/log/clickhouse-server
environment:
CLICKHOUSE_DB: my_database
CLICKHOUSE_USER: root
CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
CLICKHOUSE_PASSWORD: root
ulimits:
nofile:
soft: 262144
hard: 262144
restart: unless-stopped

verify:

echo 'SELECT version()' | curl 'http://localhost:8123/' --data-binary @-

run-latest

docker run -d -p 18123:8123 -p 19000:9000 --name clickhouse-server \
    -v $(realpath ./ch_data):/var/lib/clickhouse/ \
    -v $(realpath ./ch_logs):/var/log/clickhouse-server/ \
    -v /path/to/your/config.xml:/etc/clickhouse-server/config.xml \
    -e CLICKHOUSE_DB=my_database \
    -e CLICKHOUSE_USER=clickhouse \
    -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 \
    -e CLICKHOUSE_PASSWORD=clickhouse \
    registry.dockermirror.com/clickhouse/clickhouse-server

PostgresSQL

PostgresSQL Exporter

docker run -d \
  -p 9187:9187 \
  -e DATA_SOURCE_NAME="postgresql://enterprisedb:yyy&[email protected]:5432/adb?sslmode=disable" \
  quay.io/prometheuscommunity/postgres-exporter