1，系统环境
[root@i-7A854B18 ~]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[root@i-7A854B18 ~]# free -h
total used free shared buff/cache available
Mem: 30G 14G 10G 8.7M 5.4G 10G
Swap: 0B 0B 0B
2，docker软件版本
[root@i-7A854B18 ~]# docker -v
Docker version 18.03.1-ce, build 9ee9f40
执行如下命令安装 docker。
yum install docker
执行如下命令启动docker。
systemctl start docker
3，部署OceanBase 数据库，并建立2个租户
#ob数据库信息
#建立租户，并设置密码
create resource unit ocp_unit_config min_cpu=3, max_cpu=3, min_memory=1073741824, max_memory=1073741824, max_iops=1000, min_iops=128, max_disk_size=1000000000, max_session_num=100;
#创建ocp_meta资源池
create resource pool ocp_pool unit='ocp_unit_config', zone_list=('zone1'), unit_num=1;
create tenant ocp_meta resource_pool_list = ('ocp_pool');
#登录 ocp_meta 的 root 用户（即 root@ocp_meta）。set global ob_tcp_invited_nodes = '%';
create user ocp identified by 'aaAA__11';
grant all on *.* to ocp;
alter user root identified by 'aaAA__11';
#创建ocp_monitor资源池create resource pool ocp__monitor_pool unit='ocp_unit_config', zone_list=('zone1'), unit_num=1;
create tenant ocp_monitor resource_pool_list = ('ocp__monitor_pool');
#登录 ocp_monitor 的 root 用户（即 root@ocp_monitor）set global ob_tcp_invited_nodes = '%';
create user ocp identified by 'aaAA__11';
grant all on *.* to ocp;
alter user root identified by 'aaAA__11';
测试租户连接：
mysql -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11
mysql -h192.168.6.61 -P2881 -uroot@ocp_monitor -paaAA__114，部署ocp
ocp软件版本：
ocp-3.1.1-ce.tar.gz
4.1，生成配置文件
#解压软件并生成配置文件：
chmod +x ocp_installer.sh
./ocp_installer.sh genconf -c ocp.yaml4.2编辑配置文件
本次部署采用单节点ob数据库，端口为2881.
设置操作系统公钥，密码文件，数据库用户和密码文件。
[root@i-7A854B18 ocp-3.1.1-ce]# cat ocp.yaml
OCP_IP_ARRAY=(192.168.6.61) # （IP1 IP2 IP3）
SSH_USER=root # if not root, make sure remote user can use sudo without password admin ALL=(ALL) NOPASSWD:ALL
SSH_PORT=22
SSH_AUTH=pubkey # can be password or pubkey
SSH_PASSWORD='root' # password for passowrd auth, when use pubkey auth, is passphrase
SSH_KEY_FILE='/root/.ssh/id_rsa' # pubkey auth
OCP_METADB_HOST=192.168.6.61
OCP_METADB_PORT=2881
OCP_METADB_USER=root@ocp_meta
OCP_METADB_PASSWORD='aaAA__11' # password may contains special char, make sure correctly quote
OCP_METADB_DBNAME=ocp
OCP_MONITORDB_USER=root@ocp_meta
OCP_MONITORDB_PASSWORD='aaAA__11' # password may contains special char, make sure correctly quote
OCP_MONITORDB_DBNAME=ocp_monitor
OCP_WEB_PORT=8080
OCP_LB_VIP= # HA OCP VIP
OCP_LB_VPORT= # HA OCP VPORT
OCP_IMAGE=/root/ocp-3.1.1-ce/ocp.tar.gz # absoulute path of ocp image file
OCP_CPU=4
OCP_MEMORY=20G
OCP_LOG_DIR=/data/ocp_logs
4.3运行安装
[root@i-7A854B18 ocp-3.1.1-ce]# ./ocp_installer.sh install -c ocp.yaml
install start
check sshpass
check docker
check image info
ocp image repo tag is reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.1.1-ce
Loaded image: reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.1.1-ce
reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.1.1-ce
load ocp image /root/ocp-3.1.1-ce/ocp.tar.gz succeess on 192.168.6.61
create_metadb.py:381: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
data = yaml.load(file)
/home/admin/ocp-init/src/ocp-init/gen_dynamic_config_properties.py:14: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
data = yaml.load(file)
/home/admin/ocp-init/src/ocp-init/yml_to_table.py:62: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
data = yaml.load(file)
Generated yml file:
OcpInitParameter:
METADB:
ip: &metadb_ip 192.168.6.61
username: &metadb_username root@ocp_meta
password: &metadb_password 'aaAA__11'
port: &metadb_port 2881
dbname: &metadb_dbname ocp
MONITORDB:
ip: &monitordb_ip 192.168.6.61
username: &monitordb_username root@ocp_meta
password: &monitordb_password 'aaAA__11'
port: &monitordb_port 2881
dbname: &monitordb_dbname ocp_monitor
CONFIGURATION:
ocp.monitordb.host: *monitordb_ip
ocp.monitordb.port: *monitordb_port
ocp.monitordb.username: *monitordb_username
ocp.monitordb.password: *monitordb_password
ocp.monitordb.database: *monitordb_dbname
ocp.iam.auth: local
backup.dbname.prefix: &backup_dbname_prefix backup
create database if not exists, database:ocp, host:192.168.6.61, user:root@ocp_meta, port:2881
mysql -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -e 'create database if not exists `ocp`;'
table config_properties or ocp2_sys_property not exist
generate ../../sqls/dynamic_config_properties.sql success
generate ../../sqls/ob_cluster_parameter_info.sql success
generate ../../sqls/obproxy_parameter_info.sql success
generate ../../sqls/ob_tenant_parameter_info.sql success
generate ../../sqls/config_properties.sql success
generate ../../sqls/ob_cluster_event_info.sql success
generate ../../sqls/monitor_metric_ob_collect_config.sql success
generate ../../sqls/audit_event_meta.sql success
generate ../../sqls/ocp2_alarm_metric_meta.sql success
generate ../../sqls/ocp2_alarm_rule.sql success
generate ../../sqls/ocp2_template_variable_meta.sql success
generate ../../sqls/mc_ocp_cluster_config.sql success
all sql files:
['ocp_metadb_ddl.sql', 'ocp_metadb_tablegroup.sql', 'ocp_metadb_dml.sql', 'update_ddl_2.2.0.sql', 'update_ddl_2.3.0.sql', 'update_ddl_2.3.1.sql', 'update_ddl_2.3.2.sql', 'update_ddl_2.3.3.sql', 'update_ddl_2.3.4.sql', 'update_ddl_2.3.5.sql', 'update_ddl_2.3.7.sql', 'update_ddl_2.4.0.sql', 'update_ddl_2.4.1.sql', 'update_ddl_2.4.2.sql', 'update_ddl_2.4.3.sql', 'update_ddl_2.4.4.sql', 'update_ddl_2.4.5.sql', 'update_ddl_2.5.0.sql', 'update_ddl_2.5.1.sql', 'update_ddl_2.5.4.sql', 'update_ddl_3.1.0.sql', 'update_ddl_3.1.1.sql', 'update_dml_2.2.0.sql', 'update_dml_2.3.0.sql', 'update_dml_2.3.1.sql', 'update_dml_2.3.2.sql', 'update_dml_2.3.3.sql', 'update_dml_2.3.4.sql', 'update_dml_2.3.5.sql', 'update_dml_2.3.6.sql', 'update_dml_2.3.7.sql', 'update_dml_2.4.0.sql', 'update_dml_2.4.1.sql', 'update_dml_2.4.2.sql', 'update_dml_2.4.3.sql', 'update_dml_2.4.4.sql', 'update_dml_2.4.5.sql', 'update_dml_2.5.0.sql', 'update_dml_2.5.1.sql', 'update_dml_2.5.2.sql', 'update_dml_2.5.3.sql', 'update_dml_2.5.4.sql', 'update_dml_3.1.0.sql', 'update_dml_3.1.1.sql', 'ob_cluster_parameter_info.sql', 'obproxy_parameter_info.sql', 'ob_tenant_parameter_info.sql', 'ob_cluster_event_info.sql', 'monitor_metric_ob_collect_config.sql', 'config_properties.sql', 'audit_event_meta.sql', 'ocp2_alarm_metric_meta.sql', 'ocp2_alarm_rule.sql', 'ocp2_template_variable_meta.sql', 'mc_ocp_cluster_config.sql', 'dynamic_config_properties.sql']
start to load sqls
replace table_group in sql file: ocp_metadb_ddl.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp_metadb_ddl.sql > ../../sqls/real_ocp_metadb_ddl.sql
executing real sql script: real_ocp_metadb_ddl.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp_metadb_ddl.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ocp_metadb_tablegroup.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp_metadb_tablegroup.sql > ../../sqls/real_ocp_metadb_tablegroup.sql
executing real sql script: real_ocp_metadb_tablegroup.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp_metadb_tablegroup.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ocp_metadb_dml.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp_metadb_dml.sql > ../../sqls/real_ocp_metadb_dml.sql
executing real sql script: real_ocp_metadb_dml.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp_metadb_dml.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.2.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.2.0.sql > ../../sqls/real_update_ddl_2.2.0.sql
executing real sql script: real_update_ddl_2.2.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.2.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.0.sql > ../../sqls/real_update_ddl_2.3.0.sql
executing real sql script: real_update_ddl_2.3.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.1.sql > ../../sqls/real_update_ddl_2.3.1.sql
executing real sql script: real_update_ddl_2.3.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.2.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.2.sql > ../../sqls/real_update_ddl_2.3.2.sql
executing real sql script: real_update_ddl_2.3.2.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.2.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.3.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.3.sql > ../../sqls/real_update_ddl_2.3.3.sql
executing real sql script: real_update_ddl_2.3.3.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.3.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.4.sql > ../../sqls/real_update_ddl_2.3.4.sql
executing real sql script: real_update_ddl_2.3.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.5.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.5.sql > ../../sqls/real_update_ddl_2.3.5.sql
executing real sql script: real_update_ddl_2.3.5.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.5.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.3.7.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.3.7.sql > ../../sqls/real_update_ddl_2.3.7.sql
executing real sql script: real_update_ddl_2.3.7.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.3.7.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.0.sql > ../../sqls/real_update_ddl_2.4.0.sql
executing real sql script: real_update_ddl_2.4.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.1.sql > ../../sqls/real_update_ddl_2.4.1.sql
executing real sql script: real_update_ddl_2.4.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.2.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.2.sql > ../../sqls/real_update_ddl_2.4.2.sql
executing real sql script: real_update_ddl_2.4.2.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.2.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.3.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.3.sql > ../../sqls/real_update_ddl_2.4.3.sql
executing real sql script: real_update_ddl_2.4.3.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.3.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.4.sql > ../../sqls/real_update_ddl_2.4.4.sql
executing real sql script: real_update_ddl_2.4.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.4.5.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.4.5.sql > ../../sqls/real_update_ddl_2.4.5.sql
executing real sql script: real_update_ddl_2.4.5.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.4.5.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.5.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.5.0.sql > ../../sqls/real_update_ddl_2.5.0.sql
executing real sql script: real_update_ddl_2.5.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.5.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.5.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.5.1.sql > ../../sqls/real_update_ddl_2.5.1.sql
executing real sql script: real_update_ddl_2.5.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.5.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_2.5.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_2.5.4.sql > ../../sqls/real_update_ddl_2.5.4.sql
executing real sql script: real_update_ddl_2.5.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_2.5.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_3.1.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_3.1.0.sql > ../../sqls/real_update_ddl_3.1.0.sql
executing real sql script: real_update_ddl_3.1.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_3.1.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_ddl_3.1.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_ddl_3.1.1.sql > ../../sqls/real_update_ddl_3.1.1.sql
executing real sql script: real_update_ddl_3.1.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_ddl_3.1.1.sql >>ocp-init.log 2>>ocp-init.err
+++++++++++++++++++++++++++++++++
+ wait for election, sleep 120S +
+++++++++++++++++++++++++++++++++
replace table_group in sql file: update_dml_2.2.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.2.0.sql > ../../sqls/real_update_dml_2.2.0.sql
executing real sql script: real_update_dml_2.2.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.2.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.0.sql > ../../sqls/real_update_dml_2.3.0.sql
executing real sql script: real_update_dml_2.3.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.1.sql > ../../sqls/real_update_dml_2.3.1.sql
executing real sql script: real_update_dml_2.3.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.2.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.2.sql > ../../sqls/real_update_dml_2.3.2.sql
executing real sql script: real_update_dml_2.3.2.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.2.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.3.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.3.sql > ../../sqls/real_update_dml_2.3.3.sql
executing real sql script: real_update_dml_2.3.3.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.3.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.4.sql > ../../sqls/real_update_dml_2.3.4.sql
executing real sql script: real_update_dml_2.3.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.5.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.5.sql > ../../sqls/real_update_dml_2.3.5.sql
executing real sql script: real_update_dml_2.3.5.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.5.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.6.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.6.sql > ../../sqls/real_update_dml_2.3.6.sql
executing real sql script: real_update_dml_2.3.6.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.6.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.3.7.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.3.7.sql > ../../sqls/real_update_dml_2.3.7.sql
executing real sql script: real_update_dml_2.3.7.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.3.7.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.0.sql > ../../sqls/real_update_dml_2.4.0.sql
executing real sql script: real_update_dml_2.4.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.1.sql > ../../sqls/real_update_dml_2.4.1.sql
executing real sql script: real_update_dml_2.4.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.2.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.2.sql > ../../sqls/real_update_dml_2.4.2.sql
executing real sql script: real_update_dml_2.4.2.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.2.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.3.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.3.sql > ../../sqls/real_update_dml_2.4.3.sql
executing real sql script: real_update_dml_2.4.3.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.3.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.4.sql > ../../sqls/real_update_dml_2.4.4.sql
executing real sql script: real_update_dml_2.4.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.4.5.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.4.5.sql > ../../sqls/real_update_dml_2.4.5.sql
executing real sql script: real_update_dml_2.4.5.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.4.5.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.5.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.5.0.sql > ../../sqls/real_update_dml_2.5.0.sql
executing real sql script: real_update_dml_2.5.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.5.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.5.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.5.1.sql > ../../sqls/real_update_dml_2.5.1.sql
executing real sql script: real_update_dml_2.5.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.5.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.5.2.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.5.2.sql > ../../sqls/real_update_dml_2.5.2.sql
executing real sql script: real_update_dml_2.5.2.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.5.2.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.5.3.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.5.3.sql > ../../sqls/real_update_dml_2.5.3.sql
executing real sql script: real_update_dml_2.5.3.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.5.3.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_2.5.4.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_2.5.4.sql > ../../sqls/real_update_dml_2.5.4.sql
executing real sql script: real_update_dml_2.5.4.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_2.5.4.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_3.1.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_3.1.0.sql > ../../sqls/real_update_dml_3.1.0.sql
executing real sql script: real_update_dml_3.1.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_3.1.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: update_dml_3.1.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/update_dml_3.1.1.sql > ../../sqls/real_update_dml_3.1.1.sql
executing real sql script: real_update_dml_3.1.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_update_dml_3.1.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ob_cluster_parameter_info.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ob_cluster_parameter_info.sql > ../../sqls/real_ob_cluster_parameter_info.sql
executing real sql script: real_ob_cluster_parameter_info.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ob_cluster_parameter_info.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: obproxy_parameter_info.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/obproxy_parameter_info.sql > ../../sqls/real_obproxy_parameter_info.sql
executing real sql script: real_obproxy_parameter_info.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_obproxy_parameter_info.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ob_tenant_parameter_info.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ob_tenant_parameter_info.sql > ../../sqls/real_ob_tenant_parameter_info.sql
executing real sql script: real_ob_tenant_parameter_info.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ob_tenant_parameter_info.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ob_cluster_event_info.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ob_cluster_event_info.sql > ../../sqls/real_ob_cluster_event_info.sql
executing real sql script: real_ob_cluster_event_info.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ob_cluster_event_info.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: monitor_metric_ob_collect_config.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/monitor_metric_ob_collect_config.sql > ../../sqls/real_monitor_metric_ob_collect_config.sql
executing real sql script: real_monitor_metric_ob_collect_config.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_monitor_metric_ob_collect_config.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: config_properties.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/config_properties.sql > ../../sqls/real_config_properties.sql
executing real sql script: real_config_properties.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_config_properties.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: audit_event_meta.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/audit_event_meta.sql > ../../sqls/real_audit_event_meta.sql
executing real sql script: real_audit_event_meta.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_audit_event_meta.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ocp2_alarm_metric_meta.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp2_alarm_metric_meta.sql > ../../sqls/real_ocp2_alarm_metric_meta.sql
executing real sql script: real_ocp2_alarm_metric_meta.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp2_alarm_metric_meta.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ocp2_alarm_rule.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp2_alarm_rule.sql > ../../sqls/real_ocp2_alarm_rule.sql
executing real sql script: real_ocp2_alarm_rule.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp2_alarm_rule.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: ocp2_template_variable_meta.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/ocp2_template_variable_meta.sql > ../../sqls/real_ocp2_template_variable_meta.sql
executing real sql script: real_ocp2_template_variable_meta.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_ocp2_template_variable_meta.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: mc_ocp_cluster_config.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/mc_ocp_cluster_config.sql > ../../sqls/real_mc_ocp_cluster_config.sql
executing real sql script: real_mc_ocp_cluster_config.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_mc_ocp_cluster_config.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: dynamic_config_properties.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/dynamic_config_properties.sql > ../../sqls/real_dynamic_config_properties.sql
executing real sql script: real_dynamic_config_properties.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp < ../../sqls/real_dynamic_config_properties.sql >>ocp-init.log 2>>ocp-init.err
finish to load sqls. see `ocp-init.log` for details
create database if not exists, database:ocp_monitor, host:192.168.6.61, user:root@ocp_meta, port:2881
mysql -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -e 'create database if not exists `ocp_monitor`;'
monitordb all sql files:
['monitordb_ddl_2.5.0.sql', 'monitordb_ddl_2.5.1.sql', 'monitordb_ddl_3.1.0.sql', 'monitordb_ddl_3.1.1.sql']
start to load sqls
replace table_group in sql file: monitordb_ddl_2.5.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/monitordb_ddl_2.5.0.sql > ../../sqls/real_monitordb_ddl_2.5.0.sql
executing real sql script: real_monitordb_ddl_2.5.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp_monitor < ../../sqls/real_monitordb_ddl_2.5.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: monitordb_ddl_2.5.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/monitordb_ddl_2.5.1.sql > ../../sqls/real_monitordb_ddl_2.5.1.sql
executing real sql script: real_monitordb_ddl_2.5.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp_monitor < ../../sqls/real_monitordb_ddl_2.5.1.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: monitordb_ddl_3.1.0.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/monitordb_ddl_3.1.0.sql > ../../sqls/real_monitordb_ddl_3.1.0.sql
executing real sql script: real_monitordb_ddl_3.1.0.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp_monitor < ../../sqls/real_monitordb_ddl_3.1.0.sql >>ocp-init.log 2>>ocp-init.err
replace table_group in sql file: monitordb_ddl_3.1.1.sql
sed 's/$VAR_TABLEGROUP_NAME/ocp_meta/g' ../../sqls/monitordb_ddl_3.1.1.sql > ../../sqls/real_monitordb_ddl_3.1.1.sql
executing real sql script: real_monitordb_ddl_3.1.1.sql
mysql -v -h192.168.6.61 -P2881 -uroot@ocp_meta -paaAA__11 -f -Docp_monitor < ../../sqls/real_monitordb_ddl_3.1.1.sql >>ocp-init.log 2>>ocp-init.err
finish to load sqls. see `ocp-init.log` for details
SUCCESS.
start create backup databases
backup1472 has not been existed!
start create backup1472
loading sql script: backup_metadb_init.sql
loading sql script: restore_metadb_init.sql
end create backup1472
backup147x has not been existed!
start create backup147x
loading sql script: backup_metadb_init.sql
loading sql script: restore_metadb_init.sql
end create backup147x
backup21 has not been existed!
start create backup21
loading sql script: backup_metadb_init.sql
loading sql script: restore_metadb_init.sql
end create backup21
backup2230 has not been existed!
start create backup2230
loading sql script: backup_metadb_init.sql
loading sql script: restore_metadb_init.sql
end create backup2230
end create backup databases
init ocp database success on 192.168.6.61
set ocp site url
set ocp web port
now need create sub dirs under ocp log dir
b294e00c576b89f723c6542ae59d2f93248948d82bd8d4e2d30fc9f14e9c633d
start ocp image /root/ocp-3.1.1-ce/ocp.tar.gz succeess on 192.168.6.61
waiting for ocp web console ready, max wait time is 3 min
OCP start successful on 192.168.6.61
done
5.访问web页面
admin 用户的密码，默认为 root。
6.云平台管理界面
参考手册：
https://open.oceanbase.com/docs/ocp-cn/V3.1.1/10000000000012325
最后修改时间：2022-02-21 13:14:36
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
