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;