Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql galera cluster
- create my.cnf file
- ```
- $ nano my.cnf
- [mysqld]
- ndbcluster
- ndb-connectstring=10.20.30.10
- user=mysql
- [mysql_cluster]
- ndb-connectstring=10.20.30.10
- ```
- and create mysql-cluster.cnf
- ```
- $ nano mysql-cluster.cnf
- [ndb_mgmd]
- NodeId=1
- hostname=10.20.30.10
- datadir=/var/lib/mysql
- [ndbd]
- NodeId=2
- hostname=10.20.30.50
- datadir=/var/lib/mysql
- [ndbd]
- NodeId=3
- hostname=10.20.30.51
- datadir=/var/lib/mysql
- [mysqld]
- NodeId=4
- hostname=10.20.30.100
- [mysqld]
- NodeId=5
- hostname=10.20.30.101
- ```
- create docker-compose.yaml
- ```
- version: "3.3"
- services:
- mysql-mgm1:
- image: mysql/mysql-cluster
- volumes:
- - $PWD/my.cnf:/etc/my.cnf
- - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
- networks:
- dev_net:
- ipv4_address: 10.20.30.10
- command:
- - ndb_mgmd
- mysql-ndb1:
- image: mysql/mysql-cluster
- volumes:
- - $PWD/my.cnf:/etc/my.cnf
- - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
- networks:
- dev_net:
- ipv4_address: 10.20.30.50
- command:
- - ndbd
- mysql-ndb2:
- image: mysql/mysql-cluster
- volumes:
- - $PWD/my.cnf:/etc/my.cnf
- - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
- networks:
- dev_net:
- ipv4_address: 10.20.30.51
- command:
- - ndbd
- mysql-srv1:
- image: mysql/mysql-cluster
- volumes:
- - $PWD/my.cnf:/etc/my.cnf
- - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
- networks:
- dev_net:
- ipv4_address: 10.20.30.100
- environment:
- - MYSQL_ROOT_PASSWORD=root
- command:
- - mysqld
- mysql-srv2:
- image: mysql/mysql-cluster
- volumes:
- - $PWD/my.cnf:/etc/my.cnf
- - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
- networks:
- dev_net:
- ipv4_address: 10.20.30.101
- environment:
- - MYSQL_ROOT_PASSWORD=root
- command:
- - mysqld
- networks:
- dev_net:
- driver: bridge
- ipam:
- driver: default
- config:
- -
- subnet: 10.20.0.0/16
- ```
Add Comment
Please, Sign In to add comment