Note that Vitess will not consider any replicas outside the cell the current primary is in for promotion, therefore you must pass the new_primary flag if you need to promote a replica in a different cell from the primary. In the automated selection mode Vitess will prefer the most advanced replica for promotion, to minimize failover time. 244 Example Flags Name Type Definition avoid_tablet string alias ") are failover agnostic. They automatically resume after either planned promotion (PlannedReparentShard), emergency promotion (EmergencyReparentShard) or completely external reparenting. Once the new

Vitess app server app server app server Master Replica Replica routing Load balancing Master promotion with Orchestrator Growing with Vitess Vitess app server app server app server DB2 Replica

automat- ic promotion of multiple arguments to a common data type (see Section 38.2.5). anycompatiblearray Indicates that a function accepts any array data type, with au- tomatic promotion of multiple automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data type, with au- tomatic promotion of multiple anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5 and Section 8.17). cstring Indicates

auto- matic promotion of multiple arguments to a common data type (see Section 38.2.5). anycompatiblearray Indicates that a function accepts any array data type, with automatic promotion of multiple arguments with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data type, with automatic promotion of multiple anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5 and Section 8.17). cstring Indicates

automat- ic promotion of multiple arguments to a common data type (see Section 37.2.5). anycompatiblearray Indicates that a function accepts any array data type, with auto- matic promotion of multiple au- tomatic promotion of multiple arguments to a common data type (see Section 37.2.5). anycompatiblerange Indicates that a function accepts any range data type, with auto- matic promotion of multiple wait set to true (the default), the function waits until promotion is completed or wait_seconds seconds have passed, and returns true if promotion is successful and false otherwise. If wait is set to false

automat- ic promotion of multiple arguments to a common data type (see Sec- tion 37.2.5). anycompatiblenonarray Indicates that a function accepts any non-array data type, with auto- matic promotion of multiple 5). anycompatiblerange Indicates that a function accepts any range data type, with automat- ic promotion of multiple arguments to a common data type (see Sec- tion 37.2.5 and Section 8.17). cstring Indicates set to true (the default), the func- tion waits until promotion is completed or wait_seconds seconds have passed, and re- turns true if promotion is successful and false otherwise. If wait is set to false

automat- ic promotion of multiple arguments to a common data type (see Section 36.2.5). anycompatiblearray Indicates that a function accepts any array data type, with au- tomatic promotion of multiple automatic promotion of multiple arguments to a com- mon data type (see Section 36.2.5). anycompatiblerange Indicates that a function accepts any range data type, with au- tomatic promotion of multiple anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 36.2.5 and Section 8.17). cstring Indicates

auto- matic promotion of multiple arguments to a common data type (see Section 36.2.5). anycompatiblearray Indicates that a function accepts any array data type, with automatic promotion of multiple arguments with automatic promotion of multiple arguments to a com- mon data type (see Section 36.2.5). anycompatiblerange Indicates that a function accepts any range data type, with automatic promotion of multiple anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 36.2.5 and Section 8.17). cstring Indicates

auto- matic promotion of multiple arguments to a common data type (see Section 38.2.5). anycompatiblearray Indicates that a function accepts any array data type, with automatic promotion of multiple arguments with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data type, with automatic promotion of multiple anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5 and Section 8.17). cstring Indicates

automat- ic promotion of multiple arguments to a common data type (see Section 38.2.5). anycompatiblearray Indicates that a function accepts any array data type, with au- tomatic promotion of multiple anycompatiblenonarray Indicates that a function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). 227 Data Types Name Description Description anycompatiblerange Indicates that a function accepts any range data type, with au- tomatic promotion of multiple arguments to a common data type (see Section 38.2.5 and Section 8.17). anycompatiblemultirange