OceanBase集群扩容

您所在的位置：网站首页 › 医学检验资格证在哪里报名 › OceanBase集群扩容

OceanBase集群扩容

2024-06-26 17:13:34| 来源: 网络整理| 查看: 265

OceanBase集群扩容连接sys租户

使用root用户连接sys租户的oceanbase数据库

[admin]# mysql -h192.168.1.71 -P2883 -D oceanbase -uroot@sys -pOceanbase2881 -A 添加zone

查看zone信息，当前OceanBase集群有2个zone

添加zone3

mysql> alter system add zone zone3; Query OK, 0 rows affected (0.25 sec)

查看zone信息，看到新增的zone3状态为INACTIVE

启动zone3

mysql> alter system start zone zone3; Query OK, 0 rows affected (0.16 sec)

查看zone信息，看到新增的zone3状态由INACTIVE转为ACTIVE

查看节点信息，当前OceanBase集群共有2个节点

mysql> select * from oceanbase.dba_ob_servers; +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+ | SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+ | 192.168.1.71 | 2882 | 1 | zone1 | 2881 | NO | ACTIVE | 2023-05-06 15:14:10.951435 | NULL | NULL | 2023-04-24 18:32:52.606554 | 2023-05-08 15:15:29.356373 | 4.0.0.0_100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be(Nov 1 2022 14:57:18) | | 192.168.1.72 | 2882 | 2 | zone2 | 2881 | YES | ACTIVE | 2023-05-06 15:07:46.780470 | NULL | NULL | 2023-04-24 18:32:52.245134 | 2023-05-08 15:15:29.300873 | 4.0.0.0_100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be(Nov 1 2022 14:57:18) | +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+

添加节点192.168.1.73（添加节点前部署observer服务）

mysql> alter system add server '192.168.1.73:2882' zone 'zone3'; Query OK, 0 rows affected (0.42 sec)

查看节点信息，当前OceanBase集群此时有3个节点

mysql> select * from oceanbase.dba_ob_servers; +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+ | SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+ | 192.168.1.71 | 2882 | 1 | zone1 | 2881 | NO | ACTIVE | 2023-05-06 15:14:10.951435 | NULL | NULL | 2023-04-24 18:32:52.606554 | 2023-05-08 15:15:29.356373 | 4.0.0.0_100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be(Nov 1 2022 14:57:18) | | 192.168.1.72 | 2882 | 2 | zone2 | 2881 | YES | ACTIVE | 2023-05-06 15:07:46.780470 | NULL | NULL | 2023-04-24 18:32:52.245134 | 2023-05-08 15:15:29.300873 | 4.0.0.0_100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be(Nov 1 2022 14:57:18) | | 192.168.1.73 | 2882 | 4 | zone3 | 2881 | NO | ACTIVE | 2023-05-08 18:08:33.287859 | NULL | NULL | 2023-05-08 18:08:26.713833 | 2023-05-08 18:08:35.230382 | 4.0.0.0_100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be(Nov 1 2022 14:57:18) | +--------------+----------+----+-------+----------+-----------------+--------+----------------------------+-----------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+ 集群扩容

查看资源池信息

mysql> select * from oceanbase.DBA_OB_RESOURCE_POOLS; +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------+--------------+ | RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE | +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------+--------------+ | 1 | sys_pool | 1 | 2023-04-24 18:33:06.599543 | 2023-05-08 14:33:25.095753 | 1 | 1 | zone1;zone2 | FULL | | 1007 | my_pool | 1004 | 2023-04-25 15:43:45.381999 | 2023-05-08 14:33:32.524411 | 1 | 1003 | zone1;zone2 | FULL | +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------+--------------+

sys、my_tenant资源池ZONE_LIST新增zone3

mysql> alter resource pool sys_pool ZONE_LIST=('zone1','zone2','zone3'); Query OK, 0 rows affected (0.83 sec) mysql> alter resource pool my_pool ZONE_LIST=('zone1','zone2','zone3'); Query OK, 0 rows affected (8.37 sec)

查看资源池信息

mysql> select * from oceanbase.DBA_OB_RESOURCE_POOLS; +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+ | RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE | +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+ | 1 | sys_pool | 1 | 2023-04-24 18:33:06.599543 | 2023-05-08 18:13:57.287837 | 1 | 1 | zone1;zone2;zone3 | FULL | | 1007 | my_pool | 1004 | 2023-04-25 15:43:45.381999 | 2023-05-08 18:14:21.769913 | 1 | 1003 | zone1;zone2;zone3 | FULL | +------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-------------------+--------------+ 租户增加副本

查看租户信息

mysql> select * from oceanbase.DBA_OB_TENANTS; +-----------+-------------+-------------+----------------------------+----------------------------+--------------+------------------------------+-------------------+--------------------+--------+---------------+--------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | +-----------+-------------+-------------+----------------------------+----------------------------+--------------+------------------------------+-------------------+--------------------+--------+---------------+--------+ | 1 | sys | SYS | 2023-04-24 18:33:06.821930 | 2023-05-08 14:25:57.800492 | RANDOM | FULL{1}@zone1, FULL{1}@zone2 | NULL | MYSQL | NORMAL | NO | NO | | 1003 | META$1004 | META | 2023-04-25 16:54:07.990306 | 2023-05-08 14:26:30.706161 | RANDOM | FULL{1}@zone1, FULL{1}@zone2 | NULL | MYSQL | NORMAL | NO | NO | | 1004 | my_tenant | USER | 2023-04-25 16:54:07.991849 | 2023-05-08 14:26:30.706161 | RANDOM | FULL{1}@zone1, FULL{1}@zone2 | NULL | MYSQL | NORMAL | NO | NO | +-----------+-------------+-------------+----------------------------+----------------------------+--------------+------------------------------+-------------------+--------------------+--------+---------------+--------+

sys、my_tenant租户LOCALITY新增zone3

mysql> alter tenant sys LOCALITY='FULL{1}@zone1,FULL{1}@zone2,FULL{1}@zone3'; Query OK, 0 rows affected (2.31 sec) mysql> alter tenant my_tenant LOCALITY='FULL{1}@zone1,FULL{1}@zone2,FULL{1}@zone3'; Query OK, 0 rows affected (1.52 sec)

查看租户信息

mysql> select * from oceanbase.DBA_OB_TENANTS; +-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+------------------------------+--------------------+--------+---------------+--------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | +-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+------------------------------+--------------------+--------+---------------+--------+ | 1 | sys | SYS | 2023-04-24 18:33:06.821930 | 2023-05-08 18:17:13.418669 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | FULL{1}@zone1, FULL{1}@zone2 | MYSQL | NORMAL | NO | NO | | 1003 | META$1004 | META | 2023-04-25 16:54:07.990306 | 2023-05-08 18:17:22.787336 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | FULL{1}@zone1, FULL{1}@zone2 | MYSQL | NORMAL | NO | NO | | 1004 | my_tenant | USER | 2023-04-25 16:54:07.991849 | 2023-05-08 18:17:22.787336 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | FULL{1}@zone1, FULL{1}@zone2 | MYSQL | NORMAL | NO | NO | +-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+------------------------------+--------------------+--------+---------------+--------+

添加zone参考：https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001687938添加节点参考：https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001697238

作者：高&玉，博客园链接：https://www.cnblogs.com/haha029/p/17384082.html

【本文地址】

公司简介

联系我们

今日新闻

点击排行

实验室常用的仪器、试剂和: 说到实验室常用到的东西，主要就分为仪器、试剂和耗

不用再找了，全球10大实验: 01、赛默飞世尔科技（热电）Thermo Fisher Scientif

三代水柜的量产巅峰T-72坦: 作者：寞寒最近，西边闹腾挺大，本来小寞以为忙完这

通风柜跟实验室通风系统有: 说到通风柜跟实验室通风，不少人都纠结二者到底是不

集消毒杀菌、烘干收纳为一: 厨房是家里细菌较多的地方，潮湿的环境、没有完全密

实验室设备之全钢实验台如: 全钢实验台是实验室家具中较为重要的家具之一，很多

图片新闻

实验室药品柜的特性有哪些: 实验室药品柜是实验室家具的重要组成部分之一，主要

小学科学实验中有哪些教学: 计算机计算器一般打孔器打气筒仪器车显微镜

实验室各种仪器原理动图讲: 1.紫外分光光谱UV分析原理：吸收紫外光能量，引起分

高中化学常见仪器及实验装: 1、可加热仪器：2、计量仪器：（1）仪器A的名称：量

微生物操作主要设备和器具: 今天盘点一下微生物操作主要设备和器具，别嫌我啰嗦

浅谈通风柜使用基本常识: 　众所周知，通风柜功能中最主要的就是排气功能。在

OceanBase集群扩容

OceanBase集群扩容

今日新闻

点击排行

推荐新闻

图片新闻

专题文章