读写分离

资源操作

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;