小试牛刀mysql_cluser学习（一）---集群安装

814635331 · 发表于 2012-4-28 13:23

zhangshengdong 发表于 2012-4-28 13:06
linux服务器，相互能连通吗？

[ndbd default]
NoOfReplicas=2

[ndb_mgmd]
NodeId=1
HostName=10.10.10.12
Datadir=/var/lib/mysql-cluster

[ndbd]
NodeId=2
HostName=10.10.10.10
datadir=/usr/local/mysql/data/

[ndbd]
NodeId=3
HostName=10.10.10.14
datadir=/usr/local/mysql/data/

[mysqld]
NodeId=4
HostName=10.10.10.14

这是我管理节点的配置文件

zhangshengdong · 发表于 2012-4-28 13:33

ndbd和mysql结点的配置文件呢？也要配置，如下配置
Configuring the data nodes and SQL nodes
(数据结点和sql结点的配置操作)

shell> vi /etc/my.cnf

[mysqld]

# Options for mysqld process:

ndbcluster                   # run NDB storage engine

ndb-connectstring=192.168.1.10  # location of management server

[mysql_cluster]

# Options for ndbd process:

ndb-connectstring=192.168.1.10  # location of management server

zhangshengdong · 发表于 2012-4-28 13:35

每个都要配置my.cnf

zhangshengdong · 发表于 2012-4-28 13:35

814635331 发表于 2012-4-28 13:23
[ndbd default]
NoOfReplicas=2

ndbd和mysql结点的配置文件呢？也要配置，如下配置
Configuring the data nodes and SQL nodes
(数据结点和sql结点的配置操作)

shell> vi /etc/my.cnf

[mysqld]

# Options for mysqld process:

ndbcluster                   # run NDB storage engine

ndb-connectstring=192.168.1.10  # location of management server

[mysql_cluster]

# Options for ndbd process:

ndb-connectstring=192.168.1.10  # location of management server

814635331 · 发表于 2012-4-28 14:12

zhangshengdong 发表于 2012-4-28 13:33
ndbd和mysql结点的配置文件呢？也要配置，如下配置
Configuring the data nodes and SQL nodes
(数据结点 ...

我是这样配置的没效果

[root@mysql-ndb1 bin]# vi /etc/my.cnf

[mysqld]
# Options for mysqld process:

ndbcluster # run NDB storage engine

ndb-connectstring=10.10.10.12 # location of management server

[mysql_cluster]

# Options for ndbd process:

ndb-connectstring=10.10.10.12 # location of management server

~

mchdba · 发表于 2012-5-1 21:18

我也安装完了mysql cluster，但是集群安装完毕之后，如何测试性能呢？怎么测试呢？

mchdba · 发表于 2012-5-1 23:25

[root@banggo ~]# mysqlslap --defaults-file=/etc/my.cnf  --concurrency=500 --iterations=1 --number-int-cols=4 --number-char-cols=35 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --engine=ndbcluster --number-of-queries=2000 --debug-info
Benchmark
      Running for engine ndbcluster
      Average number of seconds to run all queries: 4.609 seconds
      Minimum number of seconds to run all queries: 4.609 seconds
      Maximum number of seconds to run all queries: 4.609 seconds
      Number of clients running queries: 500
      Average number of queries per client: 4

User time 0.04, System time 0.07
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 3865, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 5991, Involuntary context switches 2132