本次主要测试obd工具部署ob集群,测试表明该工具非常好用,极大简化了安装部署工作,非常赞!
以下为主要安装部署工作介绍,省略了一些环境初始化及安装包下载上传安装的工作。
一 环境介绍
加上obd服务器共4台服务器,一台为windows环境的wsl环境,用作obd服务器,另外三台为observer节点。
三台observer服务器配置比较低,均为8c16g。
安装目录创建:mkdir /home/observer/{home,data,obproxy}
二 略去环境初始化、安装包下载上传及安装工作。
三 obd部署的配置文件
在obd服务器上哈,需提前安装obd程序,其他准备工作不表。
[root@WINDOWS-M9TAO22 ~]# cat obdep_ob_obproxy.yaml
oceanbase-ce:
servers:
- name: server1
# Please don't use hostname, only IP can be supported
ip: 10.20.148.118
- name: server2
ip: 10.20.148.119
- name: server3
ip: 10.20.148.120
global:
devname: ens192
cluster_id: 1
memory_limit: 8G
system_memory: 4G
stack_size: 512K
cpu_count: 16
cache_wash_threshold: 1G
__min_full_resource_pool_memory: 268435456
workers_per_cpu_quota: 10
schema_history_expire_time: 1d
net_thread_count: 4
major_freeze_duty_time: Disable
minor_freeze_times: 10
enable_separate_sys_clog: 0
enable_merge_by_turn: FALSE
datafile_disk_percentage: 20
syslog_level: INFO
enable_syslog_wf: false
enable_syslog_recycle: true
max_syslog_file_count: 4
appname: obcluster
server1:
mysql_port: 2881
rpc_port: 2882
home_path: /home/observer/home
# data_dir: /home/observer/data
# redo_dir: /home/observer/redo
zone: zone1
server2:
mysql_port: 2881
rpc_port: 2882
home_path: /home/observer/home
# data_dir: /home/observer/data
# redo_dir: /home/observer/redo
zone: zone2
server3:
mysql_port: 2881
rpc_port: 2882
home_path: /home/observer/home
# data_dir: /home/observer/data
# redo_dir: /home/observer/redo
zone: zone3
obproxy:
depends:
- oceanbase-ce
servers:
- 10.20.148.118
global:
listen_port: 2883
prometheus_listen_port: 2884
home_path: /home/observer/obproxy
enable_cluster_checkout: false
# cluster_name: obcluster
skip_proxy_sys_private_check: true
四 使用obd部署ob集群
在obd服务器上。
[root@WINDOWS-M9TAO22 ~]# obd cluster autodeploy obtest -c obdep_ob_obproxy.yaml
oceanbase-ce-3.1.2 already installed.
obproxy-3.2.0 already installed.
Cluster param config check ok
Open ssh connection ok
Generate observer configuration ok
Generate obproxy configuration ok
oceanbase-ce-3.1.2 already installed.
obproxy-3.2.0 already installed.
+-------------------------------------------------------------------------------------------+
| Packages |
+--------------+---------+-----------------------+------------------------------------------+
| Repository | Version | Release | Md5 |
+--------------+---------+-----------------------+------------------------------------------+
| oceanbase-ce | 3.1.2 | 10000392021123010.el7 | 7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed |
| obproxy | 3.2.0 | 1.el7 | 8d5c6978f988935dc3da1dbec208914668dcf3b2 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote oceanbase-ce-3.1.2-7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed repository install ok
Remote oceanbase-ce-3.1.2-7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed repository lib check ok
Remote obproxy-3.2.0-8d5c6978f988935dc3da1dbec208914668dcf3b2 repository install ok
Remote obproxy-3.2.0-8d5c6978f988935dc3da1dbec208914668dcf3b2 repository lib check ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
obtest deployed
Get local repositories and plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (10.20.148.118) clog and data use the same disk (/home)
[WARN] (10.20.148.119) clog and data use the same disk (/home)
[WARN] (10.20.148.120) clog and data use the same disk (/home)
Check before start obproxy ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster
Cluster bootstrap ok
Wait for observer init ok
+-------------------------------------------------+
| observer |
+---------------+---------+------+-------+--------+
| ip | version | port | zone | status |
+---------------+---------+------+-------+--------+
| 10.20.148.118 | 3.1.2 | 2881 | zone1 | active |
| 10.20.148.119 | 3.1.2 | 2881 | zone2 | active |
| 10.20.148.120 | 3.1.2 | 2881 | zone3 | active |
+---------------+---------+------+-------+--------+
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize cluster
+-------------------------------------------------+
| obproxy |
+---------------+------+-----------------+--------+
| ip | port | prometheus_port | status |
+---------------+------+-----------------+--------+
| 10.20.148.118 | 2883 | 2884 | active |
+---------------+------+-----------------+--------+
obtest running
五 使用obd查看集群
[root@WINDOWS-M9TAO22 ~]# obd cluster list
+------------------------------------------------------+
| Cluster List |
+--------+---------------------------+-----------------+
| Name | Configuration Path | Status (Cached) |
+--------+---------------------------+-----------------+
| obtest | /root/.obd/cluster/obtest | running |
+--------+---------------------------+-----------------+
[root@WINDOWS-M9TAO22 ~]#
六 使用obclient连接ob集群
[root@WINDOWS-M9TAO22 ~]# obclient -h10.20.148.118 -P2883 -uroot -p
Enter password:
Welcome to OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3
Server version: OceanBase 3.1.2 (r10000392021123010-d4ace121deae5b81d8f0b40afbc4c02705b7fc1d) (Built Dec 30 2021 02:47:29)
Copyright (c) 2000, 2020, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root_(none)_2883> alter user 'root'@'%' identified by '123456';
Query OK, 0 rows affected (0.03 sec)
root_(none)_2883>
因字数限制,仅能写这么多,剩余内容见评论。