mini-distributed-with-obproxy-example.yaml 2.5 KB
Newer Older
O
oceanbase-admin 已提交
1 2 3 4 5
## Only need to configure when remote login is required
# user:
#   username: your username
#   password: your password if need
#   key_file: your ssh-key file path if need
6 7
#   port: your ssh port, default 22
#   timeout: ssh connection timeout (second), default 30
O
oceanbase-admin 已提交
8 9 10 11
oceanbase-ce:
  servers:
    - name: z1
      # Please don't use hostname, only IP can be supported
R
Rongfeng Fu 已提交
12
      ip: 192.168.1.2
O
oceanbase-admin 已提交
13
    - name: z2
R
Rongfeng Fu 已提交
14
      ip: 192.168.1.3
O
oceanbase-admin 已提交
15
    - name: z3
R
Rongfeng Fu 已提交
16
      ip: 192.168.1.4
O
oceanbase-admin 已提交
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
  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: eth0
    cluster_id: 1
    # please set memory limit to a suitable value which is matching resource. 
    memory_limit: 8G
    system_memory: 4G
    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
39 40 41
    syslog_level: INFO
    enable_syslog_recycle: true
    max_syslog_file_count: 4
R
Rongfeng Fu 已提交
42 43
    # observer cluster name, consistent with obproxy's cluster_name
    appname: ob_cluster
R
Rongfeng Fu 已提交
44 45
    # root_password: # root user password, can be empty
    # proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty
O
oceanbase-admin 已提交
46
  z1:
47
    mysql_port: 2881
O
oceanbase-admin 已提交
48 49 50 51
    rpc_port: 2882
    home_path: /root/observer
    zone: zone1
  z2:
52
    mysql_port: 2881
O
oceanbase-admin 已提交
53 54 55 56
    rpc_port: 2882
    home_path: /root/observer
    zone: zone2
  z3:
57
    mysql_port: 2881
O
oceanbase-admin 已提交
58 59 60 61 62 63 64 65
    rpc_port: 2882
    home_path: /root/observer
    zone: zone3
obproxy:
  servers:
    - 192.168.1.5
  global:
    listen_port: 2883
66
    prometheus_listen_port: 2884
O
oceanbase-admin 已提交
67 68 69
    home_path: /root/obproxy
    # oceanbase root server list
    # format: ip:mysql_port,ip:mysql_port
70 71
    rs_list: 192.168.1.2:2881;192.168.1.3:2881;192.168.1.4:2881
    enable_cluster_checkout: false
R
Rongfeng Fu 已提交
72 73
    # observer cluster name, consistent with oceanbase-ce's appname
    cluster_name: ob_cluster
R
Rongfeng Fu 已提交
74 75
    # obproxy_sys_password: # obproxy sys user password, can be empty
    # observer_sys_password: # proxyro user pasword, consistent with oceanbase-ce's proxyro_password, can be empty