Readwrite_splitting
Resource Operation
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"
);
Rule Operation
- Create readwrite_splitting rule
CREATE READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
TYPE(NAME="random")
);
- Alter readwrite_splitting rule
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
DROP READWRITE_SPLITTING RULE group_0;
- Drop resource
DROP RESOURCE write_ds,read_ds;
- Drop distributed database
DROP DATABASE readwrite_splitting_db;
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .