Ensure Strong Synchronous Replication Is Used

中等級 1自動化tdsql

說明

TDSQL's strong synchronous (sqlasyn) mechanism ensures a transaction returns success only after it is confirmed on both the primary and replica nodes, guaranteeing no data loss. Runs the mysql client against the TDSQL data node selected by TDSQL_MYSQL_OPTS (e.g. "-h10.0.0.5 -P4001 -utdsql_audit"); keep the password in ~/.my.cnf or a login path rather than MYSQL_PWD or the command line (see 1.4 and 1.5).

檢查方式

稽核方法: SQL 查詢

sql_query

out=$(mysql ${TDSQL_MYSQL_OPTS:-} -NBe "SHOW GLOBAL VARIABLES LIKE 'sqlasyn'" 2>/dev/null) || exit 1; v=$(printf '%s\n' "$out" | awk -F'\t' '$1 == "sqlasyn" {print toupper($2)}'); case "$v" in ON|1) echo compliant;; *) echo "value '$v'";; esac

預期輸出: compliant

修補方式

修補方法: 操作指南或基礎設施修補檔

SET GLOBAL sqlasyn = ON; through the OSS management platform and persist it in the parameter template.

屬性

作業系統: 不限
標籤: tdsqlreplication
參考資料: CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 10.3 Ensure Strong Synchronous Replication Is Used

檢查此主機

請在您有權稽核的機器上執行此指令。掃描為唯讀操作。

shell

tmaegis scan --target tdsql