OceanBase 1.4 版本学习终结篇——OCP的安装

一步一步学习OceanBase系列回顾：
第一篇：OceanBase 1.4 集群手动安装步骤
第二篇：obproxy的安装、配置和使用
第三篇：OceanBase 1.4 集群——租户的创建和使用
第四篇：OceanBase1.4 集群扩容
第五篇：OceanBase1.4 集群——租户的扩容
第六篇：OceanBase1.4 集群——节点宕机故障体验
第七篇： oceanbase 1.4集群跨节点访问问题

本篇是本人学习oceanbase 1.4版本的终结篇——OCP的安装。

在最近一周多的时间里，充分体验了ob1.4版本的各种功能，从手动安装到租户的使用、集群扩容、故障体验等，由于1.4版本目前官方也不再支持，且功能还存在不完善的地方，所以建议广大OB爱好者还是从2.x版本开始学习研究。

本人也将在下一阶段开始学习oceanbase2.x，欢迎大家一起多交流，共同学习。

好了，开始ob1.4版本终结篇的介绍：基于1.4版本的ocp安装

详细安装，见上传的文档：
OceanBase1.4 ocp的安装

1、安装OCP问题总结
1.1、无法启动OCP安装GUI界面
# java -jar ocp-setup-1.0-lite.jar 
Exception in thread "main" java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sun.launcher.LauncherHelper$FXHelper.main(LauncherHelper.java:767)
Caused by: java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: /usr/local/jdk1.8.0_241/jre/lib/amd64/libglass.so: libX11.so.6: cannot open shared object file: No such file or directory
	at com.sun.javafx.tk.quantum.QuantumToolkit.startup(QuantumToolkit.java:288)
	at com.sun.javafx.application.PlatformImpl.startup(PlatformImpl.java:211)
	at com.sun.javafx.application.LauncherImpl.startToolkit(LauncherImpl.java:675)
	at com.sun.javafx.application.LauncherImpl.launchApplicationWithArgs(LauncherImpl.java:337)
	at com.sun.javafx.application.LauncherImpl.launchApplication(LauncherImpl.java:328)
	... 5 more

原因： 没有配置 x11 windows环境
# yum groupinfo "Server with GUI"
# yum -y groupinstall x11


1.2、OCP安装GUI界面中文乱码问题
 
原因：没有图形化桌面组件。
安装了GNOME Desktop组件就好了
# yum -y groupinstall gnome-desktop


1.3、安装MetaDB报错fid file doesn't exist(pidfile="run/observer.pid")

 
安装MetaDB过程最后可能会出现如上的错误：
[2020-08-11 12:48:25.988759] ERROR [LIB] pidfile_test (utility.cpp:1260) [21464][Y0-0000000000000000] [lt=0] fid file doesn't exist(pidfile="run/observer.pid") BACKTRACE:0x2de73a9 0x2d7f9f7 0x2deb6c1 0x51c424 0x7f79a9700505 0x53abc5

登录OCP服务器，检查observer进程是否已启动，如果启动，可以忽略此错误，直接finish完成。


1.4、OCP安装完成后，无法登录控制台
Ocp安装完成后，使用 admin（无密码）登录 OCP控制台，点击登录按钮没反应，无法登录控制台进行ocp集群的安装等操作。
此问题未找到原因。故放弃！



OCP MetaDB安装完成后，登录查看OCP元数据信息对应的oceanbase数据库。

[admin@ocp ~]$ ps -ef|grep observer
root     21465     1 99 12:48 ?        00:06:37 /home/admin/oceanbase/bin/observer -i eth0 -p 2881 -P 2882 -n obtrial -z ZONE_1 -d /home/admin/oceanbase/store/obtrial -l info -o rootservice_list=172.16.18.92:2882:2881,datafile_disk_perc
entage=60,config_additional_dir=/data/log1/obtrial/etc2;/data/1/obtrial/etc3,cluster_id=1admin    22244 22125  0 12:52 pts/1    00:00:00 grep --color=auto observer
[admin@ocp ~]$
[admin@ocp ~]$ mysql -h172.16.18.92 -uroot@sys -P2881 -p -c -A
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 2147549194
Server version: 5.6.25 OceanBase 1.4.60 (r1571952-758a58e85846f9efb907b1c14057204cb6353846) (Built Mar  9 2018 14:32:07)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> select version();
+-----------+
| version() |
+-----------+
| 1.4.60    |
+-----------+
1 row in set (0.00 sec)

MySQL [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| oceanbase          |
| information_schema |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.01 sec)

MySQL [(none)]> use oceanbase;
Database changed
MySQL [oceanbase]> select zone,svr_ip,svr_port,inner_port,with_rootserver,status,gmt_create from __all_server order by zone, svr_ip;
+--------+--------------+----------+------------+-----------------+--------+----------------------------+
| zone   | svr_ip       | svr_port | inner_port | with_rootserver | status | gmt_create                 |
+--------+--------------+----------+------------+-----------------+--------+----------------------------+
| ZONE_1 | 172.16.18.92 |     2882 |       2881 |               1 | active | 2020-08-11 15:22:22.965100 |
+--------+--------------+----------+------------+-----------------+--------+----------------------------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select tenant_id, tenant_name, zone_list, locality ,gmt_modified from __all_tenant;
+-----------+-------------+-----------+----------------+----------------------------+
| tenant_id | tenant_name | zone_list | locality       | gmt_modified               |
+-----------+-------------+-----------+----------------+----------------------------+
|         1 | sys         | ZONE_1    | FULL{1}@ZONE_1 | 2020-08-11 15:22:26.210787 |
+-----------+-------------+-----------+----------------+----------------------------+
1 row in set (0.00 sec)

MySQL [oceanbase]> select zone, svr_ip, svr_port,inner_port, cpu_total, cpu_assigned, 
    -> round(mem_total/1024/1024/1024) mem_total_gb, 
    -> round(mem_assigned/1024/1024/1024) mem_ass_gb, 
    -> round(disk_total/1024/1024/1024) disk_total_gb, 
    -> unit_num, substr(build_version,1,6) version
    -> from __all_virtual_server_stat
    -> order by zone, svr_ip, inner_port;
+--------+--------------+----------+------------+-----------+--------------+--------------+------------+---------------+----------+---------+
| zone   | svr_ip       | svr_port | inner_port | cpu_total | cpu_assigned | mem_total_gb | mem_ass_gb | disk_total_gb | unit_num | version |
+--------+--------------+----------+------------+-----------+--------------+--------------+------------+---------------+----------+---------+
| ZONE_1 | 172.16.18.92 |     2882 |       2881 |        14 |          2.5 |           20 |          5 |            28 |        1 | 1.4.60  |
+--------+--------------+----------+------------+-----------+--------------+--------------+------------+---------------+----------+---------+
1 row in set (0.01 sec)

MySQL [oceanbase]> 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) mem_free_gb, 
    -> round(disk_total/1024/1024/1024) disk_total_gb,
    -> substr(a.build_version,1,6) version,usec_to_time(b.start_service_time) start_service_time
    -> 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;
+--------+-------------------+-----------+----------+--------------+-------------+---------------+---------+----------------------------+
| zone   | observer          | cpu_total | cpu_free | mem_total_gb | mem_free_gb | disk_total_gb | version | start_service_time         |
+--------+-------------------+-----------+----------+--------------+-------------+---------------+---------+----------------------------+
| ZONE_1 | 172.16.18.92:2882 |        14 |     11.5 |           20 |          15 |            28 | 1.4.60  | 2020-08-11 15:22:29.594955 |
+--------+-------------------+-----------+----------+--------------+-------------+---------------+---------+----------------------------+
1 row in set (0.00 sec)

MySQL [oceanbase]> 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, 
    -> t3.unit_id, t3.zone, concat(t3.svr_ip,':',t3.`svr_port`) observer,t4.tenant_id, 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
    -> ;
+--------------------+------------------+---------+---------+------------+------------+---------+--------+-------------------+-----------+-------------+
| resource_pool_name | unit_config_name | max_cpu | min_cpu | max_mem_gb | min_mem_gb | unit_id | zone   | observer          | tenant_id | tenant_name |
+--------------------+------------------+---------+---------+------------+------------+---------+--------+-------------------+-----------+-------------+
| sys_pool           | sys_unit_config  |       5 |     2.5 |          6 |          5 |       1 | ZONE_1 | 172.16.18.92:2882 |         1 | sys         |
+--------------------+------------------+---------+---------+------------+------------+---------+--------+-------------------+-----------+-------------+
1 row in set (0.01 sec)

MySQL [oceanbase]> select unit_config_id,name,max_cpu,min_cpu,round(max_memory/1024/1024/1024) max_mem_gb, 
    -> round(min_memory/1024/1024/1024) min_mem_gb, round(max_disk_size/1024/1024/1024) max_disk_size_gb
    -> from __all_unit_config
    -> order by unit_config_id;
+----------------+-----------------+---------+---------+------------+------------+------------------+
| unit_config_id | name            | max_cpu | min_cpu | max_mem_gb | min_mem_gb | max_disk_size_gb |
+----------------+-----------------+---------+---------+------------+------------+------------------+
|              1 | sys_unit_config |       5 |     2.5 |          6 |          5 |               28 |
|           1001 | B_unit_config   |    0.25 |    0.25 |          1 |          1 |              120 |
|           1002 | S0_unit_config  |     0.5 |     0.5 |          2 |          2 |              500 |
|           1003 | S1_unit_config  |     1.5 |     1.5 |          6 |          6 |              500 |
|           1004 | S2_unit_config  |       3 |       3 |         12 |         12 |              500 |
|           1005 | S3_unit_config  |       6 |       6 |         20 |         20 |              500 |
|           1006 | S4_unit_config  |      12 |      12 |         40 |         40 |              500 |
+----------------+-----------------+---------+---------+------------+------------+------------------+
7 rows in set (0.00 sec)

MySQL [oceanbase]> 



OceanBase 1.4 版本的专题学习体验，到此结束。

一步一步学习OceanBase系列

接下来开始进行OceanBase 2.x版本的深入学习，慢慢倒腾倒腾。

下次实操继续更新~~~~~


复制