Sign InTry Free

ALTER PLACEMENT POLICY

ALTER PLACEMENT POLICY is used to modify existing placement policies that have previously been created. All the tables and partitions which use the placement policy will automatically be updated.

Synopsis

AlterPolicyStmt
ALTERPLACEMENTPOLICYIfExistsPolicyNamePlacementOptionList
PolicyName
Identifier
PlacementOptionList
DirectPlacementOptionPlacementOptionListDirectPlacementOptionPlacementOptionList,DirectPlacementOption
DirectPlacementOption
PRIMARY_REGIONEqOptstringLitREGIONSEqOptstringLitFOLLOWERSEqOptLengthNumVOTERSEqOptLengthNumLEARNERSEqOptLengthNumSCHEDULEEqOptstringLitCONSTRAINTSEqOptstringLitLEADER_CONSTRAINTSEqOptstringLitFOLLOWER_CONSTRAINTSEqOptstringLitVOTER_CONSTRAINTSEqOptstringLitLEARNER_CONSTRAINTSEqOptstringLit

Examples

CREATE PLACEMENT POLICY p1 PRIMARY_REGION="us-east-1" REGIONS="us-east-1,us-west-1"; ALTER PLACEMENT POLICY p1 PRIMARY_REGION="us-east-1" REGIONS="us-east-1,us-west-1,us-west-2" FOLLOWERS=4; SHOW CREATE PLACEMENT POLICY p1\G
Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.10 sec) *************************** 1. row *************************** Policy: p1 Create Policy: CREATE PLACEMENT POLICY `p1` PRIMARY_REGION="us-east-1" REGIONS="us-east-1,us-west-1,us-west-2" FOLLOWERS=4 1 row in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.