--- title: "查看 Locality - OceanBase 数据库 V4.1.0 | OceanBase 文档中心" description: 查看 Locality 本文介绍如何通过视图 DBA_OB_TENANTS 查看租户的副本类型及分布。 关于视图 DBA_OB_TENANTS 的详细介绍，参见 oceanbase.DBA_OB_TENANTS 。 操作步骤 使用 root 用户登录到集群的 sys 租户。 obclient -h172.30.xxx… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.1.0 # 查看 Locality 更新时间：2023-09-27 20:10:52 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.1.0/zh-CN/600.manage/300.replica-management/200.replica-distribution/200.locality-common-operations/100.view-locality.md) 本文介绍如何通过视图 `DBA_OB_TENANTS` 查看租户的副本类型及分布。 关于视图 `DBA_OB_TENANTS` 的详细介绍，参见 [oceanbase.DBA_OB_TENANTS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001700895)。 ## 操作步骤 1. 使用 root 用户登录到集群的 sys 租户。 ```shell obclient -h172.30.xxx.xxx -P2883 -uroot@sys#obdemo -pxxxx -A ``` 2. 进入 `oceanbase` 数据库。 ```shell obclient>use oceanbase; ``` 3. 查询 `oceanbase.DBA_OB_TENANTS`，获取租户的副本类型及分布。 ```shell obclient> SELECT TENANT_ID,TENANT_NAME,TENANT_TYPE,PRIMARY_ZONE,LOCALITY FROM oceanbase.DBA_OB_TENANTS; +-----------+-------------+-------------+----------------------------------------+------------------------------------------------------------------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | PRIMARY_ZONE | LOCALITY | +-----------+-------------+-------------+----------------------------------------+------------------------------------------------------------------+ | 1 | sys | SYS | sa128_obv4_2;sa128_obv4_1,sa128_obv4_3 | FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2, FULL{1}@sa128_obv4_3 | | 1001 | META$1002 | META | sa128_obv4_2;sa128_obv4_1,sa128_obv4_3 | FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2, FULL{1}@sa128_obv4_3 | | 1002 | midas0_3790 | USER | sa128_obv4_2;sa128_obv4_1,sa128_obv4_3 | FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2, FULL{1}@sa128_obv4_3 | | 1003 | META$1004 | META | sa128_obv4_1,sa128_obv4_2 | FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2 | | 1004 | mq_t1 | USER | sa128_obv4_1,sa128_obv4_2 | FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2 | +-----------+-------------+-------------+----------------------------------------+------------------------------------------------------------------+ 5 rows in set ``` #### 说明 此处 LOCALITY 为 `FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2` 仅为示例 ，实际操作中注意添加的 Zone 的数量需要能够满足多数派原则。 `DBA_OB_TENANTS` 表的 `LOCALITY` 字段表示租户的副本类型及分布，Locality 用于描述一个租户的副本包含哪些类型，以及它们在集群中的 Zone 分布情况。 以租户 `mq_t1` 为例，其 `LOCALITY = 'FULL{1}@sa128_obv4_1, FULL{1}@sa128_obv4_2'` 表示在 `sa128_obv4_1,sa128_obv4_2` 各存在一个全能型副本。 ## 相关文档 - [Locality 介绍](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001697243) - [修改 Locality](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001698976) - [增加副本](https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001697416) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线