簡介

obproxy 屬于OceanBase的代理，生產(chǎn)環(huán)境中 OceanBase 數(shù)據(jù)庫的數(shù)據(jù) 會以 多副本的形式 存放在各個 OBServer 節(jié)點上，obproxy 接收用戶發(fā)出的 SQL 請求，并將 SQL 請求轉(zhuǎn)發(fā)至最佳目標 OBServer 節(jié)點，最后將執(zhí)行結(jié)果返回給用戶，該工具一般部署在observer所在的服務器上。

查看obproxy信息(查看進程)

可以看出當前只有一臺 obproxy, 端口號為2883，目錄在 /opt/myoceanbase/obproxy

[root@rac1 ~]# ps -ef | grep obproxy
root      7780     1  0 May16 ?        00:44:14 bash /opt/myoceanbase/obproxy/obproxyd.sh /opt/myoceanbase/obproxy 10.0.0.197 2883 daemon
root      7798     1  4 May16 ?        10:21:01 /opt/myoceanbase/obproxy/bin/obproxy --listen_port 2883
root      9646 23753  0 22:49 pts/5    00:00:00 grep --color=auto obproxy
[root@rac1 ~]#

安裝目錄

通過查看 obproxy 進程運行狀態(tài)得出 obproxy 安裝目錄是 /opt/myoceanbase/obproxy

進入安裝目錄

可以看到在安裝目錄下 存在 obproxy 自身的一些文件和目錄信息: 日志目錄log, 進程id目錄run, 配置目錄etc, 守護進程 obproxyd.sh

[root@rac1 ~]# cd /opt/myoceanbase/obproxy
[root@rac1 obproxy]# ll
total 8
drwxr-xr-x 2 root root   21 May 16 15:50 bin
drwxr-xr-x 2 root root    6 May 16 15:51 control-config
drwxr-xr-x 2 root root   87 May 16 15:52 etc
drwxr-xr-x 2 root root    6 May 16 15:50 lib
drwxr-xr-x 2 root root 4096 May 24 20:55 log
-rw-r--r-- 1 root root  910 May 16 15:52 obproxyd.sh
drwxr-xr-x 2 root root   77 May 16 15:52 run
drwxr-xr-x 2 root root    6 May 16 15:51 sharding-config
[root@rac1 obproxy]#
[root@rac1 obproxy]#
[root@rac1 obproxy]#
[root@rac1 obproxy]# cd log/
[root@rac1 log]# ll
total 1070184
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_client.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_config.log
-rw-r--r-- 1 root root    216074 May 25 20:44 obproxy_diagnosis.log
-rw-r--r-- 1 root root  12666499 May 26 22:53 obproxy_digest.log
-rw-r--r-- 1 root root   5788538 May 26 22:49 obproxy_error.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_limit.log
-rw-r--r-- 1 root root 133943000 May 26 22:53 obproxy.log
-rw-r--r-- 1 root root 268435584 May 21 21:00 obproxy.log.20240521210000
-rw-r--r-- 1 root root 268435619 May 24 04:54 obproxy.log.20240524045423
-rw-r--r-- 1 root root 268435458 May 24 20:55 obproxy.log.20240524205514
-rw-r--r-- 1 root root  11980562 May 26 22:53 obproxy.log.wf
-rw-r--r-- 1 root root  24386318 May 21 21:00 obproxy.log.wf.20240521210000
-rw-r--r-- 1 root root  17694250 May 24 04:54 obproxy.log.wf.20240524045423
-rw-r--r-- 1 root root  13785772 May 24 20:55 obproxy.log.wf.20240524205514
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_pool.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_pool_stat.log
-rw-r--r-- 1 root root   4657094 May 26 22:53 obproxy_slow.log
-rw-r--r-- 1 root root  15866350 May 26 22:52 obproxy_stat.log
-rw-r--r-- 1 root root    455937 May 26 16:44 obproxy_trace.log
-rw-r--r-- 1 root root  32840682 May 26 22:52 obproxy_xflush.log
[root@rac1 log]#
[root@rac1 log]# cd ..
[root@rac1 obproxy]# cd run/
[root@rac1 run]# ll
total 8
-rw-r--r-- 1 root root 5 May 16 15:52 obproxy-10.0.0.197-2883.pid
-rw-r--r-- 1 root root 5 May 16 15:52 obproxyd-10.0.0.197-2883.pid
[root@rac1 run]#

obproxyd.sh

該文件位于 obproxy 安裝目錄下，負責啟停 obproxy，并檢查obproxy運行狀態(tài)，當obproxy 掛掉，obproxyd.sh 會負責將其拉起來，屬于 obproxy 的守護進程

日志

obproxy 日志 保存 obproxy 的運行信息，根據(jù)實際需求查看相關日志，也可以通過obproxy日志查詢慢SQL的基礎信息

[root@rac1 log]# ll
total 1071660
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_client.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_config.log
-rw-r--r-- 1 root root    216074 May 25 20:44 obproxy_diagnosis.log
-rw-r--r-- 1 root root  12672412 May 26 23:07 obproxy_digest.log
-rw-r--r-- 1 root root   5788538 May 26 22:49 obproxy_error.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_limit.log
-rw-r--r-- 1 root root 134784335 May 26 23:07 obproxy.log
-rw-r--r-- 1 root root 268435584 May 21 21:00 obproxy.log.20240521210000
-rw-r--r-- 1 root root 268435619 May 24 04:54 obproxy.log.20240524045423
-rw-r--r-- 1 root root 268435458 May 24 20:55 obproxy.log.20240524205514
-rw-r--r-- 1 root root  12032012 May 26 23:07 obproxy.log.wf
-rw-r--r-- 1 root root  24386318 May 21 21:00 obproxy.log.wf.20240521210000
-rw-r--r-- 1 root root  17694250 May 24 04:54 obproxy.log.wf.20240524045423
-rw-r--r-- 1 root root  13785772 May 24 20:55 obproxy.log.wf.20240524205514
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_pool.log
-rw-r--r-- 1 root root         0 May 16 15:51 obproxy_pool_stat.log
-rw-r--r-- 1 root root   4661234 May 26 23:07 obproxy_slow.log
-rw-r--r-- 1 root root  15894775 May 26 23:06 obproxy_stat.log
-rw-r--r-- 1 root root    455937 May 26 16:44 obproxy_trace.log
-rw-r--r-- 1 root root  32868123 May 26 23:07 obproxy_xflush.log
[root@rac1 log]#
[root@rac1 log]#
[root@rac1 log]#
[root@rac1 log]# pwd
/opt/myoceanbase/obproxy/log
[root@rac1 log]# grep -i 'slow query' obproxy.log.20240521210000 

使用 obproxy 登錄 OB

[root@rac1 log]# obclient -h10.0.0.197 -P2883 -uroot@sys#myoceanbase -p'aaAA11__' -Doceanbase -A -c;
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 526837
Server version: OceanBase_CE 4.2.1.0 (r100000102023092807-7b0f43693565654bb1d7343f728bc2013dfff959) (Built Sep 28 2023 07:25:28)Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.obclient [oceanbase]>

注意:使用 obproxy 登錄OB時，用戶名填寫方式 必須為 用戶名@租戶名#集群名，登陸端口使用 obproxy 端口

查看 obproxy 參數(shù)

查看全部參數(shù)

obclient [oceanbase]> show proxyconfig

查看某個參數(shù)(日志清理間隔)

可以看到 當前 日志文件清理任務 的 間隔時間 為1分鐘，取值范圍為 5秒 至 30天

obclient [oceanbase]> show proxyconfig like 'log_cleanup_interval';
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
| name                 | value | info                                                                     | need_reboot | visible_level |
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
| log_cleanup_interval | 1m    | log file clean up task schedule interval, set 1 day or longer, [5s, 30d] | false       | USER          |
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
1 row in set (0.002 sec)

修改某個 obproxy 參數(shù)(日志清理間隔)

修改日志文件清理任務 的 間隔時間 為1分鐘

obclient [oceanbase]> alter proxyconfig set log_cleanup_interval = '2m';
Query OK, 0 rows affected (0.017 sec)obclient [oceanbase]>
obclient [oceanbase]> show proxyconfig like 'log_cleanup_interval';
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
| name                 | value | info                                                                     | need_reboot | visible_level |
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
| log_cleanup_interval | 2m    | log file clean up task schedule interval, set 1 day or longer, [5s, 30d] | false       | USER          |
+----------------------+-------+--------------------------------------------------------------------------+-------------+---------------+
1 row in set (0.008 sec)obclient [oceanbase]>

obproxy重啟

使用obd重啟

可以使用 -s 指定 特定節(jié)點 的obproxy 重啟

[admin@server070 oceanbase-ce]$ obd cluster restart demo -c obproxy-ce -s 127.0.0.1
Get local repositories and plugins ok
Load cluster param plugin ok
Open ssh connection ok
Cluster status check ok
Check before start obproxy ok
Stop obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
+---------------------------------------------+
|                   obproxy                   |
+-----------+------+-----------------+--------+
| ip        | port | prometheus_port | status |
+-----------+------+-----------------+--------+
| 127.0.0.1 | 2883 | 2884            | active |
+-----------+------+-----------------+--------+
obclient -h127.0.0.1 -P2883 -uroot -Doceanbase -Asucceed
Trace ID: ec2765e0-ece1-11ee-934b-000c2910d46f
If you want to view detailed obd logs, please run: obd display-trace ec2765e0-ece1-11ee-934b-000c2910d46f
[admin@server070 oceanbase-ce]$
[admin@server070 oceanbase-ce]$
[admin@server070 oceanbase-ce]$

手動重啟

將 obporxy-ce進程 和 obproxyd守護進程 殺掉

[admin@server070 ~]$ ps -ef|grep obproxy |grep -v grep
admin    15091     1  0 17:02 pts/0    00:00:01 bash /home/admin/obproxy-ce/obproxyd.sh /home/admin/obproxy-ce 127.0.0.1 2883 daemon
admin    15110     1  1 17:02 ?        00:00:39 /home/admin/obproxy-ce/bin/obproxy --listen_port 2883
[admin@server070 ~]$
[admin@server070 ~]$
[admin@server070 ~]$
[admin@server070 ~]$
[admin@server070 ~]$ kill 15091
[admin@server070 ~]$
[admin@server070 ~]$
[admin@server070 ~]$
[admin@server070 ~]$ kill 15110
[admin@server070 ~]$
[admin@server070 ~]$

啟動 obproxy 節(jié)點

[admin@server070 ~]$ cd /home/admin/obproxy-ce/
[admin@server070 obproxy-ce]$ ./bin/obproxy
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$ chmod 733 obproxyd.sh
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$ sh obproxyd.sh  /home/admin/obproxy-ce 127.0.0.1 2883
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$ ps -ef | grep obproxy | grep -v grep
admin    27105     1  2 17:37 ?        00:00:01 ./bin/obproxy
[admin@server070 obproxy-ce]$ ps -ef | grep obproxy
admin    27105     1  2 17:37 ?        00:00:02 ./bin/obproxy
admin    27451 15200  0 17:39 pts/0    00:00:00 grep --color=auto obproxy
[admin@server070 obproxy-ce]$
[admin@server070 obproxy-ce]$

驗證啟動成功

通過 obproxy 可以登錄集群

[admin@server070 oceanbase-ce]$ obclient -h127.0.0.1 -P2883 -uroot@obmysql    -Doceanbase -c  -A -paaAA11__
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 1
Server version: OceanBase_CE 4.2.2.0 (r100000192024011915-fac02c6690de9ff9f9f96c0bdf86ffe39ae0d7e7) (Built Jan 19 2024 15:14:05)Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.obclient [oceanbase]>
obclient [oceanbase]>