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.

繼續閱讀

mariadb galera cluster

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”为正常。

繼續閱讀

GALERA CLUSTER

GALERA CLUSTER FOR RANCHER http://www.dockerinfo.net/1771.html https://octoperf.com/blog/2016/11/17/rancher-galera-cluster/ Running a Galera Cluster in Kubernetes https://www.percona.com/live/data-performance-conference-2016/sessions/running-galera-cluster-kubernetes http://severalnines.com/blog/installing-kubernetes-cluster-minions-centos7-manage-pods-services Architecture of deployment on Azure http://withblue.ink/2016/03/09/galera-cluster-mariadb-coreos-and-docker-part-1.html

繼續閱讀

作者的圖片

Sue boy

Sueboy Can support You

CIO

Taiwan