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