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

繼續閱讀

sysbench mariaDB

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代表不限制。

繼續閱讀

mariadb ubuntu 16.4

官方 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.

繼續閱讀

作者的圖片

Sue boy

Sueboy Can support You

CIO

Taiwan