双节点,主节点kill掉数从节点怎么无法读取数据了

【 使用环境 】Kylin Linux Advanced Server V10 (Sword)
【 OB or 其他组件 】
【 使用版本 】OceanBase_CE 4.2.1.1 (r101000062023110109-7cb0fb494fce3962ae3f067991d6581c96bc0a9e)
【问题描述】双节点,主节点kill掉数从节点怎么无法读取数据了
obclient [oceanbase]> show databases;
ERROR 4012 (HY000): Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.

【复现路径】以下是obd配置文件
user:
username: admin
password: 123456
oceanbase-ce:
servers:
- name: master01
ip: 10.0.5.50
- name: slave01
ip: 10.0.5.100
global:
home_path: /u01/oceanbase/observer
data_dir: /u01/oceanbase/data
redo_dir: /u01/oceanbase/redo
# devname: eth0
mysql_port: 2881
rpc_port: 2882
obshell_port: 2886
zone: zone1
memory_limit: 24G
system_memory: 10G
datafile_size: 100G
log_disk_size: 32G
enable_syslog_wf: false
max_syslog_file_count: 4
obproxy-ce:
depends:
- oceanbase-ce
servers:
- name: master01
ip: 10.0.5.50
- name: slave01
ip: 10.0.5.100
global:
home_path: /u01/obproxy
enable_cluster_checkout: false
skip_proxy_sys_private_check: true
enable_strict_kernel_release: false
listen_port: 2883
prometheus_listen_port: 2884

1 个赞

根据报错提示先改一下ob_query_timeout这个参数的值试试

1 个赞

更改设置了也没用,双节点高可用直接要怎么部署有没有教程?

主备库搭建么?还是?

是的,我只想做一个像mysql主从一样的主备

博客搭建初体验 你可以参考看看

OceanBase 4.x单机构建主备初体验

OceanBase 社区z5j55e_gaMTUwMjI3NDUwMC4xNzI5NjY4OTMx_ga_T35KTM57DZ*MTczNTAxODc0NC4xMDcuMS4xNzM1MDIwNjkzLjEzLjAuMA…
官方文档 搭建

创建备租户前准备

https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000033892

建议升级 ob4.2.1.1也是很久的版本了 虽然是之前的LTS版本 目前425是LTS版本 建议升级到ob425版本