容器化部署的 OceanBase 集群在初始创建时配置的 CPU/Memory 资源较少，导致不能创建规格较大的租户。而容器所在的宿主机服务器可使用的资源还比较多，所以希望利用这些宿主机剩余的资源来为 OceanBase 集群扩容。
适用版本
OceanBase 数据库的各版本
操作步骤
检查服务器可用的资源 CPU/Memory/Disk space。
# lscpu # free -h # df -Th修改 OBServer 容器可以使用的 CPU/Memory 资源限制。
$ docker update --cpu-quota xxx --cpuset-cpus "0-xxx" --memory xxxG observer1登录数据库，检查目前可用的资源 CPU/Memory/Disk space，综合实际情况调整 CPU/Memory/Data_size 参数。
[root@localhost /root]# mysql -h127.0.0.1 -uroot@sys -P2881 -pxxx MySQL [(none)]> show parameters like 'cpu_count'; show parameters like 'memory_limit'; show parameters like 'datafile_dize'; ALTER SYSTEM SET cpu_count = 'xx'; ALTER SYSTEM SET memory_limit='xxG'; ALTER SYSTEM SET datafile_size='xxG';退出数据库，重启 OBServer 容器。
# docker stop observer # docker start observer等待 20 秒左右，重新登录数据库，检查目前可用的资源 CPU/Memory/Data_size。
[root@localhost /root]# mysql -h127.0.0.1 -uroot@sys -P2881 -pxxx MySQL [(none)]> use oceanbase; SELECT svr_ip, svr_port, zone, cpu_total, cpu_assigned, cpu_max_assigned, cpu_total - cpu_max_assigned cpu_free, round(mem_total / 1024 / 1024 / 1024, 1) "mem_total(G)", round(mem_assigned / 1024 / 1024 / 1024, 1) "mem_assigned(G)", round(mem_max_assigned / 1024 / 1024 / 1024, 1) "mem_max_assigned(G)", round((mem_total - mem_max_assigned) / 1024 / 1024 / 1024, 1) "mem_free(G)", round(disk_total / 1024 / 1024 / 1024, 1) "disk_total(G)", round(disk_assigned / 1024 / 1024 / 1024, 1) "disk_assigned(G)", disk_assigned_percent, unit_num FROM __all_virtual_server_stat ORDER BY zone\G
更多信息
一个调整的范例如下。
[root@localhost /root]# mysql -h127.0.0.1 -uroot@sys -P2881 -pxxx
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3221703047
Server version: 5.7.25 OceanBase 3.2.3.3 (r107010022023021010-264a76a4fa7b5ff429149d60ca051391dc4176e9) (Built Feb 10 2023 10:44:53)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> use oceanbase;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [oceanbase]> SELECT
-> svr_ip,
-> svr_port,
-> zone,
-> cpu_total,
-> cpu_assigned,
-> cpu_max_assigned,
-> cpu_total - cpu_max_assigned cpu_free,
-> round(mem_total / 1024 / 1024 / 1024, 1) "mem_total(G)",
-> round(mem_assigned / 1024 / 1024 / 1024, 1) "mem_assigned(G)",
-> round(mem_max_assigned / 1024 / 1024 / 1024, 1) "mem_max_assigned(G)",
-> round((mem_total - mem_max_assigned) / 1024 / 1024 / 1024, 1) "mem_free(G)",
-> round(disk_total / 1024 / 1024 / 1024, 1) "disk_total(G)",
-> round(disk_assigned / 1024 / 1024 / 1024, 1) "disk_assigned(G)",
-> disk_assigned_percent,
-> unit_num
-> FROM
-> __all_virtual_server_stat
-> ORDER BY
-> zone\G
*************************** 1. row ***************************
svr_ip: xx.xx.xx.xx
svr_port: 2882
zone: zone_1
cpu_total: 6
cpu_assigned: 2
cpu_max_assigned: 2
cpu_free: 4
mem_total(G): 7.0
mem_assigned(G): 1.8
mem_max_assigned(G): 2.1
mem_free(G): 4.9
disk_total(G): 100.0
disk_assigned(G): 100.0
disk_assigned_percent: 100
unit_num: 1
1 row in set (0.01 sec)
MySQL [oceanbase]> CREATE RESOURCE UNIT IF NOT EXISTS unit2
-> max_cpu 5,
-> min_cpu 5,
-> max_memory '10G',
-> min_memory '10G',
-> max_session_num 65535,
-> max_iops 1250,
-> min_iops 1250,
-> max_disk_size '120G';
Query OK, 0 rows affected (0.01 sec)
MySQL [oceanbase]> CREATE RESOURCE POOL IF NOT EXISTS pool2
-> unit = 'unit2',
-> unit_num = 1,
-> zone_list =('zone_1');
ERROR 4624 (HY000): machine resource 'zone_1' is not enough to hold a new unit
MySQL [oceanbase]> show parameters like 'cpu_count';
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | cpu_count | NULL | 8 | the number of CPU\'s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
1 row in set (0.01 sec)
MySQL [oceanbase]> show parameters like 'memory_limit';
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | memory_limit | NULL | 15G | the size of the memory reserved for internal use(for testing purpose). Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
1 row in set (0.00 sec)
MySQL [oceanbase]> show parameters like 'datafile_size';
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | datafile_size | NULL | 100G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
1 row in set (0.00 sec)
$ docker update --cpu-quota 1500000 --cpuset-cpus "0-14" --memory 28G observer1
MySQL [oceanbase]> ALTER SYSTEM SET cpu_count = '15';
Query OK, 0 rows affected (0.06 sec)
MySQL [oceanbase]> ALTER SYSTEM SET memory_limit='25G';
Query OK, 0 rows affected (0.04 sec)
MySQL [oceanbase]> ALTER SYSTEM SET datafile_size='150G';
Query OK, 0 rows affected (0.05 sec)
MySQL [oceanbase]> show parameters like 'cpu_count';
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | cpu_count | NULL | 15 | the number of CPU\'s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+-----------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
1 row in set (0.00 sec)
MySQL [oceanbase]> show parameters like 'memory_limit';
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | memory_limit | NULL | 25G | the size of the memory reserved for internal use(for testing purpose). Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+--------------+-----------+-------+-------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
1 row in set (0.00 sec)
MySQL [oceanbase]> show parameters like 'datafile_size';
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
| zone_1 | observer | xx.xx.xx.xx | 2882 | datafile_size | NULL | 150G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+---------------+-----------+-------+-----------------------------------------+---------+---------+---------+-------------------+
1 row in set (0.00 sec)
Aborted
[root@localhost /root]# docker stop observer
observer
[root@localhost /root]# docker start observer
observer
[root@localhost /root]# mysql -h127.0.0.1 -uroot@sys -P2881 -pWElcome12#_
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3221487684
Server version: 5.7.25 OceanBase 3.2.3.3 (r107010022023021010-264a76a4fa7b5ff429149d60ca051391dc4176e9) (Built Feb 10 2023 10:44:53)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> use oceanbase;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [oceanbase]> SELECT
-> svr_ip,
-> svr_port,
-> zone,
-> cpu_total,
-> cpu_assigned,
-> cpu_max_assigned,
-> cpu_total - cpu_max_assigned cpu_free,
-> round(mem_total / 1024 / 1024 / 1024, 1) "mem_total(G)",
-> round(mem_assigned / 1024 / 1024 / 1024, 1) "mem_assigned(G)",
-> round(mem_max_assigned / 1024 / 1024 / 1024, 1) "mem_max_assigned(G)",
-> round((mem_total - mem_max_assigned) / 1024 / 1024 / 1024, 1) "mem_free(G)",
-> round(disk_total / 1024 / 1024 / 1024, 1) "disk_total(G)",
-> round(disk_assigned / 1024 / 1024 / 1024, 1) "disk_assigned(G)",
-> disk_assigned_percent,
-> unit_num
-> FROM
-> __all_virtual_server_stat
-> ORDER BY
-> zone\G
*************************** 1. row ***************************
svr_ip: xx.xx.xx.xx
svr_port: 2882
zone: zone_1
cpu_total: 13
cpu_assigned: 2
cpu_max_assigned: 2
cpu_free: 11
mem_total(G): 17.0
mem_assigned(G): 1.8
mem_max_assigned(G): 2.1
mem_free(G): 14.9
disk_total(G): 150.0
disk_assigned(G): 100.0
disk_assigned_percent: 66
unit_num: 1
1 row in set (0.01 sec)
MySQL [oceanbase]> select * from __all_unit_config;
+----------------------------+----------------------------+----------------+---------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
| gmt_create | gmt_modified | unit_config_id | name | max_cpu | min_cpu | max_memory | min_memory | max_iops | min_iops | max_disk_size | max_session_num |
+----------------------------+----------------------------+----------------+---------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
| 2023-05-26 15:45:51.855135 | 2023-05-26 15:47:10.376729 | 1 | sys_unit_config | 2 | 2 | 2254857830 | 1879048192 | 10000 | 5000 | 107374182400 | 9223372036854775807 |
| 2023-05-26 15:47:15.505955 | 2023-05-26 15:47:15.505955 | 1001 | B_unit_config | 1 | 1 | 6442450944 | 6442450944 | 1250 | 1250 | 128849018880 | 375 |
| 2023-05-26 15:47:15.508045 | 2023-05-26 15:47:15.508045 | 1002 | LogOnlyNormal_unit_config | 1 | 1 | 2147483648 | 2147483648 | 1000 | 1000 | 536870912000 | 300 |
| 2023-05-26 15:47:15.511211 | 2023-05-26 15:47:15.511211 | 1003 | LogOnlySystem_unit_config | 5 | 5 | 37580963840 | 37580963840 | 5000 | 5000 | 536870912000 | 1500 |
| 2023-05-26 15:47:15.513326 | 2023-05-26 15:47:15.513326 | 1004 | S0_unit_config | 2 | 2 | 12884901888 | 12884901888 | 2500 | 2500 | 536870912000 | 750 |
| 2023-05-26 15:47:15.516455 | 2023-05-26 15:47:15.516455 | 1005 | S1_unit_config | 4 | 4 | 25769803776 | 25769803776 | 3000 | 3000 | 536870912000 | 1000 |
| 2023-05-26 15:47:15.518569 | 2023-05-26 15:47:15.518569 | 1006 | S2_unit_config | 6 | 6 | 34359738368 | 34359738368 | 4000 | 4000 | 536870912000 | 1500 |
| 2023-05-26 15:47:15.521700 | 2023-05-26 15:47:15.521700 | 1007 | S3_unit_config | 8 | 8 | 42949672960 | 42949672960 | 5000 | 5000 | 536870912000 | 2000 |
| 2023-05-26 15:47:15.523762 | 2023-05-26 15:47:15.523762 | 1008 | S4_unit_config | 10 | 10 | 53687091200 | 53687091200 | 6000 | 6000 | 536870912000 | 2500 |
| 2023-05-29 16:34:04.176029 | 2023-05-29 16:34:04.176029 | 1009 | unit2 | 5 | 5 | 10737418240 | 10737418240 | 1250 | 1250 | 128849018880 | 65535 |
+----------------------------+----------------------------+----------------+---------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
10 rows in set (0.00 sec)
MySQL [oceanbase]> CREATE RESOURCE POOL IF NOT EXISTS pool2
-> unit = 'unit2',
-> unit_num = 1,
-> zone_list =('zone_1');
Query OK, 0 rows affected (0.02 sec)
MySQL [oceanbase]>
