select a.zone,concat(a.svr_ip,':',a.svr_port) observer, cpu_total, (cpu_total-cpu_assigned) cpu_free
, round(mem_total/1024/1024/1024) mem_total_gb, round((mem_total-mem_assigned)/1024/1024/1024,2) mem_free_gb
, round(disk_total/1024/1024/1024) disk_total_gb, round((disk_total-disk_assigned)/1024/1024/1024) disk_free_gb
from __all_virtual_server_stat a join __all_server b on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port)
order by a.zone, a.svr_ip
;
select t1.name resource_pool_name, t2.`name` unit_config_name, t2.max_cpu, t2.min_cpu
, round(t2.max_memory/1024/1024/1024) max_mem_gb, round(t2.min_memory/1024/1024/1024) min_mem_gb
, round(t2.max_disk_size/1024/1024/1024) max_disk_size , t4.tenant_name
from __all_resource_pool t1 join __all_unit_config t2 on (t1.unit_config_id=t2.unit_config_id)
join __all_unit t3 on (t1.`resource_pool_id` = t3.`resource_pool_id`)
left join __all_tenant t4 on (t1.tenant_id=t4.tenant_id)
order by t1.`resource_pool_id`, t2.`unit_config_id`, t3.unit_id
;
# OCP deploy config
# Note:
# Do not use 127.0.0.1 or hostname as server address
# When a server has both public ip and private ip, if private ip is connectable, use private ip for faster connection
# If a vip is configured, it should be already created and bonded to the right server and port, the installation script won't do any work with vip maintainance, just use it to connect to the service
# Ignore precheck errors
# It's recommanded to not ignore precheck errors
#precheck_ignore: false
precheck_ignore: true
# Create an obcluster as OCP's metadb
create_metadb_cluster: true
# Clean OCP's metadb cluster when uninstall
clean_metadb_cluster: flase
# Metadb cluster deploy config
ob_cluster:
name: obcluster
home_path: /home/admin/oceanbase
root_password: 'root123'
# The directory for data storage, it's recommanded to use an independent path
data_path: /home/admin/data/1
# The directory for clog, ilog, and slog, it's recommanded to use an independent path.
redo_path: /home/admin/data/log1
sql_port: 2881
rpc_port: 2882
zones:
- name: zone1
servers:
- 10.30.41.105
- 10.30.41.106
- 10.30.41.107
## custom obd config for obcluster
custom_config:
- key: devname
value: ens32
- key: cpu_count
value: 16
- key: memory_limit
value: 10G
- key: system_memory
value: 1G
# - key: __min_full_resource_pool_memory
# value: 5368709120
# - key: datafile_maxsize
# value: 0
# - key: datafile_next
# value: 0
# Meta user info
meta:
tenant: meta_tenant
user: meta_user
password: meta_password
database: meta_database
cpu: 1
# Memory configs in GB, 4 means 4GB
memory: 2
# Monitor user info
monitor:
tenant: monitor_tenant
user: monitor_user
password: monitor_password
database: monitor_database
cpu: 1
# Memory configs in GB, 8 means 8GB
memory: 2
# Obproxy to connect metadb cluster
obproxy:
home_path: /home/admin/obproxy
port: 2883
servers:
- 10.30.41.104
## custom config for obproxy
# custom_config:
# - key: clustername
# value: obcluster
## Vip is optional, if vip is not configured, one of obproxy servers's address will be used
# vip:
# address: 1.1.1.1
# port: 2883
# Ssh auth config
ssh:
port: 22
user: admin
# auth method, support password and pubkey
auth_method: password
password: admin123
# OCP config
ocp:
# ocp container's name
name: 'ocp'
# OCP process listen port and log dir on host
process:
port: 8080
log_dir: /tmp/ocp/log
servers:
- 10.30.41.104
# OCP container's resource
resource:
cpu: 2
# Memory configs in GB, 8 means 8GB
memory: 4
# Vip is optional, if vip is not configured, one of ocp servers's address will be used
# vip:
# address: 1.1.1.1
# port: 8080
# OCP basic auth config, used when upgrade ocp
auth:
user: admin
password: admin123
# OCP metadb config, for ocp installation, if "create_metadb_cluster" is configured true, this part will be replaced with the configuration of metadb cluster and obproxy
metadb:
host: 10.30.41.104
port: 2883
meta_user: meta_user@meta_tenant#obcluster
meta_password: meta_password
meta_database: meta_database
monitor_user: monitor_user@monitor_tenant#obcluster
monitor_password: monitor_password
monitor_database: monitor_database