OceanBase配置自动启停

一、服务器规划

二、数据节点操作

1、布置脚本

节点1

su - admin
cat > /home/admin/oceanbase/bin/dbstart
cd ~/oceanbase && bin/observer -i ens33 -p 2881 -P 2882 -z zone1 -d ~/oceanbase/store/obdemo -r \
'192.168.113.51:2882:2881;192.168.113.52:2882:2881;192.168.113.53:2882:2881' -c 20211224 -n obdemo -o \
"memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G, \
memory_chunk_cache_size=128M,cpu_count=16,net_thread_count=4,datafile_size=10G,stack_size=1536K,syslog_level=ERROR, \
config_additional_dir=/obdata/obdemo/etc3;/oblog/obdemo/etc2"

节点2

su - admin
cat > /home/admin/oceanbase/bin/dbstart
cd ~/oceanbase && bin/observer -i ens33 -p 2881 -P 2882 -z zone2 -d ~/oceanbase/store/obdemo -r \
'192.168.113.51:2882:2881;192.168.113.52:2882:2881;192.168.113.53:2882:2881' -c 20211224 -n obdemo -o \
"memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G, \
memory_chunk_cache_size=128M,cpu_count=16,net_thread_count=4,datafile_size=10G,stack_size=1536K,syslog_level=ERROR, \
config_additional_dir=/obdata/obdemo/etc3;/oblog/obdemo/etc2"

节点3

su - admin
cat > /home/admin/oceanbase/bin/dbstart
cd ~/oceanbase && bin/observer -i ens33 -p 2881 -P 2882 -z zone3 -d ~/oceanbase/store/obdemo -r \
'192.168.113.51:2882:2881;192.168.113.52:2882:2881;192.168.113.53:2882:2881' -c 20211224 -n obdemo -o \
"memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=3G, \
memory_chunk_cache_size=128M,cpu_count=16,net_thread_count=4,datafile_size=10G,stack_size=1536K,syslog_level=ERROR, \
config_additional_dir=/obdata/obdemo/etc3;/oblog/obdemo/etc2"

所有节点

su - admin
cat > /home/admin/oceanbase/bin/dbstop
kill  `pidof observer`

chmod u+x /home/admin/oceanbase/bin/dbstart
chmod u+x /home/admin/oceanbase/bin/dbstop

2、布置系统服务

所有节点

su - root
cat > /etc/init.d/oceanbase
#!/bin/sh
# chkconfig: 35 80 10
# description: Oceanbase auto start-stop script.

OB_HOME=/home/admin/oceanbase/
OB_OWNER=admin

case $1 in

start)
# Start the Oceanbase:
echo "-------------------------------------------------" >> /var/log/admin
date +" 20%y-%m-%d %T : Starting Oceanbase as part of system up." >> /var/log/admin
echo "-------------------------------------------------" >> /var/log/admin
su - $OB_OWNER -c "$OB_HOME/bin/dbstart" >>/var/log/admin
;;

stop)
# Stop the Oceanbase:
echo "-------------------------------------------------" >> /var/log/admin
date +" 20%y-%m-%d %T : Stoping Oceanbase as part of system down." >> /var/log/admin
echo "-------------------------------------------------" >> /var/log/admin
su - $OB_OWNER -c "$OB_HOME/bin/dbstop" >>/var/log/admin
;;

check)
ps -ef | grep observer | grep -v grep
;;

restart)
$0 stop
$0 start
;;
esac

改变权限与添加服务

chmod 755 /etc/init.d/oceanbase
chkconfig --level 35 oceanbase on

检查状态

chkconfig --list

Oceanbase       0:off   1:off   2:off   3:on    4:off   5:on    6:off

使用方法

systemctl daemon-reload
systemctl start oceanbase
systemctl stop oceanbase
systemctl check oceanbase

三、代理节点操作

1、布置脚本

所有节点

su - admin
cat > /home/admin/obproxy-3.2.0/bin/proxystart
cd ~/obproxy-3.2.0/ && bin/obproxy -r "192.168.113.51:2881;192.168.113.52:2881;192.168.113.53:2881" \
-p 2883 -o "enable_strict_kernel_release=false,enable_cluster_checkout=false,enable_metadb_used=false" -c obdemo

cat > /home/admin/obproxy-3.2.0/bin/proxystop
kill  `pidof obproxy`

chmod u+x /home/admin/obproxy-3.2.0/bin/proxystart
chmod u+x /home/admin/obproxy-3.2.0/bin/proxystop

2、布置系统服务

所有节点

su - root
cat > /etc/init.d/proxy
#!/bin/sh
# chkconfig: 35 80 10
# description: Oceanbase auto start-stop script.

OB_HOME=/home/admin/obproxy-3.2.0
OB_OWNER=admin

case $1 in

start)
# Start the Proxy:
echo "-------------------------------------------------" >> /var/log/admin
date +" 20%y-%m-%d %T : Starting Proxy as part of system up." >> /var/log/admin
echo "-------------------------------------------------" >> /var/log/admin
su - $OB_OWNER -c "$OB_HOME/bin/proxystart" >>/var/log/admin
;;

stop)
echo "Stoping Proxy ... "
echo "-------------------------------------------------" >> /var/log/admin
date +" 20%y-%m-%d %T : Stoping Proxy as part of system down." >> /var/log/admin
echo "-------------------------------------------------" >> /var/log/admin
su - $OB_OWNER -c "$OB_HOME/bin/proxystop" >>/var/log/admin
;;

check)
ps -ef | grep obproxy | grep -v grep
;;

restart)
$0 stop
$0 start
;;
esac

改变权限与添加服务

chmod 755 /etc/init.d/proxy
chkconfig --level 35 proxy on

检查状态

chkconfig --list

Proxy           0:off   1:off   2:off   3:on    4:off   5:on    6:off

使用方法

systemctl daemon-reload
systemctl start proxy
systemctl stop proxy
systemctl check proxy

检查集群

su - admin
mysql -h 192.168.113.51 -u root -P 2881 -p -c -A

use oceanbase;
select a.zone,concat(a.svr_ip,':',a.svr_port) observer, 
 usec_to_time(b.start_service_time) start_service_time, b.status
from __all_virtual_server_stat a join __all_server b 
on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port) 
order by a.zone, a.svr_ip;

预期结果