1F-1F-1F 三节点分布在三个地域的 OceanBase 集群创建多副本业务租户时失败的原因和解决方法

MySQL [oceanbase]> create resource unit unit1 min_cpu=3, max_cpu=3, memory_size='12g';
Query OK, 0 rows affected (0.005 sec)

MySQL [oceanbase]> create resource pool pool1 unit = 'unit1', unit_num = 1, zone_list = ('zone1', 'zone2', 'zone3');
Query OK, 0 rows affected (0.016 sec)

MySQL [oceanbase]> create tenant mysqlt resource_pool_list = ('pool1'), primary_zone = 'RANDOM' set ob_tcp_invited_nodes = '%', ob_compatibility_mode = 'mysql', recyclebin = off;
ERROR 1235 (0A000): tenant primary zone span regions not supported
MySQL [oceanbase]>
MySQL [oceanbase]> create tenant mysqlt resource_pool_list = ('pool1'), primary_zone = 'zone1,zone2' set ob_tcp_invited_nodes = '%', ob_compatibility_mode = 'mysql', recyclebin = off;
ERROR 1235 (0A000): tenant primary zone span regions not supported
MySQL [oceanbase]>
MySQL [oceanbase]> create tenant mysqlt resource_pool_list = ('pool1'), primary_zone = 'zone1,zone2,zone3' set ob_tcp_invited_nodes = '%', ob_compatibility_mode = 'mysql', recyclebin = off;
ERROR 1235 (0A000): tenant primary zone span regions not supported

MySQL [oceanbase]> create resource unit unit1 min_cpu=3, max_cpu=3, memory_size='12g';
Query OK, 0 rows affected (0.005 sec)

MySQL [oceanbase]> create resource pool pool1 unit = 'unit1', unit_num = 1, zone_list = ('zone1', 'zone2', 'zone3');
Query OK, 0 rows affected (0.016 sec)

MySQL [oceanbase]> create tenant mysqlt resource_pool_list = ('pool1'), primary_zone = 'zone1' set ob_tcp_invited_nodes = '%', ob_compatibility_mode = 'mysql', recyclebin = off;
ERROR 4179 (HY000): primary zone F type replica not enough in its region not allowed
MySQL [oceanbase]>
MySQL [oceanbase]> create tenant mysqlt resource_pool_list = ('pool1'), primary_zone = 'zone1;zone2,zone3' set ob_tcp_invited_nodes = '%', ob_compatibility_mode = 'mysql', recyclebin = off;
ERROR 4179 (HY000): primary zone F type replica not enough in its region not allowed