Logo
强制路由

强制路由 #

语句说明示例类型
set readwrite_splitting hint source = [auto / write]针对当前连接,设置读写分离的路由策略(自动路由或强制到写库)set readwrite_splitting hint source = writeRAL
set sharding hint database_value = yy针对当前连接,设置 hint 仅对数据库分片有效,并添加分片值,yy:数据库分片值set sharding hint database_value = 100RAL
add sharding hint database_value xx = yy针对当前连接,为表 xx 添加分片值 yy,xx:逻辑表名称,yy:数据库分片值add sharding hint database_value t_order= 100RAL
add sharding hint table_value xx = yy针对当前连接,为表 xx 添加分片值 yy,xx:逻辑表名称,yy:表分片值add sharding hint table_value t_order = 100RAL
clear hint针对当前连接,清除 hint 所有设置clear hintRAL
clear [sharding hint / readwrite_splitting hint]针对当前连接,清除 sharding 或 readwrite_splitting 的 hint 设置clear readwrite_splitting hintRAL
show [sharding / readwrite_splitting] hint status针对当前连接,查询 sharding 或 readwrite_splitting 的 hint 设置show readwrite_splitting hint statusRAL