https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000355095
表级Locality Zone List必须是租户级Locality Zone List的子集。
但实际实验,不是这样的啊,是文档写错了?
select locality from oceanbase.gv$tenant where tenant_name=‘obmysql’;
±--------------------------------------------------------------------------+
| locality |
±--------------------------------------------------------------------------+
| FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3, FULL{1}@zone4, FULL{1}@zone5
alter table t1 set locality=‘L{1}@zone1,R{1}@zone2,R{1}@zone3,f{1}@zone4,f{1}@zone5’;
select locality from oceanbase.gv$table where tenant_name=‘obmysql’ and table_name=‘t1’;
±-------------------------------------------------------------------------------------+
| locality |
±-------------------------------------------------------------------------------------+
| LOGONLY{1}@zone1, READONLY{1}@zone2, READONLY{1}@zone3, FULL{1}@zone4, FULL{1}@zone5 |