{"id":856,"date":"2012-06-05T02:16:05","date_gmt":"2012-06-04T18:16:05","guid":{"rendered":"http:\/\/nick.workao.org\/?p=856"},"modified":"2012-06-05T02:16:05","modified_gmt":"2012-06-04T18:16:05","slug":"mysql-cluster-7-%e5%8a%a8%e6%80%81%e5%a2%9e%e5%8a%a0%e6%95%b0%e6%8d%ae%e8%8a%82%e7%82%b9%e9%85%8d%e7%bd%ae%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"https:\/\/nick.txtcc.com\/index.php\/linux\/856","title":{"rendered":"mysql cluster 7 \u52a8\u6001\u589e\u52a0\u6570\u636e\u8282\u70b9\u914d\u7f6e\u6b65\u9aa4"},"content":{"rendered":"
vi \/usr\/local\/mysql\/mysql-cluster\/config.ini<\/p>\n
[ndbd default]<\/p>\n
DataMemory =100M<\/p>\n
IndexMemory =100M<\/p>\n
NoOfReplicas = 2<\/p>\n
DataDir = \/usr\/local\/mysql\/var\/mysql-cluster<\/p>\n
[ndbd]<\/p>\n
Id = 1<\/p>\n
HostName = 172.20.86.188<\/p>\n
<\/p>\n
[ndbd]<\/p>\n
Id = 2<\/p>\n
HostName = 172.20.86.189<\/p>\n
<\/p>\n
[mgm]<\/p>\n
HostName = 172.20.86.185<\/p>\n
Id = 10<\/p>\n
<\/p>\n
[mysqld]<\/p>\n
Id=20<\/p>\n
HostName = 172.20.86.185<\/p>\n
<\/p>\n
2\u5728185\u4e0a\u8fd0\u884cndb_mgm<\/p>\n
Ndb_mgm>show<\/p>\n
-- NDB Cluster -- Management Client --<\/pre>\nndb_mgm><strong>SHOW<\/strong><\/code><\/pre>\nConnected to Management Server<\/strong><\/span> at: 172.20.86.185:1186<\/pre>\nCluster Configuration<\/pre>\n---------------------<\/pre>\n[ndbd(NDB)]\u00a0\u00a0\u00a0\u00a02 node(s)<\/pre>\nid=1\u00a0\u00a0\u00a0@172.20.86.188\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0, Master)<\/pre>\nid=2\u00a0\u00a0\u00a0@172.20.86.189\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0)<\/pre>\n<\/pre>\n[ndb_mgmd(MGM)] 1 node(s)<\/pre>\nid=10\u00a0\u00a0@172.20.86.185\u00a0(5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\n[mysqld(API)]\u00a0\u00a02 node(s)<\/pre>\nid=20\u00a0\u00a0@172.20.86.185\u00a0(5.1.32-ndb-7.0.5)<\/pre>\n <\/p>\n
 <\/p>\n
Step 1: Update configuration file<\/h2>\n <\/p>\n
[ndbd default]<\/pre>\nDataMemory =100M<\/pre>\nIndexMemory =100M<\/pre>\nNoOfReplicas = 2<\/pre>\nDataDir = \/usr\/local\/mysql\/var\/mysql-cluster<\/pre>\n<\/pre>\n[ndbd]<\/pre>\nId = 1<\/pre>\nHostName = 172.20.86.188<\/pre>\n<\/pre>\n[ndbd]<\/pre>\nId = 2<\/pre>\nHostName = 172.20.86.189<\/pre>\n<\/pre>\n[ndbd]<\/strong><\/pre>\nId = 3<\/strong><\/pre>\nHostName<\/strong>\n=<\/strong>\n172.20.86.187<\/strong><\/strong><\/pre>\n\u00a0<\/strong><\/pre>\n[ndbd]<\/strong><\/pre>\nId = 4<\/strong><\/pre>\nHostName<\/strong>\n=<\/strong>\n172.20.86.186<\/strong><\/pre>\n<\/pre>\n[mgm]<\/pre>\nHostName = 172.20.86.185<\/pre>\nId = 10<\/pre>\n<\/pre>\n[mysqld]<\/pre>\nId=20<\/pre>\nHostName = 172.20.86.185<\/pre>\n <\/p>\n
 <\/p>\n
Step 2: Restart the management server<\/h2>\n
Step 2.1\u505c\u6b62\u7ba1\u7406<\/strong><\/span>\u8282\u70b9<\/h3>\nndb_mgm><strong>10 STOP<\/strong><\/code><\/pre>\nNode 10 has shut down.<\/pre>\nDisconnecting to allow Management Server to shutdown<\/pre>\nshell><\/pre>\nStep 2.2\u91cd\u65b0\u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6<\/h3>\nshell><strong>ndb_mgmd -f config.ini --reload<\/strong><\/code><\/pre>\n2008-12-08 17:29:23 [MgmSrvr] INFO\u00a0\u00a0\u00a0\u00a0-- NDB Cluster Management Server.5.1.34-ndb-7.0.7<\/pre>\n2008-12-08 17:29:23 [MgmSrvr] INFO\u00a0\u00a0\u00a0\u00a0--Readingcluster configuration from 'config.ini'<\/pre>\nStep 2.3\u67e5\u770b\u65b0\u96c6\u7fa4\u72b6\u6001<\/h3>\n-- NDB Cluster -- Management Client --<\/pre>\nndb_mgm><strong>SHOW<\/strong><\/code><\/pre>\nConnected to Management Server at: 172.20.86.185:1186<\/pre>\nCluster Configuration<\/pre>\n---------------------<\/pre>\n[ndbd(NDB)]\u00a0\u00a0\u00a0\u00a02 node(s)<\/pre>\nid=1\u00a0\u00a0\u00a0@172.20.86.188\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0, Master)<\/pre>\nid=2\u00a0\u00a0\u00a0@172.20.86.189\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0)<\/pre>\nid=3 (not connected, accepting connect from 172.20.86.186)<\/pre>\nid=4 (not connected, accepting connect from 172.20.86.187)<\/pre>\n<\/pre>\n[ndb_mgmd(MGM)] 1 node(s)<\/pre>\nid=10\u00a0\u00a0@172.20.86.185\u00a0(5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\n[mysqld(API)]\u00a0\u00a01 node(s)<\/pre>\nid=20\u00a0\u00a0@172.20.86.185 (5.1.32-ndb-7.0.5)<\/pre>\n <\/p>\n
Step 3: Perform. a rolling restart of the existing data<\/strong><\/span> nodes \u2013\u8f6e\u6d41\u91cd\u65b0\u542f\u52a8\u8fde\u63a5\u7684\u6570\u636e\u8282\u70b9<\/h2>\nndb_mgm><strong>1 RESTART<\/strong><\/code><\/pre>\nNode 1: Node shutdown initiated<\/pre>\nNode 1: Node shutdown completed, restarting, no start.<\/pre>\nNode 1 is being restarted<\/pre>\n<\/pre>\nndb_mgm> Node 1: Start initiated (version7.0.5)<\/pre>\nNode 1: Started (version7.0.5)<\/pre>\n<\/pre>\nndb_mgm><strong>2 RESTART<\/strong><\/code><\/pre>\nNode 2: Node shutdown initiated<\/pre>\nNode 2: Node shutdown completed, restarting, no start.<\/pre>\nNode 2 is being restarted<\/pre>\n <\/p>\n
Step 4: Perform. a rolling restart of all cluster API nodes \u2013\u8f6e\u6d41\u91cd\u542fsql<\/strong><\/span>\u8282\u70b9<\/h2>\n\u672c\u6848\u4ec5\u6709\u4e00\u4e2asql\u8282\u70b9<\/p>\n
shell>mysqladmin -uroot -p<em>password<\/em>shutdown<\/code><\/pre>\nshell>mysqld_safe &<\/code><\/pre>\n <\/p>\n
Step 5: Perform. an initial start of the new data nodes \u2013\u521d\u59cb\u5316\u65b0\u7684\u6570\u636e\u8282\u70b9<\/h2>\n <\/p>\n
\u5728\u65b0\u589e\u7684\u6570\u636e\u8282\u70b9\u4e0a186\u548c187\u4e0a\u6267\u884c<\/p>\n
Shell>ndbmtd \u2013initial<\/p>\n
\u6216\u8005<\/p>\n
Shell>ndbd \u2013initial<\/p>\n
\u767b\u9646\u7ba1\u7406\u8282\u70b9\u67e5\u770b\u96c6\u7fa4\u72b6\u6001<\/p>\n
Connected to Management Server at: 172.20.86.185:1186<\/pre>\nCluster Configuration<\/pre>\n---------------------<\/pre>\n[ndbd(NDB)]\u00a0\u00a0\u00a0\u00a02 node(s)<\/pre>\nid=1\u00a0\u00a0\u00a0@172.20.86.188\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0, Master)<\/pre>\nid=2\u00a0\u00a0\u00a0@172.20.86.189\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0)<\/pre>\nid=3\u00a0\u00a0\u00a0@172.20.86.186\u00a0(5.1.32-ndb-7.0.5,no nodegroup<\/strong>)<\/pre>\nid=4\u00a0\u00a0\u00a0@172.20.86.187\u00a0(5.1.32-ndb-7.0.5,no nodegroup<\/strong>)<\/pre>\n<\/pre>\n[ndb_mgmd(MGM)] 1 node(s)<\/pre>\nid=10\u00a0\u00a0@172.20.86.185\u00a0(5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\n[mysqld(API)]\u00a0\u00a02 node(s)<\/pre>\nid=20\u00a0\u00a0@172.20.86.185 (5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\nStep 6: Create a new node group.<\/h2>\nndb_mgm><strong>CREATE NODEGROUP 3,4<\/strong><\/code><\/pre>\nNodegroup 1 created<\/pre>\n\u00a0<\/strong><\/pre>\nndb_mgm><strong>SHOW<\/strong><\/code><\/pre>\nConnected to Management Server at: 172.20.86.185:1186<\/pre>\nCluster Configuration<\/pre>\n---------------------<\/pre>\n[ndbd(NDB)]\u00a0\u00a0\u00a0\u00a02 node(s)<\/pre>\nid=1\u00a0\u00a0\u00a0@172.20.86.188\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0, Master)<\/pre>\nid=2\u00a0\u00a0\u00a0@172.20.86.189\u00a0(5.1.32-ndb-7.0.5, Nodegroup: 0)<\/pre>\nid=3\u00a0\u00a0\u00a0@172.20.86.186 (5.1.32-ndb-7.0.5,Nodegroup: 1<\/strong>)<\/pre>\nid=4\u00a0\u00a0\u00a0@172.20.86.187 (5.1.32-ndb-7.0.5,Nodegroup: 1<\/strong>)<\/pre>\n<\/pre>\n[ndb_mgmd(MGM)] 1 node(s)<\/pre>\nid=10\u00a0\u00a0@172.20.86.185 (5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\n[mysqld(API)]\u00a0\u00a01 node(s)<\/pre>\nid=20\u00a0\u00a0@172.20.86.185 (5.1.32-ndb-7.0.5)<\/pre>\n<\/pre>\nStep 7: Redistribute cluster data. \u2013\u6570\u636e\u7684\u91cd\u65b0\u5206\u914d<\/h2>\n <\/p>\n
\u5bf9\u4e8e\u65b0\u589e\u7684\u6570\u636e\u8282\u70b9\u4e00\u4e9b\u8bbf\u95ee\u91cf\u8f83\u9ad8\u7684\u6570\u636e\u548c\u6bd4\u8f83\u91cd\u8981\u7684\u6570\u636e\u9700\u8981\u4ece\u65b0\u5206\u914d\u3002<\/p>\n
 <\/p>\n
\u5206\u53d1\u6570\u636e\u547d\u4ee4\uff1a<\/p>\n
Alter online table ips reorganize partition;<\/p>\n
\u67e5\u770b\u6570\u636e\u7684\u5206\u914d\u60c5\u51b5\uff1a<\/p>\n
ndb_mgm><strong>ALL REPORT MEMORY<\/strong><\/code><\/pre>\n<\/pre>\nNode 1: Data usage is 5%(177 32K pages of total 3200)<\/pre>\nNode 1: Index usage is 0%(108 8K pages of total 12832)<\/pre>\nNode 2: Data usage is 5%(177 32K pages of total 3200)<\/pre>\nNode 2: Index usage is 0%(108 8K pages of total 12832)<\/pre>\nNode 3: Data usage is 0%(0 32K pages of total 3200)<\/strong><\/pre>\nNode 3: Index usage is 0%(0 8K pages of total 12832)<\/strong><\/pre>\nNode 4: Data usage is 0%(0 32K pages of total 3200)<\/strong><\/pre>\nNode 4: Index usage is 0%(0 8K pages of total 12832)<\/strong><\/pre>\n\u6216\u8005<\/p>\n
shell><strong>ndb_desc -c 192.168.0.10 -d n ips -p<\/strong><\/code><\/pre>\n-- ips --<\/pre>\nVersion: 1<\/pre>\nFragment type: 9<\/pre>\nK Value: 6<\/pre>\nMin load factor: 78<\/pre>\nMax load factor: 80<\/pre>\nTemporary table: no<\/pre>\nNumber of attributes: 6<\/pre>\nNumber of primary keys: 1<\/pre>\nLength of frm data: 340<\/pre>\nRow Checksum: 1<\/pre>\nRow GCI: 1<\/pre>\nSingleUserMode: 0<\/pre>\nForceVarPart: 1<\/pre>\nFragmentCount: 2<\/pre>\nTableStatus: Retrieved<\/pre>\n-- Attributes --<\/pre>\nid Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR<\/pre>\ncountry_code Char(2;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY<\/pre>\ntype Char(4;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY<\/pre>\nip_address Varchar(15;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY<\/pre>\naddresses Bigunsigned NULL AT=FIXED ST=MEMORY<\/pre>\ndate Bigunsigned NULL AT=FIXED ST=MEMORY<\/pre>\n<\/pre>\n-- Indexes --<\/pre>\nPRIMARY KEY(id) - UniqueHashIndex<\/pre>\nPRIMARY(id) - OrderedIndex<\/pre>\n<\/pre>\n-- Per partition info --<\/strong><\/pre>\nPartition\u00a0\u00a0Row count\u00a0\u00a0Commit count\u00a0Frag fixed memory\u00a0\u00a0Frag varsized memory<\/strong><\/pre>\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a026086\u00a0\u00a0\u00a0\u00a0\u00a0\u00a026086\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01572864\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0557056<\/strong><\/pre>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a026329\u00a0\u00a0\u00a0\u00a0\u00a0\u00a026329\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01605632\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0557056<\/strong><\/pre>\n<\/pre>\nNDBT_ProgramExit: 0 - OK<\/pre>\nYou can cause the data to be redistributed among all of the data nodes by performing, for eachNDBCLUSTER<\/code>table, anALTER ONLINE TABLE ... REORGANIZE PARTITION<\/code>statement in themysql<\/strong><\/span><\/strong>client. After issuing the statementALTER ONLINE TABLE ips REORGANIZE PARTITION<\/code>, you can see usingndb_desc<\/strong>that the data for this table is now stored using 4 partitions, as shown here (with the relevant portions of the output in bold type):<\/p>\n
shell><strong>ndb_desc -c 172.20.86.185 -d n ips -p<\/strong><\/code><\/pre>\n-- ips --<\/pre>\nVersion: 16777217<\/pre>\nFragment type: 9<\/pre>\nK Value: 6<\/pre>\nMin load factor: 78<\/pre>\nMax load factor: 80<\/pre>\nTemporary table: no<\/pre>\nNumber of attributes: 6<\/pre>\nNumber of primary keys: 1<\/pre>\nLength of frm data: 341<\/pre>\nRow Checksum: 1<\/pre>\nRow GCI: 1<\/pre>\nSingleUserMode: 0<\/pre>\nForceVarPart: 1<\/pre>\nFragmentCount: 4<\/pre>\nTableStatus: Retrieved<\/pre>\n-- Attributes --<\/pre>\nid Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR<\/pre>\ncountry_code Char(2;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY<\/pre>\ntype Char(4;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY<\/pre>\nip_address Varchar(15;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY<\/pre>\naddresses Bigunsigned NULL AT=FIXED ST=MEMORY<\/pre>\ndate Bigunsigned NULL AT=FIXED ST=MEMORY<\/pre>\n<\/pre>\n-- Indexes --<\/pre>\nPRIMARY KEY(id) - UniqueHashIndex<\/pre>\nPRIMARY(id) - OrderedIndex<\/pre>\n<\/pre>\n-- Per partition info --<\/strong><\/pre>\nPartition\u00a0\u00a0Row count\u00a0\u00a0Commit count\u00a0Frag fixed memory\u00a0\u00a0Frag varsized memory<\/strong><\/pre>\n0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a012981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a052296\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01572864\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0557056<\/strong><\/pre>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013236\u00a0\u00a0\u00a0\u00a0\u00a0\u00a052515\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01605632\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0557056<\/strong><\/pre>\n2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013105\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013105\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0819200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0294912<\/strong><\/pre>\n3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013093\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013093\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0819200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0294912<\/strong><\/pre>","protected":false},"excerpt":{"rendered":"vi \/usr\/local\/mysql\/mysql-cluster\/config.ini [ndbd default] DataMemory =100M IndexMemory =100M NoOfR...<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[324,100],"class_list":["post-856","post","type-post","status-publish","format-standard","hentry","category-linux","tag-cluster","tag-mysql"],"_links":{"self":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=856"}],"version-history":[{"count":2,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/856\/revisions"}],"predecessor-version":[{"id":858,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/856\/revisions\/858"}],"wp:attachment":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}