select * from oceanbase.DBA_OB_TENANTS
SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS;
2、建租户
CREATE RESOURCE UNIT S1_unit_config
MEMORY_SIZE = '1G',
MAX_CPU = 1, MIN_CPU = 1,
LOG_DISK_SIZE = '6G',
MAX_IOPS = 10000, MIN_IOPS = 10000, IOPS_WEIGHT=1;
CREATE RESOURCE POOL mq_pool_01
UNIT='S1_unit_config',
UNIT_NUM=1,
ZONE_LIST=('zone1');
CREATE TENANT IF NOT EXISTS mysql_01
PRIMARY_ZONE='zone1',
RESOURCE_POOL_LIST=('mq_pool_01')
set OB_TCP_INVITED_NODES='%';
3、建用户
SHOW TENANT;
CREATE USER sys_test IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO sys_test WITH GRANT OPTION;
PS :sys租户的用户才可以用来做cdc的鉴权
非sys租户的用户表才能用来做cdc表