网站建设 >

查看其它板块

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

如何连接 mysql cluster

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

成都创新互联是一家专注网站建设、网络营销策划、微信小程序开发、电子商务建设、网络推广、移动互联开发、研究、服务为一体的技术型公司。公司成立十载以来，已经为数千家成都混凝土搅拌站各业的企业公司提供互联网服务。现在，服务的数千家客户与我们一路同行，见证我们的成长；未来，我们一起分享成功的喜悦。

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点吸烟 f并添加下面的内容

#ptions for mysqld process:

[mysqld]

ndbcluster # run NDB storage engine