OB 4.0 发布了,我帮大家划了一下重点,兄弟们,可以开始测试了啊

2 个赞

感谢阿福老师,打call :tada: :tada: :confetti_ball: :confetti_ball:

安装时报错,我是用的3.1.4的配置文件(安装3.1.4是可以成功的),报错如下:

observer.log:

配置文件如下:

## Only need to configure when remote login is required
#user:
#  username: admin
#  password: admin
#   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:
    - name: server1
      # Please don't use hostname, only IP can be supported
      ip: 192.168.31.201
    - name: server2
      ip: 192.168.31.202
    - name: server3
      ip: 192.168.31.203
  global:
    # 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: ens160
    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: 3G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
    stack_size: 512K
    cpu_count: 16
    cache_wash_threshold: 1G
    __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: 4
    major_freeze_duty_time: Disable
    minor_freeze_times: 10
    enable_separate_sys_clog: 0
    enable_merge_by_turn: FALSE
    datafile_disk_percentage: 20 # The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.
    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: # root user password, can be empty
  server1:
    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.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /home/admin/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
    zone: zone1
  server2:
    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.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /home/admin/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
    zone: zone2
  server3:
    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.
    #  The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
    home_path: /home/admin/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
    zone: zone3

看打印的信息OB版本已经是4.0.0.0。说明这是个在线部署,由于yaml里没有指定版本,OBD自动去镜像源获取了最新版本。如果依旧想要使用3.1.4,可以在yaml加上version: 3.1.4(参考https://github.com/oceanbase/obdeploy/tree/master/example/oceanbase-3.x)

也可以换用https://github.com/oceanbase/obdeploy/tree/master/example 的配置,直接使用OB 4.0

老师您体验的话,参考一下这个帖子:OceanBase 4.0 all-in-one 版本快速尝鲜安装步骤

我现在还不知道新版本用老版本的 obd 和配置文件行不行,测试中~

感谢阿福老师!

1 个赞

今晚试了一下,使用 3.1.4 的配置文件和 obd 是可以的,自动检测到最新版本的 observer obproxy 和 lib 然后安装成功了。您可以再多尝试一下。

268435456 这个值设的太小了,调大点就行了,内部执行的时候也是调不到这么低的

mysql> alter system __min_full_resource_pool_memory = 268435456;
ERROR 4147 (HY000): Invalid config
mysql>
mysql> alter system __min_full_resource_pool_memory = 2147483648;
Query OK, 0 rows affected (0.03 sec)

1 个赞

:+1::+1::+1::+1::+1: