Oceanbase 扩容TPC-H测试

实现功能：自身集群扩容+租户资源扩容+租户资源扩容tpc-h测试

1.机器准备：

172.20.2.120:2881;172.20.2.121:2881;172.20.2.122:2881;172.20.2.120:3881;172.20.2.121:3881;172.20.2.122:3881

2.使用 OBD 自动化部署集群

1. 安装 OBD 软件（在线）:
   yum install -y yum-utils
   yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo
   yum install -y ob-deploy
2. 编辑配置文件
    vim obce-3zones.yaml

   #  Only need to configure when remote login is required

   user:
      username: admin
   #    password: your password if need
      key_file: /home/admin/.ssh/id_rsa.pub
      port: your ssh port, default 22
   #    timeout: ssh connection timeout (second), default 30
   oceanbase-ce:
     servers:
       - name: z01
         # Please don't use hostname, only IP can be supported
         ip: 172.20.2.120
       - name: z02
         ip: 172.20.2.121
       - name: z03
         ip: 172.20.2.122
     global:
       # Please set devname as the network adaptor's name whose ip is  in the setting of severs.
       # if set severs as "127.0.0.1", please set devname as "lo"
       # if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
       devname: ens192
       cluster_id: 1
       # please set memory limit to a suitable value which is matching resource.
       memory_limit: 21G # The maximum running memory for an observer
       system_memory: 8G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
       stack_size: 512K
       cpu_count: 16
       cache_wash_threshold: 1G
       __min_full_resource_pool_memory: 268435456
       workers_per_cpu_quota: 10
       schema_history_expire_time: 1d
       # The value of net_thread_count had better be same as cpu's core number.
       net_thread_count: 4
       major_freeze_duty_time: Disable
       minor_freeze_times: 10
       enable_separate_sys_clog: 0
       enable_merge_by_turn: FALSE
       #datafile_disk_percentage: 20 # The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.
       datafile_size: 50G
       syslog_level: WARN # System log level. The default value is INFO.
       enable_syslog_wf: false # Print system logs whose levels are higher than WARNING to a separate log file. The default value is true.
       enable_syslog_recycle: true # Enable auto system log recycling or not. The default value is false.
       max_syslog_file_count: 10 # The maximum number of reserved log files before enabling auto recycling. The default value is 0.
       # observer cluster name, consistent with obproxy's cluster_name
       appname: obce-3zones
       root_password: Pwd2022# # root user password, can be empty
       proxyro_password: Pwd2022# # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty
     z01:
       mysql_port: 2881 # External port for OceanBase Database. The default value is 2881.
       rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882.
       #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
       home_path: /home/admin/oceanbase-ce
       # The directory for data storage. The default value is $home_path/store.
       data_dir: /data
       # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
       redo_dir: /redo
       zone: zone1
     z02:
       mysql_port: 2881 # External port for OceanBase Database. The default value is 2881.
       rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882.
       #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
       home_path: /home/admin/oceanbase-ce
       # The directory for data storage. The default value is $home_path/store.
       data_dir: /data
       # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
       redo_dir: /redo
       zone: zone2
     z03:
       mysql_port: 2881 # External port for OceanBase Database. The default value is 2881.
       rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882.
       #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
       home_path: /home/admin/oceanbase-ce
       # The directory for data storage. The default value is $home_path/store.
       data_dir: /data
       # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
       redo_dir: /redo
       zone: zone3
   obproxy:
     servers:
       - 172.20.2.120
       - 172.20.2.121
       - 172.20.2.122
     # Set dependent components for the component.
     # When the associated configurations are not done, OBD will automatically get the these configurations from the dependent components.
     depends:
       - oceanbase-ce
     global:
       listen_port: 2883 # External port. The default value is 2883.
       prometheus_listen_port: 2884 # The Prometheus port. The default value is 2884.
       home_path: /home/admin/obproxy
       # oceanbase root server list
       # format: ip:mysql_port;ip:mysql_port
       rs_list: 172.20.2.120:2881;172.20.2.121:2881;172.20.2.122:2881
       enable_cluster_checkout: false
       # observer cluster name, consistent with oceanbase-ce's appname
       cluster_name: obce-3zones
       obproxy_sys_password: Pwd2022# # obproxy sys user password, can be empty
       observer_sys_password: Pwd2022# # p