实验二手动部署oceanbase

实验二、手动部署 OceanBase 集群(三节点)

手动部署三节点oceanbase

服务器信息：

zone1：192.168.56.160 2881 2882

zone2：192.168.56.161 2881 2882

zone3：192.168.56.162 2881 2882

操作系统版本

内存

初始化服务器环境

内核参数修改

vim /etc/sysctl.conf

net.core.somaxconn = 2048

net.core.netdev_max_backlog = 10000

net.core.rmem_default = 16777216

net.core.wmem_default = 16777216

net.core.rmem_max = 16777216

net.core.wmem_max = 16777216

net.ipv4.ip_local_port_range = 3500 65535

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

net.ipv4.tcp_syncookies = 0

net.ipv4.tcp_rmem = 4096 87380 16777216

net.ipv4.tcp_wmem = 4096 65536 16777216

net.ipv4.tcp_max_syn_backlog = 16384

net.ipv4.tcp_fin_timeout = 15

net.ipv4.tcp_max_syn_backlog = 16384

net.ipv4.tcp_tw_reuse = 1

net.ipv4.tcp_tw_recycle = 1

net.ipv4.tcp_slow_start_after_idle=0

vm.swappiness = 0

vm.min_free_kbytes = 2097152

vm.max_map_count=655360

fs.aio-max-nr=1048576

sysctl –p

修改会话变量

关闭防火墙和selinux

systemctl status firewalld

systemctl disable firewalld

systemctl stop firewalld

systemctl status firewalld

grep SELINUX /etc/selinux/config

配置时间同步服务

systemctl status ntpd

systemctl disable ntpd

systemctl stop ntpd

yum -y install chrony

systemctl enable chronyd

systemctl start chronyd

systemctl status chronyd

配置安装用户

useradd admin

passwd admin

id admin

下载软件

https://www.oceanbase.com/softwareCenter/community

obproxy-ce-3.2.3-2.el7.x86_64.rpm

obclient-2.0.1-2.el7.x86_64

oceanbase-ce-libs-3.1.3-10000292022032916.el7.x86_64.rpm

oceanbase-ce-3.1.3-10000292022032916.el7.x86_64.rpm。

创建运行目录

mkdir /obdata

mkdir /obredo

chown –R admin.admin /obdata

chown –R admin.admin /obredo

su - admin

mkdir -p ~/oceanbase/store/obdemo /obdata/obdemo/{sstable,etc3} /obredo/obdemo/{clog,ilog,slog,etc2}

for f in {clog,ilog,slog,etc2}; do ln -s /obredo/obdemo/$f ~/oceanbase/store/obdemo/$f ; done

for f in {sstable,etc3}; do ln -s /obdata/obdemo/$f ~/oceanbase/store/obdemo/$f; done

配置admin环境变量

集群配置和启动

启动observer

192.168.56.160

cd ~/oceanbase && bin/observer -i enp0s8 -p 2881 -P 2882 -z zone1 -d ~/oceanbase/store/obdemo -r '192.168.56.160:2882:2881' -c 20220322 -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=4,net_thread_count=4,datafile_size=5G,stack_size=1536K,config_additional_dir=/obdata/obdemo/etc3;/obredo/obdemo/etc2" -d ~/oceanbase/store/obdemo

检查节点启动情况

netstat -antlp |grep 288 |grep LISTEN

集群初始化

mysql -h 192.168.56.160 -u root -P 2881 -p -c -A

set session ob_query_timeout=1000000000; alter system bootstrap ZONE 'zone1' SERVER '192.168.56.160:2882';

检查集群状态
mysql -h 192.168.56.160 -u root@sys -P 2881 -p -c -A oceanbase

设置密码

设置proxy

启动proxy

cd ~/obproxy-3.2.3/ && bin/obproxy -r "192.168.56.160:2881" -p 2883 -o "enable_strict_kernel_release=false,enable_cluster_checkout=false,enable_metadb_used=false" -c obdemo

登录proxy并修改密码

mysql -h 192.168.56.160 -u root@proxysys -P 2883 –p

登录proxy检查部署情况

创建业务租户，数据库，表

查看基础信息

资源使用情况

select a.zone,concat(a.svr_ip,':',a.svr_port) observer, cpu_total, (cpu_total-cpu_assigned) cpu_free,

round(mem_total/1024/1024/1024) mem_total_gb, round((mem_total-mem_assigned)/1024/1024/1024) mem_free_gb,

round(disk_total/1024/1024/1024) disk_total_gb,

substr(a.build_version,1,6) version,usec_to_time(b.start_service_time) start_service_time

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;

select t1.name resource_pool_name, t2.`name` unit_config_name, t2.max_cpu, t2.min_cpu,

round(t2.max_memory/1024/1024/1024) max_mem_gb, round(t2.min_memory/1024/1024/1024) min_mem_gb,

t3.unit_id, t3.zone, concat(t3.svr_ip,':',t3.`svr_port`) observer,t4.tenant_id, t4.tenant_name

from __all_resource_pool t1 join __all_unit_config t2 on (t1.unit_config_id=t2.unit_config_id)

join __all_unit t3 on (t1.`resource_pool_id` = t3.`resource_pool_id`)

left join __all_tenant t4 on (t1.tenant_id=t4.tenant_id)

order by t1.`resource_pool_id`, t2.`unit_config_id`, t3.unit_id

;

创建资源单元

create resource unit my_test_unit max_cpu=1, min_cpu=1, max_memory='1G', min_memory='1G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='10G';

创建资源池

创建租户

登录租户

创建业务数据库和表