linux下mysql集群的安装

《linux下mysql集群的安装》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、linux下mysql集群的安装2011-05-1318:30 1397人阅读 评论(1) 收藏 举报mysqllinuxshell集群数据库database目录(?)[+]1.下载安装文件操作系统：CentOSrelease5.5Mysql:   mysql-cluster-gpl-7.1.10-linux-i686-glibc23.tar.gz2.安装.tar.gz文件详情参考mysql的官方手册。 数据节点和mysql节点的安装1.检查系统中是否已经存在mysql用户和组。查看/etc/passwd和/etc/group文件，检查系统是否已存在mysql用户

2、和组。如果不存在，用以下命令添加：shell>groupaddmysqlshell>useradd–gmysqlmysql 2.解压安装。      2.1进入安装文件所在目录，假设在/var/tmp目录下：      shell>cd/var/tmp      shell>tar–C/usr/local–xzvf mysql-cluster-gpl-7.1.10-linux-i686-glibc23.tar.gz      shell>ln–s/usr/local/mysql-cluster-gpl-7.1.10-linux-i686-glibc23 /usr/

3、local/mysql       2.2执行安装脚本：      shell>cdmysql      shell>scripts/mysql_install_db–user=mysql       2.3修改权限：shell>chown–Rroot .shell>chown–Rmysqldatashell>chgrp–Rmysql. 2.4复制执行文件，加入系统启动项：shell>cpsupport-files/mysql.server/etc/rc.d/init.d/shell>chmod+x/etc/rc.d/init.d/mysql.servershel

4、l>chkconfig–addmysql.server  管理节点的安装1.解压安装shell>cd/var/tmp      shell>tar–xzvf mysql-cluster-gpl-7.1.10-linux-i686-glibc23.tar.gz      shell>cdmysql-cluster-gpl-7.1.10-linux-i686-glibc23      shell>cpbin/ndb_mgm*/usr/local/bin 2.修改权限      shell>cd/usr/local/bin      shell>chmod+xndb_m

5、gm* 3.配置文件3.1创建数据节点和mysql节点的my.cnf配置文件shell>vi/etc/my.cnf my.cnf内容如下：[mysqld]#Optionsformysqldprocess:ndbcluster                        #runNDBstorageenginendb-connectstring=192.168.0.10 #locationofmanagementserver[mysql_cluster]#Optionsforndbdprocess:ndb-connectstring=192.168.0.10 #l

6、ocationofmanagementserver 3.2创建管理节点的config.ini配置文件shell>mkdir/var/lib/mysql-clustershell>cd/var/lib/mysql-clustershell>viconfig.ini config.ini内容如下：[ndbddefault]#Optionsaffectingndbdprocessesonalldatanodes:NoOfReplicas=2   #NumberofreplicasDataMemory=80M   #Howmuchmemorytoallocateforda

7、tastorageIndexMemory=18M  #Howmuchmemorytoallocateforindexstorage                 #ForDataMemoryandIndexMemory,wehaveusedthe                 #defaultvalues.Sincethe"world"databasetakesup                 #onlyabout500KB,thisshouldbemorethanenoughfor                 #thisexampleClusters

8、etup.