## Only need to configure when remote login is required # user: username: DBA_zongzhiwen password: Mk8Mb7$d@h # 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: 10.102.6.39 - name: server2 ip: 10.102.6.44 - name: server3 ip: 10.102.6.20 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 # if current hardware's memory capacity is smaller than 50G, please use the setting of "mini-single-example.yaml" and do a small adjustment. memory_limit: 64G # The maximum running memory for an observer # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G. system_memory: 30G datafile_size: 192G # Size of the data file. log_disk_size: 192G # The size of disk space used by the clog files. 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. # 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: # root user password # proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty # 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. # In this example , support multiple ob process in single node, so different process use different ports. # If deploy ob cluster in multiple nodes, the port and path setting can be same. 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/DBA_zongzhiwen/observer # The directory for data storage. The default value is $home_path/store. # data_dir: /data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. # redo_dir: /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/DBA_zongzhiwen/observer # The directory for data storage. The default value is $home_path/store. # data_dir: /data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. # redo_dir: /redo zone: zone2 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/DBA_zogzhiwen/observer # The directory for data storage. The default value is $home_path/store. # data_dir: /data # The directory for clog, ilog, and slog. The default value is the same as the data_dir value. # redo_dir: /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: - 10.102.6.20 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/DBA_zongzhiwen/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. obagent: depends: - oceanbase-ce servers: - name: server1 # Please don't use hostname, only IP can be supported ip: 10.102.6.39 - name: server2 ip: 10.102.6.44 - name: server3 ip: 10.102.6.20 global: home_path: /home/DBA_zongzhiwen/obagent prometheus: servers: - 10.102.6.20 depends: - obagent global: # The working directory for prometheus. prometheus is started under this directory. This is a required field. home_path: /home/oceanbase/ocp-server # address: 0.0.0.0 # The ip address to bind to. Along with port, corresponds to the `web.listen-address` parameter. # port: 9090 # 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: /root/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. # : # 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:9090 # - job_name: node # basic_auth: # username: admin # password: root # 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: root # metrics_path: /metrics/ob/basic # scheme: http # file_sd_configs: # - files: # - 'targets/*.yaml' # - job_name: ob_extra # basic_auth: # username: admin # password: root # metrics_path: /metrics/ob/extra # scheme: http # file_sd_configs: # - files: # - 'targets/*.yaml' # - job_name: agent # basic_auth: # username: admin # password: root # 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: - 10.102.6.20 depends: - prometheus global: home_path: /root/grafana login_password: oceanbase # Grafana login password. The default value is 'oceanbase'. # 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: # 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 ocp-express: depends: - oceanbase-ce - obproxy-ce - obagent servers: - 10.102.6.20 global: # The working directory for prometheus. prometheus is started under this directory. This is a required field. home_path: /root/ocp-express # log_dir: /home/oceanbase/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