mysql集群NDB方式摆设

1. 根本信息

     摆设呆板    脚色    摆设路径              192.168.0.1    管理节点    摆设目次: /alidata1/mysql-cluster-8.4.3          192.168.0.2    管理节点              192.168.0.3    数据/SQL节点    数据目次:          192.168.0.4    数据/SQL节点    /alidata1/mysql-cluster-8.4.3/data/ndb-mgmd          192.168.0.5    数据节点 – 新增    /alidata1/mysql-cluster-8.4.3/data/ndb-data          192.168.0.6    数据节点 – 新增    /alidata1/mysql-cluster-8.4.3/data/ndb-mysqld    2. 安装NDB

1. ## 1.将包上传 并解压
2. # pwd
3. /alidata1/
4. # tar zxf mysql-cluster-8.4.3-linux-glibc2.17-x86_64.tar.xz
5. # mv mysql-cluster-8.4.3-linux-glibc2.17-x86_64 mysql-cluster-8.4.3
6. # useradd mysql -s /sdbin/nologin -M  ## 新建用户
8. ## 2.配置与启动
9. ############ 2.1 管理节点 192.168.0.1 和 192.168.0.2 操作 ############
10. ## 2.1.1 创建目录
11. # mkdir /alidata1/mysql-cluster-8.4.3/data/ndb-mgmd
13. ## 2.1.2 新建配置
14. # cat mgmd.ini
15. [tcp default]
16. SendBufferMemory=2M
17. ReceiveBufferMemory=2M
19. [ndb_mgmd default]
20. DataDir=/alidata1/mysql-cluster-8.4.3/data/ndb-mgmd
22. [NDBD DEFAULT]
23. NoOfReplicas = 2
24. DataMemory = 512M
25. LockPagesInMainMemory=1
26. ODirect=1
27. NoOfFragmentLogFiles=300
28. DataDir=/alidata1/mysql-cluster-8.4.3/data/ndb-data
29. MaxNoOfConcurrentOperations=100000
30. SchedulerSpinTimer=400
31. SchedulerExecutionTimer=100
32. RealTimeScheduler=1
33. TimeBetweenGlobalCheckpoints=1000
34. TimeBetweenEpochs=200
35. RedoBuffer=32M
36. MaxNoOfTables=1024
37. MaxNoOfOrderedIndexes=256
39. [NDB_MGMD]
40. NodeId = 1
41. hostname = 192.168.0.1
42. [NDB_MGMD]
43. NodeId = 2
44. hostname = 192.168.0.2
46. [NDBD]
47. NodeId = 13
48. hostname = 192.168.0.3
50. [NDBD]
51. NodeId = 14
52. hostname = 192.168.0.4
54. [mysqld]
55. NodeId = 53
56. hostname = 192.168.0.3
57. [mysqld]
58. NodeId = 54
59. hostname = 192.168.0.4
61. ## 数据恢复时需要, 否则会报错
62. [mysqld]
63. [mysqld]
65. ## 2.1.3 启动管理节点  -- 第一次启动需要加上-initial初始化 以后不需要
66. # chown -R mysql.mysql /alidata1/mysql-cluster-8.4.3
67. # ./bin/ndb_mgmd --initial -f /alidata1/mysql-cluster-8.4.3/mgmd.ini --configdir=/alidata1/mysql-cluster-8.4.3}/data/ndb-mgmd   ## 192.168.0.1 执行(其中一个管理节点)
68. # ./bin/ndb_mgmd -c 192.168.0.1,192.168.0.2 --ndb-nodeid=2 -f /alidata1/mysql-cluster-8.4.3/mgmd.ini --configdir=/alidata1/mysql-cluster-8.4.3/data/ndb-mgmd/  ## 另外一个管理节点执行
70. ############ 2.2 数据节点 192.168.0.3 192.168.0.4 操作 ############
71. ## 2.2.1 创建相关目录
72. # mkdir /alidata1/mysql-cluster-8.4.3/data/ndb-data
74. ## 2.2.2 启动
75. # chown -R mysql.mysql /alidata1/mysql-cluster-8.4.3
76. # ./bin/ndbd --ndb-mgmd-host=192.168.0.1,192.168.0.2
78. ############ 2.3 mysql节点 192.168.0.3 192.168.0.4 操作 ############
79. ## 2.3.1 创建目录
80. # mkdir /alidata1/mysql-cluster-8.4.3/data/ndb-mysqld/ -p
81. # mkdir /alidata1/admin/logs/mysql/ -p
82. ## 2.3.2 修改配置
83. # vim /etc/my.cnf
84. [mysqld]
85. ndbcluster
86. ndb-connectstring=192.168.0.1,192.168.0.2
88. basedir=/alidata1/mysql-cluster-8.4.3
89. datadir=/alidata1/mysql-cluster-8.4.3/data/ndb-mysqld
90. socket=/alidata1/mysql-cluster-8.4.3/data/ndb-mysqld/mysql.sock
91. user=mysql
92. port=3306
93. mysql_native_password=ON
94. sql_mode=''
96. character-set-server = utf8mb4
97. open_files_limit = 65535
98. max_connections = 2000
99. max_connect_errors = 100000
100. lower_case_table_names = 1
101. default_time_zone = '+8:00'
103. #logs
104. log-output=fi

复制代码