#!/bin/env bash
#tidb_standby_user.sh
#灾备库 用户 与主库是否一致
#0为正常,1为异常
TidbHome=$(awk -F: -v un="tidb" '{if($1==un){print $6;exit}}' /etc/passwd 2>/dev/null)
[ -f ${TidbHome}/scripts/normalcheck/config/tidb_vars.config ] && source ${TidbHome}/scripts/normalcheck/config/tidb_vars.config
_userlogin="tidblogin"
_tidbPasswd=$(echo "${PASSWD}="|base64 -d)
_ck_sql="select group_concat(user order by user separator ',') from mysql.user"
_local_user=$(mysql --login-path=${_userlogin} -NBe "${_ck_sql}" 2>/dev/null)
_remote_user=$(mysql -h${STANDBYIP} -P4000 -utimon -p${_tidbPasswd:-123} -NBe "${_ck_sql}" 2>/dev/null)
#echo "kv:主备集群数据库schema一致"
echo "kv:${_local_user:0:30}"
if [ "${_local_user}" = "${_remote_user}" ]
then
    echo "kv:0"
else
    echo "kv:1"
fi