暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / 「OceanBase 征文」Ubuntu 20.04.4 下快速体验Oceanbase 4.0（小鱼）

「OceanBase 征文」Ubuntu 20.04.4 下快速体验Oceanbase 4.0（小鱼）

原创 Arron 2023-03-17
550

Ubuntu 20.04.4 下快速体验Oceanbase 4.0（小鱼）

前言

Oceanbase 4.0 发布有段时间了。采用独特的单机&分布式一体化架构，能够跑着个人的PC机或树莓派上，对资源限制要求降低了很多。 前阶段由于工作上的事情耽搁，一直没时间体验，最近正好有空就来体验一把在单机上部署Oceanbase

参考文档：https://www.oceanbase.com/docs/community-observer-cn-10000000000901197

测试环境介绍

这里我测试使用的是虚拟机，资源配置如下

项目 描述
CPU 4核
内存 8G
磁盘 HDD
存储空间 100G
文件系统 ext4
操作系统 Ubuntu 20.04.4 LTS

对照官方文档，事先确认以下需要满足的条件

  • 2881 和 2882 端口没有被占用。
  • 机器可用内存不低于 6 G。
  • 机器 CPU 数目不低于 2。
  • 机器可用磁盘空间不小于 54 G。
  • 打开的文件句柄数量不小于 20000。

单机部署OceanBase

这里使用OBD方式进行部署

1. 下载并安装一键安装包 all-in-one package

  1. 在线安装：

执行下面的语句在线进行安装

root@mytest-1226:~# bash -c "$(curl -s https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/installer.sh)"       
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    27  100    27    0     0    369      0 --:--:-- --:--:-- --:--:--   369
info: downloading installer

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error is not recoverable: exiting now
oceanbase-all-in-one: command failed: tar -xvzf /tmp/tmp.ypHwuUlQhM/oceanbase-all-in-one.tar.gz -C /tmp/tmp.ypHwuUlQhM

在解压部分出现错误

root@mytest-1226:/tmp# cd /tmp/tmp.ypHwuUlQhM
root@mytest-1226:/tmp/tmp.ypHwuUlQhM# ll
total 12
drwx------  2 root root 4096 Mar 17 13:58 ./
drwxrwxrwt 15 root root 4096 Mar 17 13:58 ../
-rw-r--r--  1 root root  310 Mar 17 13:58 oceanbase-all-in-one.tar.gz
root@mytest-1226:/tmp/tmp.ypHwuUlQhM# tar zxvf oceanbase-all-in-one.tar.gz

gzip: stdin: not in gzip format
tar: Child returned status 1
tar: Error is not recoverable: exiting now

根据提示，进入文件临时下载目录，手动解压还是报错，估计可能该地址的压缩包存在问题

  1. 离线安装

从官网找到离线下载安装包的地址，使用wget下载

wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one-4.0.0.0-100120230113164218.el7.x86_64.tar.gz

tar zxvf  oceanbase-all-in-one-4.0.0.0-100120230113164218.el7.x86_64.tar.gz

手动解压成功。

进入目录，执行install.sh 安装脚本

cd oceanbase-all-in-one/
./install.sh

等待一段时间，出现下面的提示，表示安装成功

add auto set env logic to profile: /root/.bashrc

#####################################################################
 Install Finished 
=====================================================================
Setup Environment:     source ~/.oceanbase-all-in-one/bin/env.sh 
Quick Start:           obd demo 
More Details:          obd -h 
=====================================================================
  1. 测试obd命令

根据上面的安装提示，应用环境变量，执行obd命令，可以正常显示帮助信息

source ~/.oceanbase-all-in-one/bin/env.sh

root@mytest-1226:~# obd -h
Usage: obd <command> [options]

Available commands:

cluster        Deploy and manage a cluster.

demo           Quickly start

mirror         Manage a component repository for OBD.

repo           Manage local repository for OBD.

test           Run test for a running deployment.

update         Update OBD.


Options:
  --version      show program's version number and exit
  -h, --help     Show help and exit.
  -v, --verbose  Activate verbose output.

2. 使用obd demo快速部署单机体验环境

obd demo 部署方式采用最小规格部署，部署的组件版本默认为最新版本，默认部署的组件包含 oceanbase-ce、obproxy-ce、obagent、grafana、prometheus

root@mytest-1226:~# obd demo
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package obagent-1.2.0-4.el7 is available.
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package obproxy-ce-4.0.0-5.el7 is available.
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package grafana-7.5.17-1 is available.
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package prometheus-2.37.1-10000102022110211.el7 is available.
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package oceanbase-ce-4.0.0.0-103000022023011215.el7 is available.
install obagent-1.2.0 for local ok
install obproxy-ce-4.0.0 for local ok
install grafana-7.5.17 for local ok
install prometheus-2.37.1 for local ok
install oceanbase-ce-4.0.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obagent configuration ok
Generate obproxy configuration ok
Generate grafana configuration ok
Generate prometheus configuration ok
Generate observer configuration ok
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install obagent-1.2.0 for local ok
install obproxy-ce-4.0.0 for local ok
install grafana-7.5.17 for local ok
install prometheus-2.37.1 for local ok
install oceanbase-ce-4.0.0.0 for local ok
+--------------------------------------------------------------------------------------------+
|                                          Packages                                          |
+--------------+---------+------------------------+------------------------------------------+
| Repository   | Version | Release                | Md5                                      |
+--------------+---------+------------------------+------------------------------------------+
| obagent      | 1.2.0   | 4.el7                  | 0e8f5ee68c337ea28514c9f3f820ea546227fa7e |
| obproxy-ce   | 4.0.0   | 5.el7                  | de53232a951184fad75b15884458d85e31d2f6c3 |
| grafana      | 7.5.17  | 1                      | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| prometheus   | 2.37.1  | 10000102022110211.el7  | 58913c7606f05feb01bc1c6410346e5fc31cf263 |
| oceanbase-ce | 4.0.0.0 | 103000022023011215.el7 | 1d56dc742f5f05a2d15797d291b51a94019e728d |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Cluster status check ok
Initializes obagent work home ok
Initializes obproxy work home ok
Initializes grafana work home ok
Initializes prometheus work home ok
Initializes observer work home ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository install ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository lib check ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository install ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository lib check ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository install ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository lib check ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository install ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository lib check ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check !!
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
Package oceanbase-ce-libs-4.0.0.0-103000022023011215.el7 is available.
install oceanbase-ce-libs-4.0.0.0 for local ok
Remote oceanbase-ce-libs-4.0.0.0-103000022023011215.el7-ef48cff7633e3dbc39f5c0abdcd72348213e09a2 repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] (127.0.0.1) failed to get open files
[WARN] (127.0.0.1) failed to get max user processes
[WARN] OBD-2000: (127.0.0.1) not enough memory. (Free: 4.8G, Need: 6.0G)
[WARN] (127.0.0.1) clog and data use the same disk (/)

Check before start obagent ok
Check before start obproxy ok
Check before start prometheus ok
Check before start grafana ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster ok
Start obagent ok
obagent program health check ok
Start obproxy ok
obproxy program health check x
[WARN] failed to start 127.0.0.1 obproxy
[ERROR] obproxy-ce start failed
Wait for observer init ok
+---------------------------------------------+
|                   observer                  |
+-----------+---------+------+-------+--------+
| ip        | version | port | zone  | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

+-------------------------------------------------+
|                     obagent                     |
+-------------+-------------+------------+--------+
| ip          | server_port | pprof_port | status |
+-------------+-------------+------------+--------+
| 10.30.122.6 | 8088        | 8089       | active |
+-------------+-------------+------------+--------+
See https://www.oceanbase.com/product/ob-deployer/error-codes .

从输出的信息看，obproxy-ce启动失败

root@mytest-1226:~# netstat -ntlp|grep 2883
tcp        0      0 0.0.0.0:2883            0.0.0.0:*               LISTEN      57997/obproxy

对照文档，检查obproxy使用的端口，发现已经启动了 obproxy。

在逐一检测其他服务启动情况

root@mytest-1226:~# netstat -nltp|grep 2881
tcp        0      0 0.0.0.0:2881            0.0.0.0:*               LISTEN      57446/observer      
tcp        0      0 0.0.0.0:2881            0.0.0.0:*               LISTEN      57446/observer

observer 启动成功

root@mytest-1226:~# netstat -nltp|grep 8088
tcp6       0      0 :::8088                 :::*                    LISTEN      57974/monagent      
root@mytest-1226:~# netstat -nltp|grep 8089
tcp6       0      0 :::8089                 :::*                    LISTEN      57974/monagent

obagent 启动成功

root@mytest-1226:~# netstat -nltp|grep 9090

prometheus 启动失败

root@mytest-1226:~# netstat -nltp|grep 3000

grafana 启动失败

使用obclient通过observer端口（2881）登录数据库

root@mytest-1226:~# obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221487619
Server version: OceanBase_CE 4.0.0.0 (r103000022023011215-05bbad0279302d7274e1b5ab79323a2c915c1981) (Built Jan 12 2023 15:28:27)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

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

obclient [oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ORAAUDITOR         |
| SYS                |
| test               |
+--------------------+
7 rows in set (0.012 sec)

obclient [oceanbase]> quit

使用obclient通过obproxy端口（2883）登录数据库

root@mytest-1226:~# obclient -h127.0.0.1 -P2883 -uroot -Doceanbase -A 
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 1
Server version: OceanBase_CE 4.0.0.0 (r103000022023011215-05bbad0279302d7274e1b5ab79323a2c915c1981) (Built Jan 12 2023 15:28:27)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

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

obclient [oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ORAAUDITOR         |
| SYS                |
| test               |
+--------------------+
7 rows in set (0.015 sec)

能够正常登录OceanBase数据库，部署基本成功，可能因为单机资源有限，Promethus和Grafana启动失败

3. 使用obd demo 部署定制组件

  1. 先删除原有的部署
root@mytest-1226:~# obd cluster destroy demo -f
Get local repositories ok
Search plugins ok
Open ssh connection ok
Cluster status check ok
Search plugins ok
Stop obagent ok
Stop obproxy ok
Stop grafana ok
Stop prometheus ok
Stop observer ok
demo stopped
obagent work dir cleaning ok
obproxy work dir cleaning ok
grafana work dir cleaning ok
prometheus work dir cleaning ok
observer work dir cleaning ok
demo destroyed
  1. 指定部署oceanbase-ce,obproxy-ce,obagent 三个组件
root@mytest-1226:~# obd demo -c oceanbase-ce,obproxy-ce,obagent
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install obproxy-ce-4.0.0 for local ok
install obagent-1.2.0 for local ok
install oceanbase-ce-4.0.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate obagent configuration ok
Generate observer configuration ok
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install obproxy-ce-4.0.0 for local ok
install obagent-1.2.0 for local ok
install oceanbase-ce-4.0.0.0 for local ok
+--------------------------------------------------------------------------------------------+
|                                          Packages                                          |
+--------------+---------+------------------------+------------------------------------------+
| Repository   | Version | Release                | Md5                                      |
+--------------+---------+------------------------+------------------------------------------+
| obproxy-ce   | 4.0.0   | 5.el7                  | de53232a951184fad75b15884458d85e31d2f6c3 |
| obagent      | 1.2.0   | 4.el7                  | 0e8f5ee68c337ea28514c9f3f820ea546227fa7e |
| oceanbase-ce | 4.0.0.0 | 103000022023011215.el7 | 1d56dc742f5f05a2d15797d291b51a94019e728d |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Cluster status check ok
Initializes obproxy work home ok
Initializes obagent work home ok
Initializes observer work home ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository install ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository lib check ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository install ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository lib check ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check !!
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install oceanbase-ce-libs-4.0.0.0 for local ok
Remote oceanbase-ce-libs-4.0.0.0-103000022023011215.el7-ef48cff7633e3dbc39f5c0abdcd72348213e09a2 repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] (127.0.0.1) failed to get open files
[WARN] (127.0.0.1) failed to get max user processes
[WARN] OBD-2000: (127.0.0.1) not enough memory. (Free: 4.9G, Need: 6.0G)
[WARN] (127.0.0.1) clog and data use the same disk (/)

Check before start obproxy ok
Check before start obagent ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster ok
Start obproxy ok
obproxy program health check x
[WARN] failed to start 127.0.0.1 obproxy
[ERROR] obproxy-ce start failed
Wait for observer init ok
+---------------------------------------------+
|                   observer                  |
+-----------+---------+------+-------+--------+
| ip        | version | port | zone  | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

See https://www.oceanbase.com/product/ob-deployer/error-codes .

同样还是出现obproxy-ce的启动报错

4. 自定义配置文件进行单机部署

  1. 编辑配置文件
    默认的配置文件都在 ~/.oceanbase-all-in-one/conf/ 下，这里由于机器资源限制，以本地最小部署模版 mini-local-example.yaml为基础进行适当调整
cp ~/.oceanbase-all-in-one/conf/mini-local-example.yaml ~/my-mini.yaml

root@mytest-1226:~# cat my-mini.yaml
oceanbase-ce:
  servers:
    # Please don't use hostname, only IP can be supported
    - 127.0.0.1
  global:
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /root/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
    # 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: lo
    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.
    zone: zone1
    cluster_id: 1
    # please set memory limit to a suitable value which is matching resource. 
    memory_limit: 4G # The maximum running memory for an observer
    system_memory: 1G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
    datafile_size: 5G # Size of the data file. 
    log_disk_size: 5G # The size of disk space used by the clog files.
    cpu_count: 4
    production_mode: true
    syslog_level: INFO # 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: 4 # The maximum number of reserved log files before enabling auto recycling. The default value is 0.
    # root_password: # root user password, can be empty

这里主要修改ip，memory_limit, datafile_size, log_disk_size 几个参数，以满足本人的机器资源

  1. 执行obd cluster autodeploy命令初始化集群
root@mytest-1226:~# obd cluster autodeploy myob -c my-mini.yaml
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install oceanbase-ce-4.0.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate observer configuration ok
[WARN] (127.0.0.1): automatically adjust the cpu_count 16

[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install oceanbase-ce-4.0.0.0 for local ok
+--------------------------------------------------------------------------------------------+
|                                          Packages                                          |
+--------------+---------+------------------------+------------------------------------------+
| Repository   | Version | Release                | Md5                                      |
+--------------+---------+------------------------+------------------------------------------+
| oceanbase-ce | 4.0.0.0 | 103000022023011215.el7 | 1d56dc742f5f05a2d15797d291b51a94019e728d |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Cluster status check ok
Initializes observer work home ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check !!
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
install oceanbase-ce-libs-4.0.0.0 for local ok
Remote oceanbase-ce-libs-4.0.0.0-103000022023011215.el7-ef48cff7633e3dbc39f5c0abdcd72348213e09a2 repository install ok
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check ok
myob deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] (127.0.0.1) failed to get open files
[WARN] (127.0.0.1) failed to get max user processes
[WARN] (127.0.0.1) clog and data use the same disk (/)

Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster ok
Wait for observer init ok
+---------------------------------------------+
|                   observer                  |
+-----------+---------+------+-------+--------+
| ip        | version | port | zone  | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

myob running
  1. 使用obclient 登陆验证
root@mytest-1226:~# obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221487622
Server version: OceanBase_CE 4.0.0.0 (r103000022023011215-05bbad0279302d7274e1b5ab79323a2c915c1981) (Built Jan 12 2023 15:28:27)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

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

obclient [oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ORAAUDITOR         |
| SYS                |
| test               |
+--------------------+
7 rows in set (0.052 sec)
  1. 使用mysql客户端登录验证
root@mytest-1226:~# mysql -h127.0.0.1 -P2881 -uroot -Doceanbase -A
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3221487624
Server version: 5.7.25 OceanBase_CE 4.0.0.0 (r103000022023011215-05bbad0279302d7274e1b5ab79323a2c915c1981) (Built Jan 12 2023 15:28:27)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ORAAUDITOR         |
| SYS                |
| test               |
+--------------------+
7 rows in set (0.02 sec)

本机OceanBase单实例部署成功

总结

  1. 4.0 版本的OBD工具，自动化安装所有工具，简化了部署流程，同时又提供了一定的组件配置，调整的能力，为OB工程师的辛苦付出点赞
  2. 4.0 版本大大降低了使用OB的资源限制门槛，让像我这种资源有限的小伙伴，能够在个人PC上体验一把OB产品的功能，这对于OB的推广和发展大大有益
  3. 在测试过程中也出现了一些问题
    • 在线安装方式报错，不能使用
    • demo集群安装，总是出现obproxy不能启动的报错，但实际上已经启动，有点懵
墨力计划oceanbase征文oceanbase 社区版oceanbase墨力原创作者计划
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论