Percona-XtraDB-Support-Scripts/mysql-ha.sh at master · toalex77/Percona-XtraDB-Support-Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
#!/bin/bash

. ./mysql-ha.conf.sh

checkDBServers (){
	local DB
	nodesOk=()
	nodesKO=()
	for DB in "${DBNODES[@]}"; do
		/usr/bin/mysqladmin -h "${DB}" ping > /dev/null 2>&1 && nodesOk+=( "${DB}" ) || nodesKO+=( "${DB}" )
	done
}

checkArbServers (){
	local Arb
	arbsOk=()
	arbsKO=()
	for Arb in "${ARBNODES[@]}"; do
		[ "$( /usr/bin/telnet "${Arb}" 4567 2>/dev/null < /dev/null | /usr/bin/wc -l )" -gt 1 ] && arbsOk+=( "${Arb}" ) || arbsKO+=( "${Arb}" )
	done
}

pickRandomDB (){
	pickRandomDB=$(( ( $RANDOM % ${#nodesOk[@]} ) ))
	DBNODE=${nodesOk[${pickRandomDB}]}
}

if [ -n "${addDB}" ]; then
	DBNODES+=( "${addDB[@]}" )
fi

if [ -n "${addARB}" ]; then
	ARBNODES+=( "${addARB[@]}" )
fi

nodesOk=()
arbsOk=()

nodesKO=()
arbsKO=()

DBNODE=

checkDBServers