{"id":875,"date":"2012-06-13T18:46:15","date_gmt":"2012-06-13T10:46:15","guid":{"rendered":"http:\/\/nick.workao.org\/?p=875"},"modified":"2012-06-13T18:46:15","modified_gmt":"2012-06-13T10:46:15","slug":"redhat%e4%b8%8bmysql%e9%9b%86%e7%be%a4%e7%9a%84%e5%ae%89%e8%a3%85%e4%b8%8e%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/nick.txtcc.com\/index.php\/linux\/875","title":{"rendered":"redhat\u4e0bmysql\u96c6\u7fa4\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e"},"content":{"rendered":"<p>\u6211\u662f\u5728\u865a\u62df\u673a\u4e0a\u6d4b\u8bd5\u7684\uff0c\u4e09\u53f0\u673a\u5b50\u5206\u522b\u4e3a\uff1a<\/p>\n<p>192.168.2.100\uff0c\u7ba1\u7406\u8282\u70b9\u3002<\/p>\n<p>192.168.2.101\uff0c\u6570\u636e\u8282\u70b9\u548cSQL\u8282\u70b9\u3002<\/p>\n<p>192.168.2.102\uff0c\u6570\u636e\u8282\u70b9\u548cSQL\u8282\u70b9\u3002<\/p>\n<p>\u88c5\u7684\u7cfb\u7edf\u662f\uff1aRed Hat Enterprise Linux 4\u3002<\/p>\n<p>\u8f6f\u4ef6\u5305\u662f\uff1amysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz\u3002<\/p>\n<p>\u5b89\u88c5\u6b65\u9aa4<\/p>\n<p>1.\u7ba1\u7406\u8282\u70b9\u7684\u5b89\u88c5\n#groupadd mysql\n#useradd mysql -g mysql\n#mv mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz \/usr\/local\/\n#cd \/usr\/local\/\n#tar zxvf mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz\n#rm -f mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz\n#mv mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23 mysql\n#chown -R mysql:mysql mysql\n#cd mysql\n#scripts\/mysql_install_db &#8211;user=mysql<\/p>\n<p>2.\u7ba1\u7406\u8282\u70b9\u7684\u914d\u7f6e\n#mkdir \/var\/lib\/mysql-cluster\n#cd \/var\/lib\/mysql-cluster\n#vi config.ini\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\u8fd9\u91cc\u9700\u8981\u624b\u52a8\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9\n<strong>[ndbd default]<\/strong>\nNoOfReplicas=2\nDataMemory=80M\nIndexMemory=18M\n<strong>[ndb_mgmd]<\/strong>\nId=1\nHostname=192.168.2.100\ndatadir=\/usr\/local\/mysql\/logs\n<strong>[ndbd]<\/strong>\nId=2\nHostname=192.168.2.101\ndatadir=\/usr\/local\/mysql\/data\/<\/p>\n<p><strong>[ndbd]<\/strong>\nId=3\nHostname=192.168.2.102\ndatadir=\/usr\/local\/mysql\/data\/\n<strong>[MYSQLD]\n[MYSQLD]<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>3.\u5b89\u88c5\u548c\u914d\u7f6e\u6570\u636e\u8282\u70b9<\/p>\n<p>\u8fd9\u91cc2\u53f0\u673a\u5668\u6570\u636e\u8282\u70b9\u5b89\u88c5\u662f\u76f8\u540c\u7684.<\/p>\n<p>#groupadd mysql\n#useradd mysql -g mysql\n#mv mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz \/usr\/local\/\n#cd \/usr\/local\/\n#tar zxvf mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz\n#rm -f mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23.tar.gz\n#mv mysql-cluster-gpl-7.1.2a-beta-linux-i686-glibc23 mysql\n#chown -R mysql:mysql mysql\n#cd mysql\n#scripts\/mysql_install_db &#8211;user=mysql\n#cp support-files\/my-medium.cnf \/etc\/my.cnf\n#cp support-files\/mysql.server \/etc\/init.d\/mysqld\n#vi \/etc\/my.cnf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\u8fd9\u91cc\u9700\u8981\u624b\u52a8\u6dfb\u52a0\u5982\u4e0b\u7684\u5185\u5bb9\n<strong>\u00a0[mysqld]<\/strong>\ndatadir=\/usr\/local\/mysql\/data\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\u8fd9\u91cc\u8981\u4e0e\u7ba1\u7406\u8282\u70b9\u7684 config.ini\u76f8\u540c\nndbcluster\nndb-connectstring=192.168.2.100\n<strong>[ndbd]<\/strong>\nconnect-string=192.168.2.100\n<strong>[mysql_cluster]<\/strong>\nndb-connectstring=192.168.2.100\n<strong>[ndb_mgm]<\/strong>\nconnect-string=192.168.2.100\n<strong>[ndb_mgmd]<\/strong>\nconfig-file=\/var\/lib\/mysql-cluster\/config.ini\u00a0 \/\/\u8fd9\u91cc\u8981\u6307\u5b9a\u7ba1\u7406\u8282\u70b9\u914d\u7f6e\u6587\u4ef6\u8def\u5f84<\/p>\n<p>&nbsp;\n4.\u542f\u52a8\u76f8\u5173\u670d\u52a1<\/p>\n<p>\u5728\u7ba1\u7406\u8282\u70b9\u542f\u52a8\u76f8\u5173\u670d\u52a1:\n#\/usr\/local\/mysql\/bin\/ndb_mgmd -f \/var\/lib\/mysql-cluster\/config.ini\n#netstat -lntpu\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:1186\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 7797\/ndb_mgmd<\/p>\n<p>\u770b\u52301186\u7aef\u53e3\u5f00\u653e\u4e86\u8bf4\u660e\u542f\u52a8\u662f\u6b63\u5e38\u7684.<\/p>\n<p>\u5728\u6570\u636e\u8282\u70b9\u542f\u52a8\u76f8\u5173\u670d\u52a1:\n#\/usr\/local\/mysql\/bin\/ndbd &#8211;initial\n#netstat -lntpu\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 192.168.2.101:32772\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 3392\/ndbd\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 192.168.2.101:32773\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:<\/em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 3392\/ndbd\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 192.168.2.101:32774\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 3392\/ndbd<\/p>\n<p>#service mysqld start\n#netstat -lntpu\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 :::3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :::*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\u00a0\u00a0\u00a0\u00a0\u00a0 3557\/mysqld<\/p>\n<p>\u53ef\u4ee5\u770b\u5230\u76f8\u5173\u7684ndbd\u670d\u52a1\u4ee5\u53camysql\u5df2\u7ecf\u542f\u52a8ok\u4e86.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u6211\u662f\u5728\u865a\u62df\u673a\u4e0a\u6d4b\u8bd5\u7684\uff0c\u4e09\u53f0\u673a\u5b50\u5206\u522b\u4e3a\uff1a 192.168.2.100\uff0c\u7ba1\u7406\u8282\u70b9\u3002 192.168.2.101\uff0c\u6570\u636e\u8282\u70b9\u548cSQL\u8282\u70b9\u3002 192.168.2.102\uff0c\u6570\u636e\u8282\u70b9\u548cSQL\u8282\u70b9\u3002 \u88c5\u7684\u7cfb\u7edf\u662f\uff1aRe&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-875","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/875","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=875"}],"version-history":[{"count":2,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/875\/revisions"}],"predecessor-version":[{"id":878,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/875\/revisions\/878"}],"wp:attachment":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}