ubuntu安装oceanbase调通本地navicat链接

分为两部分

一安装oceanbase服务

准备工作

mkdir -p /data/1 /data/log1
chown -R admin.admin /data/1 /data/log1/

偷偷说：其实这步我忘记执行，也没影响我安装

oceanbase程序是很占内存的在安装时我们要先下载好安装包：
然后放在能记住的位置
安装包怎么下载地址：https://www.oceanbase.com/softwarecenter

版本没什么好说的 选择适合自己的就行 4.0及以后的安装更为方便
选择你喜欢的方式解压

tar -zxvf {你的压缩包路径}

解压好就会有一个 oceanbase-all-in-one进去后有个bin目录，里面有准备好的install.sh脚本

然后 运行它

./install.sh

注意路径


出现上图就说明成功了

然后找一个能记住的地址写进去一个config文件

这个文件内容可以复制官网的
也可以复制我的
我把我的配置分享在下面

## Only need to configure when remote login is required
#user:
# username: root
# password: oceanbase
#   key_file: your ssh-key file path if need
#   port: your ssh port, default 22
#   timeout: ssh connection timeout (second), default 30
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: /yuyou/oceanbase/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: 6G # 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: 8G # Size of the data file. 
    log_disk_size: 4G # The size of disk space used by the clog files.
    cpu_count: 16
    production_mode: false
    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.
    # observer cluster name, consistent with obproxy's cluster_name
    appname: obcluster
    # root_password: oceanbase
    # proxyro_password: # proxyro user pasword, consistent with obproxy's observer_sys_password, can be empty
obproxy-ce:
  # Set dependent components for the component.
  # When the associated configurations are not done, OBD will automatically get the these configurations from the dependent components.
  depends:
    - oceanbase-ce
  servers:
    - 127.0.0.1
  global:
    listen_port: 2883 # External port. The default value is 2883.
    prometheus_listen_port: 2884 # The Prometheus port. The default value is 2884.
    home_path: /yuyou/oceanbase/obproxy
    # oceanbase root server list
    # format: ip:mysql_port;ip:mysql_port. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.
    # rs_list: 192.168.1.2:2881
    enable_cluster_checkout: false
    # observer cluster name, consistent with oceanbase-ce's appname. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.
    # cluster_name: obcluster
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    # obproxy_sys_password: # obproxy sys user password, can be empty. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.
    # observer_sys_password: # proxyro user pasword, consistent with oceanbase-ce's proxyro_password, can be empty. When a depends exists, OBD gets this value from the oceanbase-ce of the depends.

前期安装比较重要的参数就是

datafile_size: 8G # Size of the data file. 
log_disk_size: 4G # The size of disk space used by the clog files.

这两个将决定你能不能安装成功
有个简单的运算方法
datafile_size + log_disk_size + 4 < 你系统剩余空间

可以使用

df -h

查看你自己的系统空间 系统空间时分区的 如：

看看你的区还有没有足够的空间

然后就可命令进行部署一个集群

obd cluster deploy obytt100 -c obytt100.yaml

如果不提醒你 系统空间不足 那就能安装成功

这就是安装成功的样子（obytt100 running）
然后可以进去看一下

obclient -h127.1 -P 2883 -uroot@sys#obytt100 -e "show databases"

第一次进会让你输入密码，这里直接回车就行了

第一部分安装就结束了

第二部分就是链接本地的navicat

第一次连的时候会提醒你密码错误，之前咱们已经在命令行进入oceanbase数据库了，先别退出

查看服务器里的初始数据库都是有什么
show databases；

进入mysql数据库，user表就在mysql数据库里
use mysql;

修改root的密码
ALTER USER root IDENTIFIED BY 'oceanbase';

直接修改就行了 然后再用navicat连上 完事。