【产品名称】 3节点observer
【产品版本】 2.2.76
【问题描述】3节点OB集群bootstrap一直不成功
1:现象
运行了50分时还未有结果。
MySQL [(none)]> set session ob_query_timeout=36000000000;
set session ob_trx_timeout=36000000000;Query OK, 0 rows affected (0.00 sec)
MySQL [(none)]> set session ob_trx_timeout=36000000000;
Query OK, 0 rows affected (0.00 sec)
MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]> alter system bootstrap zone ‘zone1’ server ‘10.10.10.160:2882’, zone ‘zone2’ server ‘10.10.10.161:2882’, zone ‘zone3’ server ‘10.10.10.162:2882’;
2,信息收集
grep ERROR observer.log*
未发现有ERROR的错误。
dstat 3台服务器,资源使用率都很多。
3,操作不走
分别在三台服务器上执行
mkdir -p /data/1/htzob/{etc3,sort_dir,sstable}
mkdir -p /data/log1/htzob/{clog,etc2,ilog,slog,oob_clog}
mkdir -p /home/admin/oceanbase/store/htzob
for t in {etc3,sort_dir,sstable};do ln -s /data/1/htzob/$t /home/admin/oceanbase/store/htzob/$t; done
for t in {clog,etc2,ilog,slog,oob_clog};do ln -s /data/log1/htzob/$t /home/admin/oceanbase/store/htzob/$t; done
分别执行下面命令;
节点1
cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i ens192 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/htzob -r ‘10.10.10.160:2882:2881;10.10.10.161:2882:2881;10.10.10.162:2882:2881’ -n htzob -o “cpu_count=6,memory_limit=16G,datafile_disk_percentage=50,cluster_id=100001,config_additional_dir=/data/1/htzob/etc3;/data/log1/htzob/etc2,__min_full_resource_pool_memory=1073741824,_ob_enable_prepared_statement=false,memory_limit_percentage=90,system_memory=10G”
节点2
cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i ens192 -P 2882 -p 2881 -z zone2 -d /home/admin/oceanbase/store/htzob -r ‘10.10.10.160:2882:2881;10.10.10.161:2882:2881;10.10.10.162:2882:2881’ -n htzob -o “cpu_count=6,memory_limit=16G,datafile_disk_percentage=50,cluster_id=100001,config_additional_dir=/data/1/htzob/etc3;/data/log1/htzob/etc2,__min_full_resource_pool_memory=1073741824,_ob_enable_prepared_statement=false,memory_limit_percentage=90,system_memory=10G”
节点3
cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i ens192 -P 2882 -p 2881 -z zone3 -d /home/admin/oceanbase/store/htzob -r ‘10.10.10.160:2882:2881;10.10.10.161:2882:2881;10.10.10.162:2882:2881’ -n htzob -o “cpu_count=6,memory_limit=16G,datafile_disk_percentage=50,cluster_id=100001,config_additional_dir=/data/1/htzob/etc3;/data/log1/htzob/etc2,__min_full_resource_pool_memory=1073741824,_ob_enable_prepared_statement=false,memory_limit_percentage=90,system_memory=10G”