怎么连接mysql集群 mysql集群搭建

简述mysql该怎样进行集群部署

mysql集群部署操作如下:

创新互联是一家专注于网站制作、做网站与策划设计,覃塘网站建设哪家好?创新互联做网站,专注于网站建设10余年,网设计领域的专业建站公司;建站业务涵盖:覃塘等地区。覃塘做网站价格咨询:18980820575

1、在MySQL集群中.当table引擎为NDBCLUSTER时才做集群,其他非NDBCLUSTER表和一般MySQL数据库表一样,不会共享数据。NDBCLUSTER表数据存储在Data node服务器内存中,Data Node可以为1台或多台服务器,它们之间存放共享数据。Data Node服务器可以分组数据copy。

例如:2,3,4,5为四台Data Node服务器ID. 2,3为组0; 4,5为组1; 2,3维持数据相同,4,5维持数据相同。 组0和组1维持数据不同。

2、sql node服务器中,非NDBCLUSTER数据存在本身数据库中,table引擎为NDBCLUSTER时,数据存储在Data Node中。当查询NDBCLUSTER表时,它会从Data node集群中提起数据.

3、Manager server管理SQl node和Data node状态。

mysql 群集怎么连接现有的数据库

关闭集群 /usr/local/mysql/bin/ndb_mgm -e shutdown(以我的为例)

lz cd config.ini所在位置(我的是/var/lib/mysql-cluster/ )删除该目录下除config.ini的所有文件

关闭SQL节点所有mysqld服务和mysqld_safe服务(使用kill -9 PID(进程号))

然后按照以下顺序重新启动集群

管理节点-Data节点(id=2-id=3)-SQL节点(id=5-id=4)

C#怎么连接mysql cluster集群

mysql cluster 7.1.3 安装笔记

今天初步安装了一下mysql cluster,基本上都是按照官方文档做的,欢迎大家拍砖。

1,服务器使用情况

Management (MGMD) node 192.168.0.10

MySQL server (SQL) node 192.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

2010-05-05 13:20:19 [MgmtSrvr] INFO -- Loaded config from '/usr/local/mysql/mysql-cluster/ndb_1_config.bin.1'

8,启动 Data (NDBD) node "A"及 Data (NDBD) node "B":

[root@www local]# /usr/local/mysql/bin/ndbd

2010-05-05 13:20:30 [ndbd] INFO -- Configuration fetched from '192.168.0.10:1186', generation: 1

9,启动 MySQL server (SQL) node

[root@www local]# /etc/init.d/mysql.server start

10,所有的节点都已经起动完成了

[root@www local]# ndb_mgm

-- NDB Cluster -- Management Client --

ndb_mgm show

Connected to Management Server at: localhost:1186

Cluster Configuration

---------------------

[ndbd(NDB)] 2 node(s)

id=2 @192.168.0.30 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0, Master)

id=3 @192.168.0.40 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @192.168.0.10 (mysql-5.1.44 ndb-7.1.3)

[mysqld(API)] 1 node(s)

id=4 @192.168.0.20 (mysql-5.1.44 ndb-7.1.3)

如何连接 mysql cluster

Driver template :选择要连接数据库类型我用mysql选择MYSQL Connector/J Driver name :所创建连接名字,随便写 Driver classname:com.mysql.jdbc.Driver要Add JARs选择 com.mysql.jdbc.Driver路径显示 使用oracle参考我面式


当前标题:怎么连接mysql集群 mysql集群搭建
文章URL:http://ybzwz.com/article/doeepds.html