Linux部署Docker_docker shm postgres-CSDN博客

本文链接：https://blog.csdn.net/jhz13075/article/details/123896995

一、安装docker

1.1 centos安装docker

echo `systemctl stop docker` && \
echo `yum erase -y docker docker-client  docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-selinux docker-engine-selinux  docker-engine docker-ce` && \
yum install -y yum-utils device-mapper-persistent-data lvm2 && \
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo && \
yum install docker-ce -y && \
mkdir -p /etc/docker && \
echo '{
  "registry-mirrors": [
"https://x9o4p9lt.mirror.aliyuncs.com",
"https://dockerhub.azk8s.cn",
"https://hub-mirror.c.163.com"
  ]
}'>/etc/docker/daemon.json && \
systemctl daemon-reload && systemctl enable docker && systemctl restart docker && docker version && \
echo `cat /etc/docker/daemon.json`

1.2 ubuntu、debian安装docker

apt-get install -y software-properties-common, curl
curl -fsSL https://download.docker.com/linux/debian/gpg | apt-key add -
echo "deb [arch=arm64] https://download.docker.com/linux/debian $(lsb_release -cs) stable" | tee -a /etc/apt/sources.list.d/docker.list
apt-get update
apt-cache policy docker-ce
apt-get -y install docker-ce
docker info
systemctl status docker
echo '{
    "registry-mirrors":[
        "https://x9o4p9lt.mirror.aliyuncs.com",
        "https://dockerhub.azk8s.cn",
        "https://hub-mirror.c.163.com"
    ]
}'>/etc/docker/daemon.json && \
systemctl daemon-reload && systemctl enable docker && systemctl restart docker && docker version && \
systemctl enable docker

1.3 下载docker镜像

# 常用
docker pull mysql:5.7 && \
docker pull xuxueli/xxl-job-admin:2.3.0 && \
docker pull sonatype/nexus3 && \
docker pull rabbitmq:3-management && \
docker pull kubebiz/kafka:2.13-3.0.0 && \
docker pull redis && \
docker pull gitea/gitea && \
docker pull yandex/clickhouse-server && \
docker pull yandex/clickhouse-client && \
docker pull mongo && \
docker pull elasticsearch


# 不常用
docker pull postgres:12.8
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g && \
docker pull centos:7
docker pull centos:8
docker pull pch18/baota:clear

1.4 docker 命令

# 进入容器
docker exec -it container_name /bin/bash
# 强制删除运行中的容器
docker rm -f container_name
# 删除镜像
docker image rm image_tag 
# 查看所有容器
docker ps -a
# 查看所有容器ID
docker ps -a -q
# containerId 是容器的ID
docker stop containerId
# start启动所有停止的容器
docker start $(docker ps -a -q)
# stop停止所有容器
docker stop $(docker ps -a -q)
# remove删除所有容器
docker rm $(docker ps -a -q)
# 容器内查看容器环境变量命令
printenv

二、docker容器部署

echo "`docker rm -f prtainer`" && \
docker run -itd --restart always -v /etc/timezone:/etc/timezone -v /etc/localtime:/etc/localtime:ro --name prtainer \
-p 9000:9000 \
-v /var/run/docker.sock:/var/run/docker.sock \
portainer/portainer && \
sleep 1 && echo -e "\n`docker logs prtainer`\n"


echo "`docker rm -f centos8`" && \
docker run -itd --restart always --name centos8 \
-p 10022:22 \
centos:8 /usr/sbin/init && \
sleep 1 && echo -e "\n`docker logs centos8`\n"

# 解决centos8停止服务问题
sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-* && sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-* && yum update -y


echo "`docker rm -f oracle_11g`" && \
docker run -itd --restart always --name oracle_11g \
-p 1521:1521 \
registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g && \
sleep 1 && echo -e "\n`docker logs oracle_11g`\n"


echo "`docker rm -f nginxwebui`" && \
docker run -itd --restart always --name nginxwebui \
--privileged=true \
--net=host \
registry.cn-hangzhou.aliyuncs.com/cym1102/nginxwebui:1.6.2 /bin/bash && \
sleep 1 && echo -e "\n`docker logs nginxwebui`\n"


echo "`docker rm -f rabbit`" && \
docker run -itd --restart always --name rabbit \
-p 15672:15672 -p 5672:5672 \
-e RABBITMQ_DEFAULT_USER=admin \
-e RABBITMQ_DEFAULT_PASS=admin \
rabbitmq:3-management && \
sleep 1 && echo -e "\n`docker logs rabbit`\n"


echo "`docker rm -f kafka-raft-3.0.0`" && \
docker run -tid --restart always --name kafka-raft-3.0.0 \
-p 9092:9092 \
-v /opt/kafka/kraft-combined-logs:/tmp/kraft-combined-logs \
kubebiz/kafka:2.13-3.0.0 \
/bin/bash -c "kafka-storage.sh format --cluster-id AAAAAAAAAAAAAAAAAAAAAA -c /opt/kafka/config/kraft/server.properties && \ 
exec kafka-server-start.sh /opt/kafka/config/kraft/server.properties" && \
sleep 1 && echo -e "\n`docker logs kafka-raft-3.0.0`\n"


echo "`docker rm -f redis`" && \
docker run -itd --restart always --name redis -p 6379:6379 redis && \
sleep 1 && echo -e "\n`docker logs redis`\n"


# http://localhost:3000 创建管理员帐户是可选的。第一个注册用户将自动成为管理员
echo "`docker rm -f gitea`" && \
docker run -tid --restart always --name=gitea \
-p 10022:22 -p 3000:3000 \
-v /opt/gitea:/data \
gitea/gitea && \
sleep 1 && echo -e "\n`docker logs gitea`\n"


# nexus3 默认账密admin/admin123
echo `docker rm -f nexus3` && \
docker run -itd --restart always -v /etc/timezone:/etc/timezone -v /etc/localtime:/etc/localtime:ro --name nexus3 \
-p 8081-8085:8081-8085 \
-v /root/docker_data/nexus:/nexus-data \
sonatype/nexus3 && \
sleep 1 && echo -e "\n`docker logs nexus3`\n"


# baota http://localhost:8888 默认账密 username/password
# 若密码不正确，进入容器，然后输入bt命令，选择5，修改密码，然后继续bt命令，选择16，升级宝塔
echo "`docker rm -f baota`" && \
docker run -itd --restart always --name baota \
--link mysql57 \
-p 8888:8888 \
-v /opt/baota:/www/wwwroot \
--shm-size=128m \
pch18/baota:clear && \
sleep 1 && echo -e "\n`docker logs baota`\n"


# http://localhost:8080/xxl-job-admin 默认账密 admin 123456, 后面附有mysql脚本，提前执行
echo "`docker rm -f xxljob`" && \
docker run -itd --restart always --name xxljob \
-v /opt/xxljob/applogs:/data/applogs \
-p 8080:8080 \
--link mysql57 \
-e PARAMS="--spring.datasource.url=jdbc:mysql://mysql57:3306/xxl_job?Unicode=true&characterEncoding=UTF-8 \
--spring.datasource.username=root \
--spring.datasource.password=root \
--xxl.job.accessToken=xdsl3ewi3al1oehxmo68pqxer" \
 xuxueli/xxl-job-admin:2.3.0 && \
sleep 1 && echo -e "`docker logs xxljob`"


echo "`docker rm -f mysql57`" && \
docker run -itd --restart always --name mysql57 \
-v /opt/mysql/conf/:/etc/mysql -v /opt/mysql/logs:/logs -v /opt/mysql/data:/var/lib/mysql \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=1hM9nwytxk^l$wxd \
mysql:5.7 --lower_case_table_names=1 --default-time_zone='+8:00' && \
sleep 1 && echo -e "`docker logs mysql57`"

# Mysql57 进入容器，修改密码和远程登录
mysql -uroot -p1hM9nwytxk^l$wxd
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;


# PostgreSQL-12.0、GEOS-3.8.0、Proj-6.2.0、PostGIS-3.0.0
echo "`docker rm -f postgis`" && \
docker run -itd --restart always -v /etc/timezone:/etc/timezone -v /etc/localtime:/etc/localtime:ro --name postgis \
--privileged \
-p 5432:5432 \
-e POSTGRES_PASSWORD=postgres \
geographica/postgis && \
sleep 1 && echo -e "\n`docker logs postgis`\n"


echo "`docker rm -f postgres128`" && \
docker run -itd --restart always --name postgres128 \
-p 5432:5432 \
-e POSTGRES_PASSWORD=postgres \
postgres:12.8 && \
sleep 1 && echo -e "\n`docker logs postgres128`\n"

# 安装 postgis、pgrouting、ogr_fdw
apt update && \
apt-get install -y postgresql-12-postgis-3 postgresql-12-postgis-3-dbgsym && postgresql-12-postgis-3-scripts && \
apt-get install -y postgresql-12-pgrouting postgresql-12-pgrouting-dbgsym && postgresql-12-pgrouting-scripts && \
apt-get install -y postgresql-12-ogr-fdw postgresql-12-ogr-fdw-dbgsym



# docker run --rm -d --name clickhouse-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9009:9009 -p 9000:9000 yandex/clickhouse-server
# docker cp clickhouse-server:/etc/clickhouse-server/config.xml .
# docker cp clickhouse-server:/etc/clickhouse-server/users.xml .
# default:clickhouse
#<password_sha256_hex>7e099f39b84ea79559b3e85ea046804e63725fd1f46b37f281276aae20f86dc3</password_sha256_hex>

echo "`docker rm -f clickhouse-server`" && \
docker run -tid --restart always --name clickhouse-server \
-p 8123:8123 -p 9009:9009 -p 9000:9000 \
--ulimit nofile=262144:262144 \
-v /opt/clickhouse-server/data:/var/lib/clickhouse:rw \
-v /opt/clickhouse-server/log:/var/log/clickhouse-server:rw \
-v /opt/clickhouse-server/conf/config.xml:/etc/clickhouse-server/config.xml \
-v /opt/clickhouse-server/conf/users.xml:/etc/clickhouse-server/users.xml \
yandex/clickhouse-server && \
sleep 1 && echo -e "\n`docker logs clickhouse-server`\n"

xxl-job.sql

#
# XXL-JOB v2.3.1-SNAPSHOT
# Copyright (c) 2015-present, xuxueli.

CREATE database if NOT EXISTS `xxl_job` default character set utf8mb4 collate utf8mb4_unicode_ci;
use `xxl_job`;

SET NAMES utf8mb4;

CREATE TABLE `xxl_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_group` int(11) NOT NULL COMMENT '执行器主键ID',
  `job_desc` varchar(255) NOT NULL,
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `author` varchar(64) DEFAULT NULL COMMENT '作者',
  `alarm_email` varchar(255) DEFAULT NULL COMMENT '报警邮件',
  `schedule_type` varchar(50) NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
  `schedule_conf` varchar(128) DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
  `misfire_strategy` varchar(50) NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
  `executor_route_strategy` varchar(50) DEFAULT NULL COMMENT '执行器路由策略',
  `executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
  `executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
  `executor_block_strategy` varchar(50) DEFAULT NULL COMMENT '阻塞处理策略',
  `executor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
  `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  `glue_type` varchar(50) NOT NULL COMMENT 'GLUE类型',
  `glue_source` mediumtext COMMENT 'GLUE源代码',
  `glue_remark` varchar(128) DEFAULT NULL COMMENT 'GLUE备注',
  `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
  `child_jobid` varchar(255) DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
  `trigger_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
  `trigger_last_time` bigint(13) NOT NULL DEFAULT '0' COMMENT '上次调度时间',
  `trigger_next_time` bigint(13) NOT NULL DEFAULT '0' COMMENT '下次调度时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_group` int(11) NOT NULL COMMENT '执行器主键ID',
  `job_id` int(11) NOT NULL COMMENT '任务，主键ID',
  `executor_address` varchar(255) DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
  `executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
  `executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
  `executor_sharding_param` varchar(20) DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
  `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  `trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
  `trigger_code` int(11) NOT NULL COMMENT '调度-结果',
  `trigger_msg` text COMMENT '调度-日志',
  `handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
  `handle_code` int(11) NOT NULL COMMENT '执行-状态',
  `handle_msg` text COMMENT '执行-日志',
  `alarm_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
  PRIMARY KEY (`id`),
  KEY `I_trigger_time` (`trigger_time`),
  KEY `I_handle_code` (`handle_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_log_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trigger_day` datetime DEFAULT NULL COMMENT '调度-时间',
  `running_count` int(11) NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
  `suc_count` int(11) NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
  `fail_count` int(11) NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_logglue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL COMMENT '任务，主键ID',
  `glue_type` varchar(50) DEFAULT NULL COMMENT 'GLUE类型',
  `glue_source` mediumtext COMMENT 'GLUE源代码',
  `glue_remark` varchar(128) NOT NULL COMMENT 'GLUE备注',
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_registry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registry_group` varchar(50) NOT NULL,
  `registry_key` varchar(255) NOT NULL,
  `registry_value` varchar(255) NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i_g_k_v` (`registry_group`,`registry_key`,`registry_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(64) NOT NULL COMMENT '执行器AppName',
  `title` varchar(12) NOT NULL COMMENT '执行器名称',
  `address_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
  `address_list` text COMMENT '执行器地址列表，多地址逗号分隔',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '账号',
  `password` varchar(50) NOT NULL COMMENT '密码',
  `role` tinyint(4) NOT NULL COMMENT '角色：0-普通用户、1-管理员',
  `permission` varchar(255) DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
  PRIMARY KEY (`id`),
  UNIQUE KEY `i_username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xxl_job_lock` (
  `lock_name` varchar(50) NOT NULL COMMENT '锁名称',
  PRIMARY KEY (`lock_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `xxl_job_group`(`id`, `app_name`, `title`, `address_type`, `address_list`, `update_time`) VALUES (1, 'xxl-job-executor-sample', '示例执行器', 0, NULL, '2018-11-03 22:21:31' );
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `schedule_type`, `schedule_conf`, `misfire_strategy`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`) VALUES (1, 1, '测试任务1', '2018-11-03 22:21:31', '2018-11-03 22:21:31', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2018-11-03 22:21:31', '');
INSERT INTO `xxl_job_user`(`id`, `username`, `password`, `role`, `permission`) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL);
INSERT INTO `xxl_job_lock` ( `lock_name`) VALUES ( 'schedule_lock');

commit;