Ensure Strong Synchronous Replication Is Used

SrednjaNivo 1Automatskatdsql

Opis

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).

Kako se proverava

Metod provere: SQL upit

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

Očekivani izlaz: compliant

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

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

Svojstva

Operativni sistemi: Bilo koji
Oznake: tdsqlreplication
Referenca: CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 10.3 Ensure Strong Synchronous Replication Is Used

Proverite ovaj računar

Pokrenite ovo na računaru za koji imate dozvolu za proveru. Skeniranje radi u režimu samo za čitanje.

shell

tmaegis scan --target tdsql