在centos6.x上
yum install sysbench |
的时候因为sysbench会依赖于mysql，而不管是系统自带的原生的mysql-server，还是mysql分支percona-server，都会跟我们装的percona-xtradb-cluster冲突，所以，幸好我找了第四台机器来安装sysbench，具体测试步骤如下：
首先，登录percona xtradb cluster的其中一台机器，这里登node1(10.0.0.1)，执行mysql登入系统，并创建测试用数据库sbtest并赋予权限给用户sbtest(密码是sbtest)
yum install sysbench |
然后，登录第四台机器(ip是10.0.0.4)，安装sysbench并跑测试程序。
yum-yinstall sysbenchsysbench --test=oltp --mysql-host=10.0.0.1,10.0.0.2,10.0.0.3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql preparesysbench --test=oltp --mysql-host=10.0.0.1,10.0.0.2,10.0.0.3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql run
这是最后输出的结果：
sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options:Number of threads: 1 Doing OLTP test.Running mixed OLTP testUsing Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)Using "BEGIN" for starting transactionsUsing auto_inc on the id columnMaximum number of requests for OLTP test is limited to 10000Threads started! Done. OLTP test statistics: queries performed: read: 140000 write: 50000 other: 20000 total: 210000 transactions: 10000 (21.26 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 190000 (403.93 per sec.) other operations: 20000 (42.52 per sec.) Test execution summary: total time: 470.3826s total number of events: 10000 total time taken by event execution: 470.2785 per-request statistics: min: 27.22ms avg: 47.03ms max: 458.16ms approx. 95 percentile: 99.91ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 470.2785/0.00
最后，清除测试数据：
sysbench --test=oltp --mysql-host=10.0.0.1,10.0.0.2,10.0.0.3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql cleanup