Non-Essentials Edition) 156 About Pub/Sub 156 Pub/Sub Window 156 Subscribe Channels 157 Channel Colorings 158 Chapter 11 - Data Migration Tools 160 About Data Migration Tools 160 Import temporarily. Resume all channels. 157 Toggle a pane for posting a message to a channel. Create an archive file for the current messages. Mute the channels. All new messages will right-clicking the grid. Message texts in different colors indicate: • Black - Messages sent to a channel • Grey - System messages • Blue - Publish / Received messages • Red - Error messages

Non-Essentials Edition) 161 About Pub/Sub 161 Pub/Sub Window 161 Subscribe Channels 162 Channel Colorings 163 Chapter 11 - Data Migration Tools 164 About Data Migration Tools 164 Import Resume Resume all channels. 162 Publish Pane Toggle a pane for posting a message to a channel. Archive Messages Create an archive file for the current messages. Mute Mute the channels right-clicking the grid. Message texts in different colors indicate: • Black - Messages sent to a channel • Grey - System messages • Blue - Publish / Received messages • Red - Error messages

Non-Essentials Edition) 160 About Pub/Sub 160 Pub/Sub Window 160 Subscribe Channels 161 Channel Colorings 162 Chapter 11 - Data Migration Tools 164 About Data Migration Tools 164 Import 161 Resume Resume all channels. Publish Pane Toggle a pane for posting a message to a channel. Archive Messages Create an archive file for the current messages. Mute Mute the channels right-clicking the grid. Message texts in different colors indicate: • Black - Messages sent to a channel • Grey - System messages • Blue - Publish / Received messages • Red - Error messages

the primary and secondary databases may be inconsistent for a short time. Load balancer policy Channel query requests to different secondary databases through load balancer policy. 8.3.7 Limitations Column Description read Data reading configuration write Data writing configuration stream_channel Data channel Example • Query migration rule SHOW MIGRATION RULE; mysql> SHOW MIGRATION RULE; +--- -----+ | read | write 9.2. ShardingSphere-Proxy 330 Apache ShardingSphere document | stream_channel | +--------------------------------------------------------------+------------------- --------

the primary and secondary databases may be inconsistent for a short time. Load balancer policy Channel query requests to different secondary databases through load balancer policy. 8.3.7 Limitations Column Description read Data reading configuration write Data writing configuration stream_channel Data channel Example • Query migration rule SHOW MIGRATION RULE; mysql> SHOW MIGRATION RULE; +--- -------------------+-------------------------------------------------------+ | read | write | stream_channel | +--------------------------------------------------------------+------------------- --------

ShowMigrationRule ::= 'SHOW' 'MIGRATION' 'RULE' 返回值说明 列 说明 read 数据读取配置 write 数据写入配置 stream_channel 数据通道 示例 • 查询数据迁移规则 SHOW MIGRATION RULE; mysql> SHOW MIGRATION RULE; +---------------------- -------------------+-------------------------------------------------------+ | read | write | stream_channel | +--------------------------------------------------------------+------------------- -------- batchSize ',')? ('SHARDING_SIZE' '=' shardingSize ',')? (rateLimiter)? ')' dataChannel ::= 'STREAM_CHANNEL' '(' 'TYPE' '(' 'NAME' '=' algorithmName ',' propertiesDefinition ')' ')' workerThreadPoolSize

frequently due to the Congest error #11082 – Fix the issue that the Raft connection is broken when the channel is full #11047 – Fix the issue that batch messages are too large in Raft client implementation #9714 pressure is too high. Refer to the solution in TiKV_channel_full_total. 378 7.5.3.2.2 TiKV_channel_full_total • Alert rule: sum(rate(tikv_channel_full_total[10m]))BY (type, instance)> 0 • Description: Raftstore is too high, and it might be stuck already. • Solution: Refer to the solution in TiKV_channel_full_total. 7.5.3.2.6 TiKV_async_request_write_duration_seconds • Alert rule: histogram_quantile(0

ShowMigrationRule ::= 'SHOW' 'MIGRATION' 'RULE' 返回值说明 列 说明 read 数据读取配置 write 数据写入配置 stream_channel 数据通道 9.2. ShardingSphere-Proxy 292 Apache ShardingSphere document 示例 • 查询数据迁移规则 SHOW MIGRATION -------------------+-------------------------------------------------------+ | read | write | stream_channel | +--------------------------------------------------------------+------------------- -------- (rateLimiter)? ')' 9.2. ShardingSphere-Proxy 293 Apache ShardingSphere document dataChannel ::= 'STREAM_CHANNEL' '(' 'TYPE' '(' 'NAME' '=' algorithmName ',' propertiesDefinition ')' ')' workerThreadPoolSize

ShowMigrationRule ::= 'SHOW' 'MIGRATION' 'RULE' 返回值说明 列 说明 read 数据读取配置 write 数据写入配置 stream_channel 数据通道 9.2. ShardingSphere-Proxy 286 Apache ShardingSphere document 示例 • 查询数据迁移规则 SHOW MIGRATION -------------------+-------------------------------------------------------+ | read | write | stream_channel | +--------------------------------------------------------------+------------------- -------- (rateLimiter)? ')' 9.2. ShardingSphere-Proxy 287 Apache ShardingSphere document dataChannel ::= 'STREAM_CHANNEL' '(' 'TYPE' '(' 'NAME' '=' algorithmName ',' propertiesDefinition ')' ')' workerThreadPoolSize

the pressure is too high. Refer to the solution in TiKV_channel_full_total. 7.5.3.2.2 TiKV_channel_full_total • Alert rule: sum(rate(tikv_channel_full_total[10m]))BY (type, instance)> 0 • Description: Raftstore is too high, and it might be stuck already. • Solution: Refer to the solution in TiKV_channel_full_total. 7.5.3.2.6 TiKV_async_request_write_duration_seconds • Alert rule: histogram_quantile(0 write takes a long time. • Solution: 1. Check the pressure on Raftstore. See the solution in TiKV_channel_full_total. 2. Check the pressure on the apply worker thread. 348 7.5.3.2.7 TiKV_coprocessor_request_wait_seconds