#!/bin/env bash
#tidb_standby_schema.sh
#灾备库 schema 与主库是否一致
#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(SCHEMA_NAME order by SCHEMA_NAME separator ',') from INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME not in ('INFORMATION_SCHEMA','METRICS_SCHEMA','PERFORMANCE_SCHEMA','mysql','tidb_binlog')"
_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一致"
echo "kv:${_local_schema:0:30}"
if [ "${_local_schema}" = "${_remote_schema}" ]
then
    echo "kv:0"
else
    echo "kv:1"
fi