67 lines
1.6 KiB
YAML
67 lines
1.6 KiB
YAML
services:
|
|
mariadb-primary:
|
|
image: mariadb:latest
|
|
container_name: ${MARIA_PRIMARY_NAME}
|
|
command:
|
|
- --innodb_buffer_pool_size=536870912
|
|
- --key_buffer_size=67108864
|
|
- --query_cache_type=1
|
|
- --query_cache_size=134217728
|
|
- --query-cache-strip-comments=1
|
|
- --max-connections=256
|
|
- --log_bin=log_bin
|
|
- --binlog_format=ROW
|
|
- --server-id=${MARIA_SERVER_ID}
|
|
- --log_bin_trust_function_creators=1
|
|
ports:
|
|
- "${MARIA_PRIMARY_PORT}:3306"
|
|
networks:
|
|
- repl
|
|
volumes:
|
|
- mariadb-primary-data:/var/lib/mysql
|
|
environment:
|
|
MARIADB_USER: ${MARIA_USER}
|
|
MARIADB_PASSWORD: ${MARIA_PASS}
|
|
MARIADB_DATABASE: ${MARIA_NAME}
|
|
MARIADB_ROOT_PASSWORD: ${MARIA_PASS}
|
|
restart: always
|
|
|
|
mariadb-secondary:
|
|
image: mariadb:latest
|
|
container_name: secondary
|
|
command:
|
|
- --innodb_buffer_pool_size=536870912
|
|
- --key_buffer_size=67108864
|
|
- --max-connections=256
|
|
- --server-id=2
|
|
# - --read_only=ON
|
|
- --relay-log=relay-log
|
|
# - --log_bin=log_bin
|
|
# - --binlog_format=ROW
|
|
ports:
|
|
- "3307:3306"
|
|
networks:
|
|
- repl
|
|
volumes:
|
|
- mariadb-secondary-data:/var/lib/mysql
|
|
environment:
|
|
MARIADB_USER: ${MARIA_USER}
|
|
MARIADB_PASSWORD: ${MARIA_PASS}
|
|
MARIADB_DATABASE: ${MARIA_NAME}
|
|
MARIADB_ROOT_PASSWORD: ${MARIA_PASS}
|
|
restart: always
|
|
depends_on:
|
|
- mariadb-primary
|
|
|
|
|
|
|
|
networks:
|
|
repl:
|
|
name: repl
|
|
volumes:
|
|
mariadb-primary-data:
|
|
driver: local
|
|
mariadb-secondary-data:
|
|
driver: local
|
|
|