读写分离

资源操作

ADD RESOURCE write_ds (
HOST=127.0.0.1,
PORT=3306,
DB=ds_0,
USER=root,
PASSWORD=root
),read_ds (
HOST=127.0.0.1,
PORT=3307,
DB=ds_0,
USER=root,
PASSWORD=root
);

规则操作

  • 创建读写分离规则
CREATE READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
TYPE(NAME=random)
);
  • 修改读写分离规则
ALTER READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
TYPE(NAME=random,PROPERTIES(read_weight='2:0'))
);
  • 删除读写分离规则
DROP READWRITE_SPLITTING RULE group_0;
  • 删除数据源
DROP RESOURCE write_ds,read_ds;
  • 删除分布式数据库
DROP DATABASE readwrite_splitting_db;