暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

OceanBase配置自动启停

原创 无远弗届 2022-04-01
1803

一、服务器规划

服务器名称 PROXY DB01 DB02 DB03
IP 192.168.113.5 192.168.113.51 192.168.113.52 192.168.113.53
OS RHEL7.8 RHEL7.8 RHEL7.8 RHEL7.8
CPU 1 2 2 2
内存 1 8 8 8
SSD 50G 50G 50G 50G
作用 OBD、OBP、OBC OBServer1 OBServer2 OBServer3

二、数据节点操作

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;
预期结果

image.png
image.png

最后修改时间:2022-04-05 15:06:35
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论