OB社区版（单服务器3副本）搭建手册

oceanbase-ce:

  servers:

    - name: obce01

      # Please don't use hostname, only IP can be supported

      ip: 10.251.19.65

    - name: obce02

      ip: 10.251.19.65

    - name: obce03

      ip: 10.251.19.65

  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: 2

    # please set memory limit to a suitable value which is matching resource.

    memory_limit: 8G # The maximum running memory for an observer

    system_memory: 3G # 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: 3 # 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: 10G

    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: 0EI5N08d # root user password, can be empty

    proxyro_password: uY7Yf8zx # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty

  obce01:

    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-ce1

    # The directory for data storage. The default value is $home_path/store.

    data_dir: /data1

    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.

    redo_dir: /redo1

    zone: zone1

  obce02:

    mysql_port: 3881 # External port for OceanBase Database. The default value is 2881.

    rpc_port: 3882 # 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-ce2

    # The directory for data storage. The default value is $home_path/store.

    data_dir: /data2

    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.

    redo_dir: /redo2

    zone: zone2

  obce03:

    mysql_port: 4881 # External port for OceanBase Database. The default value is 2881.

    rpc_port: 4882 # 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-ce3

    # The directory for data storage. The default value is $home_path/store.

    data_dir: /data3

    # The directory for clog, ilog, and slog. The default value is the same as the data_dir value.

    redo_dir: /redo3

    zone: zone3

obproxy:

  servers:

    - 10.251.19.65

  # 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: 10.251.19.65:2881;10.251.19.65:3881;10.251.19.65:4881

    enable_cluster_checkout: false

    # observer cluster name, consistent with oceanbase-ce's appname

    cluster_name: obce-3zones

    obproxy_sys_password: 0MdTv1tm # obproxy sys user password, can be empty

    observer_sys_password: uY7Yf8zx # proxyro user pasword, consistent with oceanbase-ce's proxyro_password, can be empty