#!/bin/env bash
#tidb_ha_schema.sh
#灾备库 schema 与主库是否一致
#0为正常,1为异常
[ -f ../config/tidb_vars.config ] && source ../config/tidb_vars.config
[ -f ./config/tidb_vars.config ] && source ./config/tidb_vars.config
_userlogin="tidblogin"
_tidbPasswd=$(echo "${PASSWD}="|base64 -d)
_ck_sql="select group_concat(SCHEMA_NAME order by SCHEMA_NAME separator ',') from INFORMATION_SCHEMA.SCHEMATA"
_local_schema=$(mysql --login-path=${_userlogin} -NBe "${_ck_sql}" 2>/dev/null)
_remote_schema=$(mysql -h${STANDBYIP} -P4000 -utimon -p${_tidbPasswd:-123} -NBe "${_ck_sql}" 2>/dev/null)
echo "kv:灾备库schema与主库是否一致"
if [ "${_local_schema}" = "${_remote_schema}" ]
then
    echo "kv:0"
else
    echo "kv:1"
fi