MySQL Cluster 7.3.6集群环境测试报告

MySQL Cluster7.3.6 集群环境测试报告

概要

网络组申请的 linux 虚拟机环境，Red Hat linux 6.3 64 位操作系统，

规划 4 台虚拟主机 每台配置： CPU 4 核，内存 6G,存储 100G

MYSQL CLUSTER 7.3.6 集群社区版目前最新免费版本

基于 NDB 引擎的集群环境数据库。

测试环境

项 数值

6G

CPU

4 核

部署情况 1 台管理节点(10.40.20.147)、

2 台数据节点

(10.40.20.148,10.40.20.149)

、

2 台 sql 节点

(10.40.20.149,10.40.20.150)

网络环境 100M 局域网

测试工具

利用 mysqlslap、sysbench、supersmack

测试用例

1、并发写能力测试

模拟 100 会话、读写 100w 数据占用时间、cpu 等情况。

模拟 100 会话，读写 1000w 数据占用时间、cpu 等情况。

2、并发事务处理能力

模拟 100 会话、读写 100w 数据，每秒事务处理能力。

模拟 1000 会话，读写 1000w 数据，每秒事务处理能力。

3、单线程功能测试

[root@linux150 ~]# mysqlslap -a

Benchmark

Average number of seconds to run all queries: 0.011 seconds

Minimum number of seconds to run all queries: 0.011 seconds

Maximum number of seconds to run all queries: 0.011 seconds

Number of clients running queries: 1

Average number of queries per client: 0

多线程测试：

100 个并发

[root@linux150 ~]# mysqlslap -a -c100

300 个并发

[root@linux150 ~]# mysqlslap -a -c300

Benchmark

Average number of seconds to run all queries: 1.039 seconds

Minimum number of seconds to run all queries: 1.039 seconds

Maximum number of seconds to run all queries: 1.039 seconds

Number of clients running queries: 300

Average number of queries per client: 0

10.40.20.149 节点并发数在 350 左右，估计是存储和 sql 节点公用的缘故。

10.40.20.150 节点的并发数在 400 个左右。

Minimum number of seconds to run all queries: 0.010 seconds

Maximum number of seconds to run all queries: 0.028 seconds

Number of clients running queries: 1

Average number of queries per client: 0

迭代 100 次的平均

[root@linux150 ~]# mysqlslap -a -i 100

Benchmark

Average number of seconds to run all queries: 0.012 seconds

Minimum number of seconds to run all queries: 0.010 seconds

Maximum number of seconds to run all queries: 0.020 seconds

[root@linux150 ~]# mysqlslap --auto-generate-sql-add-autoincrement -a

Benchmark

Average number of seconds to run all queries: 0.012 seconds

Minimum number of seconds to run all queries: 0.012 seconds

Average number of queries per client: 0

Number of clients running queries: 1

Average number of queries per client: 0

索引支持

[root@linux150 ~]# mysqlslap -a --auto-generate-sql-secondary-indexes=3

Benchmark

Average number of seconds to run all queries: 0.011 seconds

Minimum number of seconds to run all queries: 0.011 seconds

Maximum number of seconds to run all queries: 0.011 seconds

Number of clients running queries: 1

Average number of queries per client: 0

[root@linux150 ~]# mysqlslap -a --auto-generate-sql-write-number=1000

Benchmark

Average number of seconds to run all queries: 0.018 seconds

Average number of queries per client: 0

自定义测试库

[root@linux150 ~]# mysqlslap --create-schema='jczl' -q 'select count(*) from

test;'

Benchmark

Average number of seconds to run all queries: 0.002 seconds

Minimum number of seconds to run all queries: 0.002 seconds

Maximum number of seconds to run all queries: 0.002 seconds

Number of clients running queries: 1

Average number of queries per client: 1

Inndb 和 ndb 存储引擎的比较