obclient(root@test)[test]> select table_name, partition_name, svr_ip, role from oceanbase.dba_ob_table_locations where database_name=‘test’;
±-----------±---------------±------------±---------+
| table_name | partition_name | svr_ip | role |
±-----------±---------------±------------±---------+
| sbtest1 | NULL | 10.13.9.171 | FOLLOWER |
| sbtest1 | NULL | 10.13.9.193 | FOLLOWER |
| sbtest1 | NULL | 10.13.9.189 | LEADER |
| sbtest3 | NULL | 10.13.9.171 | FOLLOWER |
| sbtest3 | NULL | 10.13.9.193 | FOLLOWER |
| sbtest3 | NULL | 10.13.9.189 | FOLLOWER |
| sbtest2 | NULL | 10.13.9.171 | LEADER |
| sbtest2 | NULL | 10.13.9.193 | FOLLOWER |
| sbtest2 | NULL | 10.13.9.189 | FOLLOWER |
±-----------±---------------±------------±---------+
9 rows in set (0.010 sec)
| sbtest1 | CREATE TABLE sbtest1 (
id int(11) NOT NULL AUTO_INCREMENT,
k int(11) NOT NULL DEFAULT ‘0’,
c char(120) NOT NULL DEFAULT ‘’,
pad char(60) NOT NULL DEFAULT ‘’,
PRIMARY KEY (id)
) AUTO_INCREMENT = 1000000 AUTO_INCREMENT_MODE = ‘ORDER’ DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 |
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.008 sec)
obclient(root@test)[test]> show create table sbtest3;
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±--------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sbtest3 | CREATE TABLE sbtest3 (
id int(11) NOT NULL AUTO_INCREMENT,
k int(11) NOT NULL DEFAULT ‘0’,
c char(120) NOT NULL DEFAULT ‘’,
pad char(60) NOT NULL DEFAULT ‘’,
PRIMARY KEY (id)
) AUTO_INCREMENT = 1000000 AUTO_INCREMENT_MODE = ‘ORDER’ DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 |
表查询都是正常的