本文使用docker安装常见数据库大部分没配置什么参数，只是基本的安装。
不只是数据库，还有elasticsearch、rabbitmq等和数据相关的服务。
docker pull mysql:5.7
# 映射宿主机3307端口到容器的3306端口
# 设置mysql的root密码为123456
# 映射宿主机的/home/heruo/mysql/data到容器的/var/lib/mysql
docker run -it --name mysql-test -p 3307:3306\
-e MYSQL_ROOT_PASSWORD=123456 \
-v /home/heruo/mysql/data:/var/lib/mysql \
-v /home/heruo/mysql/conf/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf \
-d mysql:5.7
version: "3"
services:
mysql:
image: mysql:5.7
container_name: mysql
volumes:
- /home/apps/mysql/data:/var/lib/mysql
- /home/apps/mysql/conf/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf
- /etc/localtime:/etc/localtime:ro
ports:
- 3306:3306
environment:
- MYSQL_ROOT_PASSWORD=123456
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_allowed_packet = 32M
lower_case_table_names=1
max_connections=2000
# 禁用查询缓存
query_cache_type=0
query_cache_size=0
# innodb缓冲池大小，此处设置为512MB. 512 * 1024 * 1024
innodb_buffer_pool_size=536870912
# binlog配置
#log-bin=mysql-bin
#binlog-format=ROW
#server-id=1
#binlog_ignore_db=information_schema,mysql,performance_schema,sys
#expire_logs_days=30
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
docker pull mariadb
# 映射宿主机4306端口到容器的3306端口
# 设置mariadb的root密码为123456
# 映射宿主机的/home/apps/mariadb/data到容器的/var/lib/mysql
docker run -it --name mariadb -p 4306:3306\
-e MARIADB_ROOT_PASSWORD=123456 \
-v /home/apps/mariadb/data:/var/lib/mysql \
-d mariadb:latest
version: "3"
services:
mariadb:
image: mariadb:latest
container_name: mariadb
volumes:
- /home/apps/mariadb/data:/var/lib/mysql
ports:
- 4306:3306
environment:
- MARIADB_ROOT_PASSWORD=123456
docker pull redis:6.2.4
docker run -p 6379:6379 --name redis-test -d redis:6.2.4
version: "3"
services:
redis:
image: redis:6.2.4
container_name: redis-6379
ports:
- 6379:6379
volumes:
- /home/apps/redis/conf/redis.conf:/usr/local/etc/redis/redis.conf
- /home/apps/redis/data:/data
# 挂载redis.conf的话，需要指定启动命令中的配置文件路径
command: redis-server /usr/local/etc/redis/redis.conf
port 6379
requirepass 123456
protected-mode no
daemonize no
appendonly yes
aof-use-rdb-preamble yes
docker pull mongo
docker run -p 27017:27017 --name mongodb \
-v /home/apps/mongodb/data:/data/db \
-e MONGO_INITDB_ROOT_USERNAME=root \
-e MONGO_INITDB_ROOT_PASSWORD=123456 \
-d mongo:latest
version: "3"
services:
mongodb:
image: mongo:latest
container_name: mongodb-test
ports:
- 27017:27017
volumes:
- /home/apps/mongodb/data:/data/db
environment:
- MONGO_INITDB_ROOT_USERNAME=root
- MONGO_INITDB_ROOT_PASSWORD=123456
docker pull elasticsearch:7.5.1
docker run -p 9200:9200 -p 9300:9300 --name es-test \
-e "discovery.type=single-node" \
-d elasticsearch:7.5.1
version: "3"
services:
elasticsearch:
image: elasticsearch:7.5.1
container_name: es-test
ports:
- 9200:9200
- 9300:9300
volumes:
- /home/apps/elasticsearch/data/:/usr/share/elasticsearch/data
- /home/apps/elasticsearch/logs/:/usr/share/elasticsearch/logs
- /home/apps/elasticsearch/plugins/:/usr/share/elasticsearch/plugins
environment:
- "discovery.type=single-node"
- "ES_JAVA_OPTS=-Xms512m -Xmx512m"
ulimits:
nofile:
soft: 262144
hard: 262144
docker pull postgres
docker run -p 5432:5432 --name postgresql \
-e POSTGRES_PASSWORD=123456 \
-v /home/apps/postgresql/data:/var/lib/postgresql/data \
-d postgres
version: "3"
services:
postgresql:
image: postgres:latest
container_name: postgresql
ports:
- 5432:5432
volumes:
- /home/apps/postgresql/data:/var/lib/postgresql/data
environment:
- "POSTGRES_PASSWORD=123456"
待施工
docker pull 'ibmcom/db2'
# 默认实例拥有者是db2inst1
# 设置db2inst1的密码为db2inst1
docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=db2inst1 -e DBNAME=testdb -v /home/apps/db2/data:/database ibmcom/db2
version: "3"
services:
db2:
image: ibmcom/db2
container_name: db2
privileged: true
ports:
- 50000:50000
volumes:
- /home/apps/db2/data:/database
environment:
- "LICENSE=accept"
- "DB2INST1_PASSWORD=db2inst1"
- "DBNAME=testdb"
待施工
待施工
docker pull clickhouse/clickhouse-server
# 基础创建方式
docker run -d --name some-clickhouse-server --ulimit nofile=262144:262144 clickhouse/clickhouse-server
# 映射端口
docker run -d -p 18123:8123 -p19000:9000 --name clickhouse-server1 --ulimit nofile=262144:262144 clickhouse/clickhouse-server
/var/lib/clickhouse//var/log/clickhouse-server/docker-compose.yaml示例：
version: "3"
services:
clickhouse:
image: clickhouse/clickhouse-server:latest
container_name: chserver
volumes:
- /home/apps/clickhouse/data:/var/lib/clickhouse
- /home/apps/clickhouse/logs:/var/log/clickhouse-server
ports:
- 8123:8123
- 9000:9000
ulimits:
nofile:
soft: 262144
hard: 262144
# 带web端管理系统
docker pull rabbitmq:management
# 15672是web管理端访问端口
docker run --name rabbitmq -p 5672:5672 -p 15672:15672 \
-e RABBITMQ_DEFAULT_USER=rbmq \
-e RABBITMQ_DEFAULT_PASS=rbmq \
--hostname=rabbitmqhosta \
-v /home/rabbitmq/data:/var/lib/rabbitmq \
-d rabbitmq:management
version: "3"
services:
rabbitmq:
image: rabbitmq:management
container_name: rabbitmq
hostname: rabbitmqhosta
ports:
- 5672:5672
- 15672:15672
volumes:
- /home/apps/rabbitmq/data:/var/lib/rabbitmq
environment:
- "RABBITMQ_DEFAULT_USER=rbmq"
- "RABBITMQ_DEFAULT_PASS=rbmq"
docker pull memcached
# 映射11211端口，指定最大容量为128m。不设置的话，最大容量为64m
docker run --name memcache -p 11211:11211 -d memcached -m 128
telnet 192.168.0.10 11211
# 访问成功后，执行 stats
待施工
docker pull influxdb:2.3.0
# 创建挂载目录
mkdir -p /home/apps/influxdb/{conf,data}
# 考虑到后续可能会修改配置，所以先把配置文件导出来了
docker run --rm influxdb:2.3.0 influxd print-config > /home/apps/influxdb/conf/config.yml
docker run --name influxdb -p 8086:8086 \
-v /home/apps/influxdb/data:/var/lib/influxdb2 \
-v /home/apps/influxdb/conf/config.yml:/etc/influxdb2/config.yml \
-d influxdb:2.3.0
version: "3"
services:
influxdb2:
image: influxdb:2.3.0
container_name: influxdb2
ports:
- 8086:8086
volumes:
- /home/apps/influxdb/data:/var/lib/influxdb2
- /home/apps/influxdb/conf/config.yml:/etc/influxdb2/config.yml