# 示例文件，内存小于16G时要 production_mode: false user: username: admin password: xxxxxxxxxx # key_file: your ssh-key file path if need # port: your ssh port, default 22 # timeout: ssh connection timeout (second), default 30 oceanbase-ce: depends: - ob-configserver servers: - name: observer1 # Please don't use hostname, only IP can be supported ip: 172.20.0.3 - name: observer2 ip: 172.20.0.4 - name: observer3 ip: 172.20.0.5 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: eth0 cluster_id: 1 # please set memory limit to a suitable value which is matching resource. memory_limit: 10G # The maximum running memory for an observer system_memory: 2G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G. datafile_size: 50G # Size of the data file. log_disk_size: 50G # The size of disk space used by the clog files. cpu_count: 6 __min_full_resource_pool_memory: 1073741824 enable_rebalance: true 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. max_syslog_file_count: 4 # The maximum number of reserved log files before enabling auto recycling. The default value is 0. # Cluster name for OceanBase Database. The default value is obcluster. When you deploy OceanBase Database and obproxy, this value must be the same as the cluster_name for obproxy. appname: obcluster root_password: xxxxxxxxxx proxyro_password: xxxxxxxxxx # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty observer_sys_password: xxxxxxxxxx # ocp_meta_db: ocp_express # The database name of ocp express meta # ocp_meta_username: meta # The username of ocp express meta # ocp_meta_password: '' # The password of ocp express meta # ocp_agent_monitor_password: '' # The password for obagent monitor user ocp_meta_tenant: # The config for ocp express meta tenant tenant_name: ocp max_cpu: 1 memory_size: 2G log_disk_size: 7680M # The recommend value is (4608 + (expect node num + expect tenant num) * 512) M. ocp_agent_monitor_password: xxxxxxxxxx ocp_root_password: xxxxxxxxxx ocp_meta_password: xxxxxxxxxx observer1: 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. obshell_port: 2886 # Operation and maintenance port for Oceanbase Database. The default value is 2886. This parameter is valid only when the version of oceanbase-ce is 4.2.2.0 or later. # The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field. home_path: /data/oceanbase_servers/observer # The directory for data storage. The default value is $home_path/store. data_dir: /data/oceanbase_data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /data/oceanbase_redo zone: zone1 observer2: 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. obshell_port: 2886 # Operation and maintenance port for Oceanbase Database. The default value is 2886. This parameter is valid only when the version of oceanbase-ce is 4.2.2.0 or later. # The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field. home_path: /data/oceanbase_servers/observer # The directory for data storage. The default value is $home_path/store. data_dir: /data/oceanbase_data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /data/oceanbase_redo zone: zone2 observer3: 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. obshell_port: 2886 # Operation and maintenance port for Oceanbase Database. The default value is 2886. This parameter is valid only when the version of oceanbase-ce is 4.2.2.0 or later. # The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field. home_path: /data/oceanbase_servers/observer # The directory for data storage. The default value is $home_path/store. data_dir: /data/oceanbase_data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. redo_dir: /data/oceanbase_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 - ob-configserver servers: - 172.20.0.8 - 172.20.0.9 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: /data/oceanbase_servers/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: 172.20.0.3:2881;172.20.0.4:2881;172.20.0.5: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 client_session_id_version: 2 obproxy_sys_password: xxxxxxxxxx # 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: xxxxxxxxxx # 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. 172.20.0.8: proxy_id: 7705 client_session_id_version: 2 172.20.0.9: proxy_id: 7706 client_session_id_version: 2 obagent: depends: - oceanbase-ce # The list of servers to be monitored. This list is consistent with the servers in oceanbase-ce. servers: - name: observer1 ip: 172.20.0.3 - name: observer2 ip: 172.20.0.4 - name: observer3 ip: 172.20.0.5 global: home_path: /data/oceanbase_servers/obagent # The port of monitor agent. The default port number is 8088. monagent_http_port: 8088 # The port of manager agent. The default port number is 8089. mgragent_http_port: 8099 # Log path. The default value is log/monagent.log. log_path: log/monagent.log # The log level of manager agent. mgragent_log_level: info # The total size of manager agent.Log size is measured in Megabytes. The default value is 30M. mgragent_log_max_size: 30 # Expiration time for manager agent logs. The default value is 30 days. mgragent_log_max_days: 30 # The maximum number for manager agent log files. The default value is 15. mgragent_log_max_backups: 15 # The log level of monitor agent. monagent_log_level: info # The total size of monitor agent.Log size is measured in Megabytes. The default value is 200M. monagent_log_max_size: 200 # Expiration time for monitor agent logs. The default value is 30 days. monagent_log_max_days: 30 # The maximum number for monitor agent log files. The default value is 15. monagent_log_max_backups: 15 # Username for HTTP authentication. The default value is admin. http_basic_auth_user: admin # Password for HTTP authentication. The default value is a random password. http_basic_auth_password: xxxxxxxxxx monitor_user: ocp_monitor # Monitor password for OceanBase Database. The default value is empty. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the ocp_agent_monitor_password in oceanbase-ce. monitor_password: xxxxxxxxxx # The SQL port for observer. The default value is 2881. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the mysql_port in oceanbase-ce. sql_port: 2881 # The RPC port for observer. The default value is 2882. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the rpc_port in oceanbase-ce. rpc_port: 2882 # Cluster name for OceanBase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the appname in oceanbase-ce. cluster_name: obcluster # Cluster ID for OceanBase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the cluster_id in oceanbase-ce. cluster_id: 1 # The redo dir for Oceanbase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the redo_dir in oceanbase-ce. ob_log_path: /data/oceanbase_redo # The data dir for Oceanbase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the data_dir in oceanbase-ce. ob_data_path: /data/oceanbase_data # The work directory for Oceanbase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the home_path in oceanbase-ce. ob_install_path: /data/oceanbase_servers/observer # The log path for Oceanbase Database. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the {home_path}/log in oceanbase-ce. observer_log_path: /data/oceanbase_servers/observer/log # Monitor status for OceanBase Database. Active is to enable. Inactive is to disable. The default value is active. When you deploy an cluster automatically, obd decides whether to enable this parameter based on depends. ob_monitor_status: active observer1: # Zone name for your observer. The default value is zone1. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the zone name in oceanbase-ce. zone_name: zone1 observer2: # Zone name for your observer. The default value is zone1. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the zone name in oceanbase-ce. zone_name: zone2 observer3: # Zone name for your observer. The default value is zone1. When a depends exists, obd gets this value from the oceanbase-ce of the depends. The value is the same as the zone name in oceanbase-ce. zone_name: zone3 prometheus: servers: - 172.20.0.9 depends: - obagent global: # The working directory for prometheus. prometheus is started under this directory. This is a required field. home_path: /data/oceanbase_servers/prometheus address: 0.0.0.0 # The ip address to bind to. Along with port, corresponds to the `web.listen-address` parameter. port: 9091 # The http port to use. Along with address, corresponds to the `web.listen-address` parameter. enable_lifecycle: true # Enable shutdown and reload via HTTP request. Corresponds to the `web.enable-lifecycle` parameter. data_dir: /data/oceanbase_servers/prometheus/data # Base path for metrics storage. Corresponds to the `storage.tsdb.path` parameter. basic_auth_users: # Usernames and passwords that have full access to the web server via basic authentication. Corresponds to the `basic_auth_users` parameter. admin: xxxxxxxxxx # The format of `basic_auth_users` : the key is the user name and the value is the password. # web_config: # Content of Prometheus web service config file. The format is consistent with the file. However, `basic_auth_users` cannot be set in it. Please set `basic_auth_users` above if needed. Corresponds to the `web.config.file` parameter. # tls_server_config: # # Certificate and key files for server to use to authenticate to client. # cert_file: # key_file: config: # Configuration of the Prometheus service. The format is consistent with the Prometheus config file. Corresponds to the `config.file` parameter. rule_files: - rules/*rules.yaml scrape_configs: - job_name: prometheus metrics_path: /metrics scheme: http static_configs: - targets: - localhost:9091 - job_name: node basic_auth: username: admin password: xxxxxxxxxx metrics_path: /metrics/node/host scheme: http file_sd_configs: # Set the targets to be collected by reading local files. The example is to collect targets corresponding to all yaml files in the 'targets' directory under $home_path. - files: - targets/*.yaml - job_name: ob_basic basic_auth: username: admin password: xxxxxxxxxx metrics_path: /metrics/ob/basic scheme: http file_sd_configs: - files: - targets/*.yaml - job_name: ob_extra basic_auth: username: admin password: xxxxxxxxxx metrics_path: /metrics/ob/extra scheme: http file_sd_configs: - files: - targets/*.yaml - job_name: agent basic_auth: username: admin password: xxxxxxxxxx metrics_path: /metrics/stat scheme: http file_sd_configs: - files: - targets/*.yaml # additional_parameters: # Additional parameters for Prometheus service, among which `web.listen-address`, `web.enable-lifecycle`, `storage.tsdb.path`, `config.file` and `web.config.file` cannot be set. Please set them in the corresponding configuration above if needed. # - log.level: debug grafana: servers: - 172.20.0.9 depends: - prometheus global: home_path: /data/oceanbase_servers/grafana login_password: xxxxxxxxxx # Grafana login password. # data_dir: # Path to where grafana can store temp files, sessions, and the sqlite3 db (if that is used).$data_dir can be empty. The default value is $home_path/data. # logs_dir: # Directory where grafana can store logs, can be empty. The default value is $data_dir/log. # plugins_dir: # Directory where grafana will automatically scan and look for plugins, can be empty. The default value is $data_dir/plugins. # provisioning_dir: # folder that contains provisioning config files that grafana will apply on startup and while running, can be empty. The default value is $home_path/conf/provisioning. # temp_data_lifetime: # How long temporary images in data directory should be kept. Supported modifiers h (hours), m (minutes), Use 0 to never clean up temporary files, can be empty. The default value is 24h. # log_max_days: # Expired days of log file(delete after max days), can be empty. The default value is 7. # domian: # The public facing domain name used to access grafana from a browser, can be empty. The default value is $server.ip. port: 3001 # The http port to use, can be empty. The default value is 3000. # # list of datasources to insert/update depending on what's available in the database, can be empty. # # For more parameter settings, please refer to https://grafana.com/docs/grafana/latest/administration/provisioning/#datasources # datasources: # name: # name of the datasource. Required and should not be 'OB-Prometheus' # type: # datasource type. Required # access: # access mode. direct or proxy. Required # url: # the url of datasource # list of dashboards providers that load dashboards into Grafana from the local filesystem, can be empty. # For more information, please refer to https://grafana.com/docs/grafana/latest/administration/provisioning/#dashboards # providers: # name: # an unique provider name. Required and should not be 'OceanBase Metrics' # type: # provider type. Default to 'file' # options: # path: # path to dashboard files on disk. Required when using the 'file' type # # customize your Grafana instance by adding/modifying the custom configuration as follows # # for more information, please refer to https://grafana.com/docs/grafana/latest/setup-grafana/configure-grafana/#configure-grafana # # Here, setting parameters is required for format conversion. # # For example, if the original grafana configuration format is # # # # [section1.section2] # # key1 = value1 # # key2 = value2 # # # # Then when writing the configuration below, you need to write it as # # # # section1: # # section2: # # key1: value1 # # key2: value2 # # # # Here we only list one item, because there are more than 500 items. Please add them according to your own needs. # customize_config: # # original grafana configuration format is # # [server] # # protocol = http # server: # protocol: http ob-configserver: servers: - 127.0.0.1 global: listen_port: 8080 # The port of ob-configserver web # server_ip: 0.0.0.0 # Listen to the ob-configserver server IP。When you want to listen to the specified IP address,use it. home_path: /home/admin/ob-configserver # The working directory for prometheus. ob-configserver is started under this directory. This is a required field. ## log config # log_level: info # Log printing level of ob-configserver。The default value is `info` # log_maxsize: 30 # The total size of manager ob-configserver.Log size is measured in Megabytes.The default value is 30 # log_maxage: 7 # The days of manager expired ob-configserver.Log retention days. The default value is 7 # log_maxbackups: 10 #The number of manager expired ob-configserver.Log. The default value is 10 # log_localtime: true # Switch of ob-configserver.Log naming with localtime. The default value is true # log_compress: true # Compress ob-configserver.Log switch. The default value is true ## vip config, configserver will generate url with vip_address and port and return it to the client ## do not use some random value that can't be connected # vip_address: "10.10.10.1" # vip_port: 8080 ## storage config # storage: # database_type: sqlite3 # sqlite3 or mysql. Default sqlite3 # connection_url: "" # When database_type is set to sqlite3, the connection_url parameter can be left empty. If it is empty, the default value $home_path/.data.db?cache=shared&_fk=1 will be used. When database_type is set to mysql, the connection_url parameter must be configured, with a sample value of user:password@tcp(10.10.10.1:2883)/test?parseTime=true. #ocp-express: # depends: # - oceanbase-ce # - obproxy-ce # - obagent # servers: # - 172.20.0.8 # global: # # The working directory for prometheus. prometheus is started under this directory. This is a required field. # home_path: /data/oceanbase_servers/ocp-express # log_dir: /data/oceanbase_servers/ocp-express/log # The log directory of ocp express server. The default value is {home_path}/log. # memory_size: 1G # The memory size of ocp-express server. The recommend value is 512MB * (expect node num + expect tenant num) * 60MB. # logging_file_total_size_cap: 10G # The total log file size of ocp-express server # # logging_file_max_history: 1 # The maximum of retention days the log archive log files to keep. The default value is unlimited # jdbc_url: jdbc:oceanbase://IP:PORT/meta_db # jdbc connection string to connect to the meta db # jdbc_username: user_name@tenant_name # username to connect to meta db # jdbc_password: '' # password to connect to meta db # port: 8180 # The http port to use. # cluster_name: obcluster # the cluster name of oceanbase cluster. Refer to the configuration item appname of oceanbase # ob_cluster_id: 1 # the cluster id of oceanbase cluster. Refer to the configuration item cluster_id of oceanbase # root_sys_password: yuAf)7kGLA7wvjad3c # the pass of oceanbase cluster. Refer to the configuration item cluster_id of oceanbase # agent_username: # The username of obagent # agent_password: # The password of obagent