OceanBase集群安装

环境

Centos 7.6 + OB 4.2.1

角色 IP 配置 备注

OBD/OBClient 192.168.18.11 8G+100G 中控机+客户端

OBServer/OBProxy 192.168.18.166 2G+30G 节点1

OBServer/OBProxy 192.168.18.167 2G+30G 节点2

OBServer/OBProxy 192.168.18.168 2G+30G 节点3

1.创建用户（192.168.18.11/166/167/168）

useradd admin

passwd admin

2.创建目录（192.168.18.166/167/168）

mkdir -p /obdata/{observer,data,redo}

chown -R admin:admin /obdata

3.关闭防火墙、关闭selinux（192.168.18.11/166/167/168）

4.安装all in包

下载地址：https://www.oceanbase.com/softwarecenter

tar -xzf oceanbase-all-in-one-*.tar.gz

cd oceanbase-all-in-one/bin/

./install.sh

source ~/oceanbase-all-in-one/bin/env.sh

5.OBD配置

#禁用远程仓库

obd mirror disable remote

#将安装包添加至本地镜像库

obd mirror clone *.rpm

obd mirror list local

#配置文件

# 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: node1
      # Please don't use hostname, only IP can be supported
      ip: 192.168.18.166
    - name: node2
      ip: 192.168.18.167
    - name: node3
      ip: 192.168.18.168
  global:
    # Starting from observer version 4.2, the network selection for the observer is based on the 'local_ip' parameter, and the 'devname' parameter is no longer mandatory.
    # If the 'local_ip' parameter is set, the observer will first use this parameter for the configuration, regardless of the 'devname' parameter.
    # If only the 'devname' parameter is set, the observer will use the 'devname' parameter for the configuration.
    # If neither the 'devname' nor the 'local_ip' parameters are set, the 'local_ip' parameter will be automatically assigned the IP address configured above.
    devname: enp0s3
    cluster_id: 2
    # please set memory limit to a suitable value which is matching resource. 
    memory_limit: 1G # The maximum running memory for an observer
    system_memory: 128M # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
    datafile_size: 128M # Size of the data file. 
    datafile_next: 16M # the auto extend step. Please enter an capacity, such as 2G
    datafile_maxsize: 1G # the auto extend max size. Please enter an capacity, such as 20G
    log_disk_size: 1G # The size of disk space used by the clog files.
    cpu_count: 1
    production_mode: false
    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: 4 # 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: obcluster
    # root_password: # root user password, can be empty
    # proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty
  node1:
    mysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
    rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /obdata/observer
    # The directory for data storage. The default value is $home_path/store.
    data_dir: /obdata/data
    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
    redo_dir: /obdata/redo
    zone: zone1
  node2:
    mysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
    rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /obdata/observer
    # The directory for data storage. The default value is $home_path/store.
    data_dir: /obdata/data
    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
    redo_dir: /obdata/redo
    zone: zone2
  node3:
    mysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
    rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /obdata/observer
    # The directory for data storage. The default value is $home_path/store.
    data_dir: /obdata/data
    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
    redo_dir: /obdata/redo
    zone: zone3
obproxy-ce:

  # 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
     servers:
        - 192.168.18.11
          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: /u01/app/ob/obproxy

    # oceanbase root server list

    # format: ip:mysql_port;ip:mysql_port. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.

    # rs_list: 192.168.1.2:2881;192.168.1.3:2881;192.168.1.4:2881

​    enable_cluster_checkout: false

    # observer cluster name, consistent with oceanbase-ce's appname. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.

    # cluster_name: obcluster

​    skip_proxy_sys_private_check: true
​    enable_strict_kernel_release: false

    # obproxy_sys_password: # obproxy sys user password, can be empty. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.

    # observer_sys_password: # proxyro user pasword, consistent with oceanbase-ce's proxyro_password, can be empty. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.

6. 部署OBD

   #部署OceanBase集群

   obd cluster deploy obce-3zones -c obce-3zones.yaml

7. 操作系统配置

   #配置内核

   vi  /etc/sysctl.conf
   net.core.somaxconn = 2048
   net.core.netdev_max_backlog = 10000
   net.core.rmem_default = 16777216
   net.core.wmem_default = 16777216
   net.core.rmem_max = 16777216
   net.core.wmem_max = 16777216
   net.ipv4.ip_local_port_range = 3500 65535
   net.ipv4.ip_forward = 0
   net.ipv4.conf.default.rp_filter = 1
   net.ipv4.conf.default.accept_source_route = 0
   net.ipv4.tcp_syncookies = 0
   net.ipv4.tcp_rmem = 4096 87380 16777216
   net.ipv4.tcp_wmem = 4096 65536 16777216
   net.ipv4.tcp_max_syn_backlog = 16384
   net.ipv4.tcp_fin_timeout = 15
   net.ipv4.tcp_max_syn_backlog = 16384
   net.ipv4.tcp_tw_reuse = 1
   net.ipv4.tcp_tw_recycle = 1
   net.ipv4.tcp_slow_start_after_idle=0
   vm.swappiness = 0
   vm.min_free_kbytes = 2097152
   vm.max_map_count=655360
   fs.aio-max-nr=1048576
   

   #资源限制

   vi /etc/security/limits.conf
   * soft nofile 655360
   * hard nofile 655360
   * soft nproc 655360
   * hard nproc 655360
   * soft core unlimited
   * hard core unlimited
   * soft stack unlimited
   * hard stack unlimited
   # End of file
   
   vi /etc/security/limits.d/20-nproc.conf
   *          soft    nproc     655360
   root       soft    nproc     unlimited
   

obd cluster destroy obtest -c obce-single.yaml

obd cluster deploy obtest -c obce-single.yaml

查看 OBD 管理的集群列表
obd cluster list

查看 obtest 集群状态
obd cluster display obtest

obd cluster start obtest