## Only need to configure when remote login is required user: username: admin password: 000000 # key_file: your ssh-key file path if need # port: your ssh port, default 22 # timeout: ssh connection timeout (second), default 30 oceanbase-ce: servers: - name: server1 # Please don't use hostname, only IP can be supported ip: 192.1.1.1 - name: server2 ip: 192.1.1.2 - name: server3 ip: 192.1.1.3 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: ens3 cluster_id: 1 # please set memory limit to a suitable value which is matching resource. memory_limit: 15G # The maximum running memory for an observer system_memory: 4G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G. stack_size: 512K cpu_count: 12 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: 15 # 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. clog_disk_utilization_threshold: 30 syslog_level: ERROR # System log level. The default value is INFO. WARN ERROR 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: dbg1 root_password: Nlp@123456 # proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty server1: 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: /home/admin/oceanbase-ce # The directory for data storage. The default value is /store. data_dir: /home/admin/data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /home/admin/redo zone: zone1 server2: 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: /home/admin/oceanbase-ce # The directory for data storage. The default value is /store. data_dir: /home/admin/data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /home/admin/redo zone: zone1 server3: 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: /home/admin/oceanbase-ce # The directory for data storage. The default value is /store. data_dir: /home/admin/data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /home/admin/redo zone: zone1 # 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.1.1.1 # - 192.1.1.2 # - 192.1.1.3 # 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. When a depends exists, OBD gets this value from the oceanbase-ce of the depends. # rs_list: 192.1.1.1:2881;192.1.1.2:2881;192.1.1.3:2881 # enable_cluster_checkout: true # # 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: dbg1 # 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.