复古 护眼 海天 深邃 暗黑 默认

影子库压测

存储单元操作

REGISTER STORAGE UNIT ds_0 (
    HOST="127.0.0.1",
    PORT=3306,
    DB="ds_0",
    USER="root",
    PASSWORD="root"
),ds_1 (
    HOST="127.0.0.1",
    PORT=3306,
    DB="ds_1",
    USER="root",
    PASSWORD="root"
),ds_2 (
    HOST="127.0.0.1",
    PORT=3306,
    DB="ds_2",
    USER="root",
    PASSWORD="root"
);

规则操作

  • 创建影子库压测规则
CREATE SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_1,
t_order(TYPE(NAME="SQL_HINT"),TYPE(NAME="REGEX_MATCH", PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]'))), 
t_order_item(TYPE(NAME="SQL_HINT")));
  • 修改影子库压测规则
ALTER SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_2,
t_order_item(TYPE(NAME="SQL_HINT")));
  • 删除影子库压测规则
DROP SHADOW RULE group_0;
  • 移除数据源
UNREGISTER STORAGE UNIT ds_0,ds_1,ds_2;
  1. 删除分布式数据库
DROP DATABASE foo_db;