Conmi-WhiteJoker
commented
2 years ago My changes are based on this file:"https://github.com/severalnines/galera-docker-mariadb/blob/master/example-compose/performance/global.yml" `version: '3'
services:
---------------------------------------------------------------------
mariadb_galera_1: container_name: mariadb_galera_1 deploy: mode: global restart_policy: condition: on-failure delay: 10s max_attempts: 10 placement: constraints:
- node.labels.database == galera # node must be labelled accordingly
resources:
limits:
cpus: '2'
memory: 1.5G
reservations:
memory: 1G
update_config:
parallelism: 1
delay: 3m # must be higher than SST duration
image: severalnines/mariadb:10.1
hostname: "mariadb_galera_1"
ports:
- "13306:3306"
- "12379:2379" environment: CLUSTER_NAME: "MariaDB_Galera" DISCOVERY_SERVICE: "mariadb_galera_1:12379,mariadb_galera_2:22379,mariadb_galera_3:32379" MYSQL_ROOT_PASSWORD: "root" XTRABACKUP_PASSWORD: "root" command:
- --innodb_buffer_pool_size=512M
- --max_connections=51
- --wsrep_slave_thread=4
- --wsrep_provider_options=gcache.size=1G networks:
- db_galera_net volumes:
- ./datadir1:/var/lib/mysql
ulimits:
nofile:
soft: 20000
hard: 40000
healthcheck:
interval: 10s
retries: 20 # interval * retries > SST duration
---------------------------------------------------------------------
mariadb_galera_2: container_name: mariadb_galera_2 deploy: mode: global restart_policy: condition: on-failure delay: 10s max_attempts: 10 placement: constraints:
- node.labels.database == galera # node must be labelled accordingly
resources:
limits:
cpus: '2'
memory: 1.5G
reservations:
memory: 1G
update_config:
parallelism: 1
delay: 3m # must be higher than SST duration
image: severalnines/mariadb:10.1
hostname: "mariadb_galera_2"
ports:
- "23306:3306"
- "22379:2379" environment: CLUSTER_NAME: "MariaDB_Galera" DISCOVERY_SERVICE: "mariadb_galera_1:12379,mariadb_galera_2:22379,mariadb_galera_3:32379" MYSQL_ROOT_PASSWORD: "root" XTRABACKUP_PASSWORD: "root" command:
- --innodb_buffer_pool_size=512M
- --max_connections=51
- --wsrep_slave_thread=4
- --wsrep_provider_options=gcache.size=1G networks:
- db_galera_net volumes:
- ./datadir2:/var/lib/mysql ulimits: nofile: soft: 20000 hard: 40000 healthcheck: interval: 10s retries: 20 # interval * retries > SST duration depends_on:
- mariadb_galera_1
---------------------------------------------------------------------
mariadb_galera_3: container_name: mariadb_galera_3 deploy: mode: global restart_policy: condition: on-failure delay: 10s max_attempts: 10 placement: constraints:
- node.labels.database == galera # node must be labelled accordingly
resources:
limits:
cpus: '2'
memory: 1.5G
reservations:
memory: 1G
update_config:
parallelism: 1
delay: 3m # must be higher than SST duration
image: severalnines/mariadb:10.1
hostname: "mariadb_galera_3"
ports:
- "33306:3306"
- "32379:2379" environment: CLUSTER_NAME: "MariaDB_Galera" DISCOVERY_SERVICE: "mariadb_galera_1:12379,mariadb_galera_2:22379,mariadb_galera_3:32379" MYSQL_ROOT_PASSWORD: "root" XTRABACKUP_PASSWORD: "root" command:
- --innodb_buffer_pool_size=512M
- --max_connections=51
- --wsrep_slave_thread=4
- --wsrep_provider_options=gcache.size=1G networks:
- db_galera_net volumes:
- ./datadir3:/var/lib/mysql ulimits: nofile: soft: 20000 hard: 40000 healthcheck: interval: 10s retries: 20 # interval * retries > SST duration depends_on:
- mariadb_galera_1
- mariadb_galera_2
---------------------------------------------------------------------
networks: db_galera_net: driver: overlay
volumes: datadir:`
As a student, I do not have multiple servers, and I always fail to build multiple database clusters based on a single server. I hope that a single "docker-comemess. yml" file can teach me, so that I can learn the configuration principle from a file, thank you.