I think you shouldn't use "SELECT * FROM" in mysql_gr_routing_check.sh

[kakuka4430]

Hello,

http://lefred.be/content/mysql-group-replication-as-ha-solution/

I tried to use your "mysql_gr_routing_check" in my test environment,
but I face on below error at health-check script.

[root@node1 ~]# mysql_gr_routing_check.sh 100 read
/usr/local/bin/mysql_gr_routing_check.sh: line 44: [: too many arguments

I investigated its error, and I found "queue" variable include two values by exec "echo $queue".
queue
0 0

So I think it is because "SELECT * FROM" gets four values while there are three variables(candidate readonly queue) at 37 line in "mysql_gr_routing_check.sh".

echo $(mysql --no-defaults -BN --connect-timeout=10 --host=$MYSQL_HOST --port=$MYSQL_PORT --user="$MYSQL_USERNAME" --password="$MYSQL_PASSWORD" -e 'SELECT * FROM sys.gr_member_routing_candidate_status' 2>/dev/null) | while read candidate readonly queue

In results, I think it should be as below.

echo $(mysql --no-defaults -BN --connect-timeout=10 --host=$MYSQL_HOST --port=$MYSQL_PORT --user="$MYSQL_USERNAME" --password="$MYSQL_PASSWORD" -e 'SELECT viable_candidate, read_only, transactions_to_cert FROM sys.gr_member_routing_candidate_status' 2>/dev/null) | while read candidate readonly queue

Best regard,

[lefred]

There is a gist with the new version for a while already: https://gist.github.com/lefred/153448f7ea0341d6d0daa2738db6fcd8

[Extensioner]

@lefred your 8.0.2 sql's view output 4 cloumn and your mysql_gr_routing_check.sh echo $(mysql --no-defaults -BN --connect-timeout=10 --host=$MYSQL_HOST --port=$MYSQL_PORT --user="$MYSQL_USERNAME" --password="$MYSQL_PASSWORD" -e 'SELECT * FROM sys.gr_member_routing_candidate_status' 2>/dev/null) | while read candidate readonly queue get 3 parameter.
i am append a no used parameter after queue like ' candidate readonly queue loss'
and now it's OK

[lefred]

Thank you for the comment, this is old code (6 years already, time flies). I would definitely recommend to use MySQL InnoDB Cluster that has all integrated.

[Extensioner]

do you have other any advise with use haproxy?