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