https://mariadb.com/kb/en/mariadb/galera-cluster-status-variables/
http://www.ywnds.com/?p=6084
http://benjr.tw/95536
http://www.99cloud.net/html/2016/jiuzhouyuanchuang_0316/131.html
SHOW GLOBAL STATUS LIKE ’wsrep_%’;
(1)SHOW GLOBAL STATUS LIKE ’wsrep_cluster_state_uuid’; 集群中每个节点的值必须一致。
(2)SHOW GLOBAL STATUS LIKE ’wsrep_cluster_size’; 显示集群的规模,此例应该显示”2”。
(3)SHOW GLOBAL STATUS LIKE ’wsrep_cluster_status’; 显示”Primary”为正常。
(4)SHOW GLOBAL STATUS LIKE ’wsrep_ready’; 显示”ON”为正常。
(5) SHOW GLOBAL STATUS LIKE ’wsrep_connected’; 显示”ON”为正常。
(6) SHOW GLOBAL STATUS LIKE ’wsrep_local_state_comment’; 显示” Joined”为正常。
http://www.actionsky.com/docs/archives/171
http://www.slideshare.net/yejr/my-sql-20131020?ref=http://imysql.com/2013/11/19/mysql-benchmark-testing.shtml
==========
apt-get install sysbench
建table、records sysbench –debug=on –test=oltp –db-driver=mysql –mysql-table-engine=innodb –oltp-table-size=1000000 –mysql-user=root –mysql-password=oooxxx –mysql-host=10.255.255.215 prepare
測試 sysbench –num-threads=16 –max-requests=100000 –debug=on –test=oltp –db-driver=mysql –mysql-table-engine=innodb –oltp-table-size=1000000 –mysql-user=root –mysql-password=oooxxx –mysql-host=10.255.255.215 run
清掉table、records sysbench –debug=on –test=oltp –db-driver=mysql –mysql-table-engine=innodb –oltp-table-size=1000000 –mysql-user=root –mysql-password=oooxxx –mysql-host=10.255.255.215 cleanup
https://blog.gslin.org/archives/2015/09/13/5971/%E7%94%A8-sysbench-%E6%B8%AC%E8%A9%A6-mysql-%E6%95%88%E8%83%BD/
http://blog.xuite.net/misgarlic/weblogic/56170203-MySQL+benchmark+tool+-+sysbench
http://hugnew.com/?p=737
==========
http://who0168.blog.51cto.com/253401/556300/
[root@localhost bin]# ./sysbench
测试用例:
sysbench [general-options]… –test=[test-options]… command
通用选项:
--num-threads=N 创建测试线程的数目。默认为1.
--max-requests=N 请求的最大数目。默认为10000,0代表不限制。
官方
https://mariadb.com/kb/en/mariadb/installing-mariadb-deb-files/
New Key Add MariaDB to your sources.list sudo apt-get install software-properties-common sudo apt-key adv –recv-keys –keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository ‘deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu trusty main’
sudo apt-get update
sudo apt-get install mariadb-server
.begin install maybe have question about other mariadb toolkit install
If Y -> have one question for root password
If N -> use mysql_secure_installtion for secure
Finish install mariadb.
modify my.cnf /etc/mysql ( find / -name my.
http://severalnines.com/blog/leveraging-aws-tools-speed-management-galera-cluster-amazon-cloud
https://blog.sprinternet.at/2016/03/mariadb-10-1-galera-cluster-on-debian-8-jessie/