[root@zone1 ~]# obd cluster start myobd
[ERROR] No such deploy: myobd.
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 028bf5d8-12fb-11ee-995d-00505697dd9e
If you want to view detailed obd logs, please run: obd display-trace 028bf5d8-12fb-11ee-995d-00505697dd9e
[root@zone1 ~]# obd cluster start myodb
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
Check before start obproxy ok
Check before start obagent ok
Check before start ocp-express x
[ERROR] OBD-4306: (10.20.1.13) ocp-express admin_passwd invalid.(Current :None)
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 06ef93c8-12fb-11ee-8bce-00505697dd9e
If you want to view detailed obd logs, please run: obd display-trace 06ef93c8-12fb-11ee-8bce-00505697dd9e
[root@zone1 ~]# obd cluster list;
±---------------------------------------------------+
| Cluster List |
±------±-------------------------±----------------+
| Name | Configuration Path | Status (Cached) |
±------±-------------------------±----------------+
| myodb | /root/.obd/cluster/myodb | deployed |
±------±-------------------------±----------------+
Trace ID: 3b09bf58-12fb-11ee-8c9d-00505697dd9e
If you want to view detailed obd logs, please run: obd display-trace 3b09bf58-12fb-11ee-8c9d-00505697dd9e
日志输出:
[root@zone1 ~]# obd display-trace 3b09bf58-12fb-11ee-8c9d-00505697dd9e
[2023-06-25 09:54:33.166] [DEBUG] - cmd: []
[2023-06-25 09:54:33.166] [DEBUG] - opts: {}
[2023-06-25 09:54:33.167] [DEBUG] - mkdir /root/.obd/lock/
[2023-06-25 09:54:33.168] [DEBUG] - set lock mode to NO_LOCK(0)
[2023-06-25 09:54:33.168] [DEBUG] - Get deploy list
[2023-06-25 09:54:33.168] [DEBUG] - mkdir /root/.obd/cluster/
[2023-06-25 09:54:33.169] [DEBUG] - mkdir /root/.obd/config_parser/
[2023-06-25 09:54:33.190] [INFO] ±---------------------------------------------------+
[2023-06-25 09:54:33.190] [INFO] | Cluster List |
[2023-06-25 09:54:33.190] [INFO] ±------±-------------------------±----------------+
[2023-06-25 09:54:33.190] [INFO] | Name | Configuration Path | Status (Cached) |
[2023-06-25 09:54:33.190] [INFO] ±------±-------------------------±----------------+
[2023-06-25 09:54:33.191] [INFO] | myodb | /root/.obd/cluster/myodb | deployed |
[2023-06-25 09:54:33.191] [INFO] ±------±-------------------------±----------------+
[2023-06-25 09:54:33.191] [INFO] Trace ID: 3b09bf58-12fb-11ee-8c9d-00505697dd9e
[2023-06-25 09:54:33.192] [INFO] If you want to view detailed obd logs, please run: obd display-trace 3b09bf58-12fb-11ee-8c9d-00505697dd9e
config.yaml 配置如下:
[root@zone1 ~]# cat /root/.obd/cluster/myodb/config.yaml
Only need to configure when remote login is required
user:
username: root
password: cyt@95go.cn
key_file: /root/.ssh/id_rsa.pub
port: your ssh port, default 22
timeout: ssh connection timeout (second), default 30
oceanbase-ce:
servers:
- name: z01
Please don’t use hostname, only IP can be supported
ip: 10.20.1.13 - name: z02
ip: 10.20.1.14 - name: z03
ip: 10.20.1.15
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: 1please set memory limit to a suitable value which is matching resource.
memory_limit: 20G # The maximum running memory for an observer
system_memory: 8G # 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: 2147483648
workers_per_cpu_quota: 10
schema_history_expire_time: 1dThe 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 # 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: 50G
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: Pwd2022# # root user password, can be empty
proxyro_password: Pwd2022# # proxyro user pasword, consistent with obproxy’s observer_sys_password, can be empty
z01:
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: /data/admin/oceanbase-ceThe directory for data storage. The default value is $home_path/store.
data_dir: /data/odbdataThe directory for clog, ilog, and slog. The default value is the same as the data_dir value.
redo_dir: /redo
zone: zone1
z02:
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: /data/admin/oceanbase-ceThe directory for data storage. The default value is $home_path/store.
data_dir: /data/odbdataThe directory for clog, ilog, and slog. The default value is the same as the data_dir value.
redo_dir: /repo
zone: zone2
z03:
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: /data/admin/oceanbase-ceThe directory for data storage. The default value is $home_path/store.
data_dir: /data/odbdataThe directory for clog, ilog, and slog. The default value is the same as the data_dir value.
redo_dir: /redo
zone: zone3
obproxy-ce:
version: 4.1.0.0
package_hash: 2a9d9bf67f179dcca2a8c9e7c77373d94e7e2abe
release: 7.el7
servers: - 10.20.1.13
global:
prometheus_listen_port: 2884
listen_port: 2883
home_path: /data/myodb/obproxy
obproxy_sys_password: ‘’
skip_proxy_sys_private_check: true
enable_strict_kernel_release: false
enable_cluster_checkout: false
depends: - oceanbase-ce
obagent:
version: 1.3.1
package_hash: ccfe93272a79ab1073e76f00580386c9c52e8324
release: 5.el7
servers: - 10.20.1.13
- 10.20.1.14
- 10.20.1.15
global:
monagent_http_port: 8088
mgragent_http_port: 8089
home_path: /data/myodb/obagent
http_basic_auth_user: admin
http_basic_auth_password: root
ob_monitor_status: active
depends: - oceanbase-ce
ocp-express:
version: 1.0.1
package_hash: 59eb8062858271a23080c824c98a72f9e5896235
release: 100000072023051917.el7
servers: - 10.20.1.13
global:
port: 8180
home_path: /data/myodb/ocpexpress
java_bin: java
logging_file_max_size: 100MB
logging_file_total_size_cap: 1GB
memory_size: 872M
depends: - obagent
- oceanbase-ce
- obproxy-ce