本次主要测试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>
因字数限制,仅能写这么多,剩余内容见评论。