pcs一些命令删除命令

admin

primitive p_ip_mysql_galera ocf:heartbeat:IPaddr2 \
5 r9 U7 j/ x! P# V! B7 i  params nic="eth1" iflabel="galera" \
    ip="192.168.122.99" cidr_netmask="24"
primitive p_mysql ocf:heartbeat:mysql \
  params config="/etc/mysql/my.cnf" \
    pid="/var/run/mysqld/mysqld.pid" \
( V* r8 w1 Y6 A5 y: y" m! n    socket="/var/run/mysqld/mysqld.sock" \
    binary="/usr/sbin/mysqld" \
  op monitor interval="30s" \
  op start interval="0" timeout="60s" \
  op stop interval="0" timeout="60s"
clone cl_mysql p_mysql \
: R3 M6 N  O1 Y  meta interleave="true"
colocation c_ip_galera_on_mysql \
  inf: p_ip_mysql_galera cl_mysql
property stonith-enabled="false"

admin

http://www.178linux.com/14358

http://www.cnblogs.com/hukey/p/8047187.html

admin

内容正式开始前，我已经在集群中添加了新的节点controller1（IP地址为10.0.0.14）。
# G# N/ ]4 p! y: A

, _" F' ?+ K1 f3 E; K1 |7 T
4 @7 F0 E7 z% ]$ n! z2 ?" C
- L2 E8 a+ h8 v: K在所有节点上安装软件：
# yum install -y mariadb-galera-server xinetd rsync
" \8 j+ h3 O- B' u

6 U$ T# P7 _2 U: `在节点1初始化数据库：
# systemctl start mariadb.service
# mysql_secure_installation
9 Q3 v" g! p3 g. l. D& q4 b9 z5 Q# mysql -u root -p -e "CREATE USER 'clustercheck'@'localhost' IDENTIFIED BY '123456';"
" ^. D1 w# u& E1 z* P( W# a  t# systemctl stop mariadb.service
1 @' j4 o" l) t/ l, M, B6 N" S9 C. k& O) v

在所有节点上配置MariaDB和Galera：
# vi /etc/my.cnf.d/galera.cnf
" f& O# _& y6 Y6 c3 t[mysqld]
' @0 A0 u6 G) ~binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
bind-address=controller1
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name="my_wsrep_cluster"
: E, B3 V  H; P3 R0 l% Uwsrep_cluster_address="gcomm://controller1,controller2,controller3"
wsrep_slave_threads=1
8 n: {* S& K0 ~/ O6 _( G+ W# Hwsrep_certify_nonPK=1
) |+ K7 X8 |  z* o/ G5 V! P& o+ ywsrep_max_ws_rows=131072
' |$ {+ x- N2 t: kwsrep_max_ws_size=1073741824
: c) R) p, W8 y5 z* [wsrep_debug=0
5 t, T: L& i; d$ Dwsrep_convert_LOCK_to_trx=0
* P" m$ U& q+ f! x& l; v$ Kwsrep_retry_autocommit=1
! _. _8 k% n3 P1 J" @, Y  ]wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=rsync
1 |$ C( A) a5 P8 p9 e7 lwsrep_sst_auth=root:
“bind-address=”配置成/etc/hosts中的本机名称。
注意：如果“bind-address=0.0.0.0”，则在本机所有IP的3306端口进行监听，包括VIP。这将导致后续haproxy无法在VIP的3306端口监听。

; j' U0 b; p- I; i
0 D* N: V0 N; p- g- N- J4 D在节点1执行如下命令：
* ]7 e2 q0 T4 i% }; a% U2 Q! e# sudo -u mysql /usr/libexec/mysqld --wsrep-cluster-address='gcomm://' &
需要记住屏幕上的进程id，后面有用。
- |  l: N/ R& ~/ l6 e$ S. i
  ?4 b" S" h6 Z# u0 I- r
; ?' `6 q, u1 \在节点2、节点3：
% d$ e" q$ R) p9 p" d7 Q# systemctl start mariadb.service
# systemctl status -l mariadb.service


在任意节点确认集群的成员数量：
, q+ n0 ?) `: ], i% W# mysql -u root -e 'SELECT VARIABLE_VALUE as "wsrep_cluster_size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"'
( {# |, Y5 r7 M& S) P* r+--------------------+
| wsrep_cluster_size |
9 b  A  v& s& @( n+--------------------+
* y  @8 E. m% V; r| 3 |
+--------------------+
0 Z& ^3 m8 I4 ^7 D$ w2 I

以上状态均正常，重启节点1的服务：
# kill <mysql PIDs>
* y" J& n5 @$ G2 N' q# systemctl start mariadb.service
2 X5 K1 c4 Z* b1 Q- a3 c- x
6 O) L5 G) _' V" S* l

& H( M- ~* L4 e" z
# e: d" x% E" _. g
4 S" {% V/ M6 R2 f: M: N$ c" u5 z6 d. @在所有节点上创建健康检查登录信息文件：
# vi /etc/sysconfig/clustercheck
MYSQL_USERNAME=clustercheck
MYSQL_PASSWORD=123456
4 P. U8 s' [% h0 Q1 w2 @MYSQL_HOST=localhost
! d& M# {3 [1 V! i. hMYSQL_PORT=3306

4 W- x4 m  _1 V* s6 j5 z7 T
2 u0 \% g* \+ M4 ]2 G% v在所有节点上创建供HAProxy调用的健康检查服务：
% X4 A/ {5 p7 K5 `; J, \8 l#vi /etc/xinetd.d/galera-monitor
service galera-monitor
3 c. f; `$ \  K& u5 \{
port = 9200
disable = no
4 g& d8 d- m1 X/ G& ?' gsocket_type = stream
! {5 V/ c0 v9 `8 F6 V* ^protocol = tcp
wait = no
3 ~0 n; ]0 H2 \( S+ b  B* {user = root
group = root
/ \3 T' p6 e# s9 z# ^$ @7 Bgroups = yes
server = /usr/bin/clustercheck
type = UNLISTED
5 ~! I; O4 u4 ]5 P% M: Vper_source = UNLIMITED
log_on_success =
log_on_failure = HOST
flags = REUSE
8 R  Z' S( k- V  g- N5 |}
6 @' A0 R0 U  j3 G' q此处检查状态的端口为9200。


在所有节点上启动xinetd服务，clustercheck需要这个服务：
# systemctl daemon-reload
# systemctl enable xinetd
- d  Z  U8 }$ d# systemctl start xinetd


5 x& ^  a: w: l/ G: B测试检查效果：
# clustercheck
HTTP/1.1 200 OK
0 ^5 }. W0 s1 w8 a3 XContent-Type: text/plain
' u( D/ U2 w9 s6 ^Connection: close
9 T5 G" }  \# X2 ^Content-Length: 32
( E0 E& {! w1 t4 B8 i( l
: N6 a1 t& L: VGalera cluster node is synced.

或：
# telnet 10.0.0.14 9200
Trying 10.0.0.14...
Connected to 10.0.0.14.
Escape character is '^]'.
0 y& B5 A. H8 i& t8 h3 S" ?* a& FHTTP/1.1 200 OK
' }( t& \! ?  V% HContent-Type: text/plain
8 M. j" H1 W1 H: M' GConnection: close
) N' P1 Y4 B; d5 U: o8 xContent-Length: 32
& ~6 W4 q; G; G) Q% y! J; B  r
6 I7 P+ s' L! h6 tGalera cluster node is synced.
+ A; p; H7 ?2 V  t3 t: vConnection closed by foreign host.
; M+ s% O% t/ C


* K( H) D  Q1 V, S' G; L; f, v在所有节点上配置haproxy.cfg：
# vi /etc/haproxy/haproxy.cfg
  X% h( j! p* t& Aglobal
chroot /var/lib/haproxy
daemon
group haproxy
maxconn 4000
pidfile /var/run/haproxy.pid
1 a4 g+ p% J' D1 n4 Huser haproxy

, x  V+ t1 y1 _7 \& @5 D) s6 zdefaults
% x; R$ B1 N& f$ i( U/ Alog global
maxconn 4000
6 T; F8 y* C+ Coption redispatch
retries 3
timeout http-request 10s
timeout queue 1m
timeout connect 10s
timeout client 1m
8 @- J5 d( m  y" ~9 y0 m) }timeout server 1m
- }( |& K7 o0 ?timeout check 10s
8 T4 t: R, F- L- g6 y
listen galera_cluster
bind 10.0.0.10:3306
balance source
option httpchk
server controller1 10.0.0.14:3306 check port 9200 inter 2000 rise 2 fall 5
server controller2 10.0.0.12:3306 check port 9200 inter 2000 rise 2 fall 5
5 [/ s+ J2 ]1 ^server controller3 10.0.0.13:3306 check port 9200 inter 2000 rise 2 fall 5

1 O. F) J$ f8 X, @3 h
# C7 n7 }  c/ ]) o; D查看资源当前在哪个节点：
; L" Y. o# @1 @( h/ d, c+ ]! m9 A# crm_mon
: G: |) E9 T* ]  u

重启资源所在节点的haproxy服务：
2 ?  b: }5 n( r. I# systemctl restart haproxy.service
. B7 j7 r8 b1 [) r' P; O# systemctl status -l haproxy.service