TMAegis
tdsql 관련 규칙 더 보기

TMA-TDSQL-11.4

Ensure Cross-Shard Operations Are Appropriately Controlled

낮음레벨 2수동 검토tdsql

설명

tdsql_trx_cross_shard_op_whitelist controls the types of cross-shard operations allowed within a distributed transaction.

점검 방법

감사 방식: 수동 검토

이 권장 사항은 자동으로 점검할 수 없습니다. --include-manual 옵션을 전달하면 스캔 결과에 이 지침과 함께 표시됩니다.

On the SQLEngine run SHOW VARIABLES LIKE 'tdsql_trx_cross_shard_op_whitelist'; If the business does not require cross-shard writes the value must be READ; the default READ,WRITE is acceptable only where cross-shard writes are a documented requirement.

조치 방법

조치 방식: 가이드 또는 인프라 패치

Configure the allowed operation types according to business needs, minimizing cross- shard write operations: If the business does not require cross-shard writes, set it to READ. If cross-shard writes are required, keep the default READ,WRITE.

속성

운영 체제
모두
태그
tdsqltransactions
참고 자료
CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 11.4 Ensure Cross-Shard Operations Are Appropriately Controlled