ssh-copy-id  better use root

ssh-copy-id  finish

Reboot clustercontrol server

======sysbench======

[sysbench]

select

sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/select.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-”  –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 prepare

sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/select.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-”  –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 run

Oltp  read/write

* 产生数据
sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-”  –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 prepare

* 执行
sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-”  –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 run

*清除
最後面改成 cleanup