Postgres 主从模式 HOSTNAME IP master 192.168.2.11 replica 192.168.2.12 Docker master 创建目录赋权 mkdir -p /mnt/da/postgres/data chown 1000:1000 /mnt/da/postgres/data docker-compose.yml version: "3" services: postgres: image: timescale/timescaledb-ha:pg16.3-ts2.15.1-all container_name: postgres volumes: - /etc/localtime:/etc/localtime:ro - /mnt/da/postgres/data:/var/lib/postgresql/data environment: - TZ=Asia/Shanghai - PGDATA=/var/lib/postgresql/data/pgdata - POSTGRES_PASSWORD=postgres network_mode: host restart: always 启动 docker compose -f docker-compose.yml up -d 修改 postgresql.conf listen_addresses = '*' max_connections = 1024 password_encryption = scram-sha-256 shared_buffers = 32GB work_mem = 8192kB maintenance_work_mem = 32GB effective_io_concurrency = 512 max_worker_processes = 256 max_parallel_workers_per_gather = 128 max_parallel_workers = 64 wal_level = replica synchronous_commit = off checkpoint_completion_target = 0....

PXC 主从模式 HOSTNAME IP node1 192.168.2.11 node2 192.168.2.12 SWARM 集群 创建 SWARM 主节点 （–advertise-addr 用来指定使用哪个网卡的 IP） docker swarm init --advertise-addr 192.168.2.11 复制初始化输出的加入命令，在需要加入的机器执行 docker swarm join --token xxx 创建 PXC 专用的 overlay 网络 pxc docker network create -d overlay --attachable pxc Docker node1 创建目录，赋权 mkdir -p /opt/pxc-node1/conf /opt/pxc-node1/data /opt/pxc-node1/logs chmod 777 /opt/pxc-node1/conf /opt/pxc-node1/data /opt/pxc-node1/logs mysqld 配置 /opt/pxc-node1/conf/mysqld.cnf [mysqld] lower_case_table_names = 1 transaction-isolation = READ-COMMITTED log_error_suppression_list='MY-013360' docker-compose.yml version: "3" services: pxc-node1: image: percona/percona-xtradb-cluster:8....