oceanbase社区版能否提供一个安装教程?

【产品名称】OceanBase Database

【产品版本】3.1.0

【问题描述】能否提供下社区版OceanBase Database的安装文档?

OceanBase 开源  请参考这个链接


OceanBase 开源  安装部署可以参考这个文档

这个单机版版本的:

总结:Mac:使用 OBD 部署 OceanBase 数据库

参考文档:https://github.com/oceanbase/obdeploy

预备知识:

  • OceanBase 不支持mac,使用docker
  • obd是安装工具,不需要重现编译源码(定制版本除外)
  • 单机 本地安装不需要配上ssh 密码登陆 配置文件
  • 对内存和cpu都要要求,满足最低配置 mini-local-example.yaml 执行不会报错。 需要结合日志和代码解决。

环境准备:

  • 系统环境配置: memory_limit cannot be less than 8G
问题:
[WARN] (127.0.0.1) fs.aio-max-nr must not be less than 1048576 (Current value: 65536)
[WARN] (127.0.0.1) open files number must not be less than 655350 (Current value: 1024)
[WARN] (127.0.0.1) not enough memory
​
办法:
vi /etc/security/limits.conf
*  soft nofile  655360
*  hard nofile  655360
* soft nproc 655360
* hard nproc 655360
​
vi /etc/sysctl.conf
fs.file-max = 655360
fs.aio-max-nr=1048576
​
sysctl -p//生效
ulimit -a //新窗口查看结果
​
  • mini-local-example.yaml 变量 里面配置是最低配置,不能修改
[root@56bd78306b21 data]# obd cluster edit-config obtest
oceanbase-ce:
 servers:
  # Please don't use hostname, only IP can be supported
 - 127.0.0.1
 global:
 home_path: /root/data/observer
  # 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
 rpc_port: 2882
 zone: zone1
 cluster_id: 1
  # please set memory limit to a suitable value which is matching resource.
 memory_limit: 8G //不能修改,至少不多 
 system_memory: 4G //不能修改,至少不多
 stack_size: 512K //不能修改,至少不多
 cpu_count: 6
 cache_wash_threshold: 500M
 __min_full_resource_pool_memory: 268435456 //不能修改,至少不多
 workers_per_cpu_quota: 10
 schema_history_expire_time: 1d
  # The value of net_thread_count had better be same as cpu's core number.
 net_thread_count: 2
 sys_bkgd_migration_retry_num: 3
 minor_freeze_times: 10
 enable_separate_sys_clog: 0
 enable_merge_by_turn: FALSE
 datafile_disk_percentage: 20
 syslog_level: INFO
 enable_syslog_recycle: true
 max_syslog_file_count: 1
​

安装部署

docker update --memory 8G --memory-swap -1 56bd78306b21
docker run -itd --name oceanbase --privileged centos /bin/bash
docker start 56bd78306b21 
docker attach 56bd78306b21 //进入容器
​
​
obd cluster destroy obtest
obd cluster deploy obtest -c /root/data/mini-local-example.yaml 
​
obd cluster edit-config obtest
obd cluster redeploy obtest
obd cluster display obtest
​
obd cluster start obtest