Guest User

Untitled

a guest
Sep 24th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. mysql galera cluster
  2.  
  3. create my.cnf file
  4. ```
  5. $ nano my.cnf
  6. [mysqld]
  7. ndbcluster
  8. ndb-connectstring=10.20.30.10
  9. user=mysql
  10.  
  11. [mysql_cluster]
  12. ndb-connectstring=10.20.30.10
  13. ```
  14.  
  15. and create mysql-cluster.cnf
  16. ```
  17. $ nano mysql-cluster.cnf
  18. [ndb_mgmd]
  19. NodeId=1
  20. hostname=10.20.30.10
  21. datadir=/var/lib/mysql
  22.  
  23. [ndbd]
  24. NodeId=2
  25. hostname=10.20.30.50
  26. datadir=/var/lib/mysql
  27.  
  28. [ndbd]
  29. NodeId=3
  30. hostname=10.20.30.51
  31. datadir=/var/lib/mysql
  32.  
  33. [mysqld]
  34. NodeId=4
  35. hostname=10.20.30.100
  36.  
  37. [mysqld]
  38. NodeId=5
  39. hostname=10.20.30.101
  40. ```
  41. create docker-compose.yaml
  42. ```
  43. version: "3.3"
  44. services:
  45.  
  46. mysql-mgm1:
  47. image: mysql/mysql-cluster
  48. volumes:
  49. - $PWD/my.cnf:/etc/my.cnf
  50. - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
  51. networks:
  52. dev_net:
  53. ipv4_address: 10.20.30.10
  54. command:
  55. - ndb_mgmd
  56.  
  57. mysql-ndb1:
  58. image: mysql/mysql-cluster
  59. volumes:
  60. - $PWD/my.cnf:/etc/my.cnf
  61. - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
  62. networks:
  63. dev_net:
  64. ipv4_address: 10.20.30.50
  65. command:
  66. - ndbd
  67.  
  68. mysql-ndb2:
  69. image: mysql/mysql-cluster
  70. volumes:
  71. - $PWD/my.cnf:/etc/my.cnf
  72. - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
  73. networks:
  74. dev_net:
  75. ipv4_address: 10.20.30.51
  76. command:
  77. - ndbd
  78.  
  79. mysql-srv1:
  80. image: mysql/mysql-cluster
  81. volumes:
  82. - $PWD/my.cnf:/etc/my.cnf
  83. - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
  84. networks:
  85. dev_net:
  86. ipv4_address: 10.20.30.100
  87. environment:
  88. - MYSQL_ROOT_PASSWORD=root
  89. command:
  90. - mysqld
  91.  
  92. mysql-srv2:
  93. image: mysql/mysql-cluster
  94. volumes:
  95. - $PWD/my.cnf:/etc/my.cnf
  96. - $PWD/mysql-cluster.cnf:/etc/mysql-cluster.cnf
  97. networks:
  98. dev_net:
  99. ipv4_address: 10.20.30.101
  100. environment:
  101. - MYSQL_ROOT_PASSWORD=root
  102. command:
  103. - mysqld
  104.  
  105. networks:
  106. dev_net:
  107. driver: bridge
  108. ipam:
  109. driver: default
  110. config:
  111. -
  112. subnet: 10.20.0.0/16
  113. ```
Add Comment
Please, Sign In to add comment