锐客网

  1. 首页 > 睿知 > it技术 > >

mysql怎么连接集群 mysql集群解决方案

IT技术配置

C#怎么连接mysql cluster集群mysql cluster 7.1.3 安装笔记
今天初步安装了一下mysql cluster,基本上都是按照官方文档做的,欢迎大家拍砖 。
1,服务器使用情况
Management (MGMD) node 192.168.0.10
MySQL server (SQL) node192.168.0.20
Data (NDBD) node "A"192.168.0.30
Data (NDBD) node "B"192.168.0.40
2,安装Management、Sql node、 Data node 重复以下步骤:
[root@www local]# tar -zxvf mysql-cluster-gpl-7.1.3-linux-i686-glibc23.tar.gz
[root@www local]# mv mysql-cluster-gpl-7.1.3-linux-i686-glibc23 mysql
[root@www local]# groupadd mysql
[root@www local]# useradd -g mysql mysql
[root@www local]# chown -R mysql.mysql mysql
[root@www local]# /usr/local/mysql/scripts/mysql_install_db--user=mysql
[root@www mysql]# cp support-files/mysql.server /etc/rc.d/init.d/
[root@www mysql]# chmod +x /etc/rc.d/init.d/mysql.server
[root@www mysql]# chkconfig --add mysql.server
3,配置Management节点:
[root@www mysql]# mkdir /var/lib/mysql-cluster
[root@www mysql]# vi /var/lib/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
# TCP/IP options:
[tcp default]
portnumber=2202 # This the default; however, you can use any port that is free
# for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and allow the default value to be used instead
# Management process options:
[ndb_mgmd]
hostname=192.168.0.10# Hostname or IP address of management node
datadir=/var/lib/mysql-cluster# Directory for management node log files
# Options for data node "A":
[ndbd]
# (one [ndbd] section per data node)
hostname=192.168.0.30# Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
# Options for data node "B":
[ndbd]
hostname=192.168.0.40# Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
# SQL node options:
[mysqld]
hostname=192.168.0.20# Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[root@www mysql-cluster]# cp bin/ndb_mgm* /usr/local/bin
4,配置MySQL server (SQL) node:
创建/etc/my.cnf并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster# run NDB storage engine
ndb-connectstring=192.168.0.10# location of management server
# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10# location of management server
5,配置 Data (NDBD) node "A":
创建/etc/my.cnf文件,并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster# run NDB storage engine
ndb-connectstring=192.168.0.10# location of management server
# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10# location of management server
6,配置 Data (NDBD) node "B":
创建/etc/my.cnf文件,并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster# run NDB storage engine
ndb-connectstring=192.168.0.10# location of management server
# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10# location of management server
7,启动Management节点:
[root@www local]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2010-05-05 13:20:19 [MgmtSrvr] INFO-- NDB Cluster Management Server. mysql-5.1.44 ndb-7.1.3

推荐阅读


上一篇：上海无线路由器性能怎么样，上海无线路由器性能怎么样知乎

下一篇：大妈竞技游戏，大妈竞技游戏名字