建甌做網(wǎng)站的公司實時軍事熱點
簡介
obproxy 屬于OceanBase的代理，生產(chǎn)環(huán)境中 OceanBase 數(shù)據(jù)庫的數(shù)據(jù) 會以 多副本的形式 存放在各個 OBServer 節(jié)點上，obproxy 接收用戶發(fā)出的 SQL 請求，并將 SQL 請求轉(zhuǎn)發(fā)至最佳目標(biāo) OBServer 節(jié)點，最后將執(zhí)行結(jié)果返回給用戶，該工具一般部署在observer所在的服務(wù)器上。
查看obproxy信息(查看進(jìn)程)
可以看出當(dāng)前只有一臺 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 進(jìn)程運(yùn)行狀態(tài)得出 obproxy 安裝目錄是 /opt/myoceanbase/obproxy
進(jìn)入安裝目錄
可以看到在安裝目錄下 存在 obproxy 自身的一些文件和目錄信息: 日志目錄log, 進(jìn)程id目錄run, 配置目錄etc, 守護(hù)進(jìn)程 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 安裝目錄下，負(fù)責(zé)啟停 obproxy，并檢查obproxy運(yùn)行狀態(tài)，當(dāng)obproxy 掛掉，obproxyd.sh 會負(fù)責(zé)將其拉起來，屬于 obproxy 的守護(hù)進(jìn)程
日志
obproxy 日志 保存 obproxy 的運(yùn)行信息，根據(jù)實際需求查看相關(guān)日志，也可以通過obproxy日志查詢慢SQL的基礎(chǔ)信息
[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ù)(日志清理間隔)
可以看到 當(dāng)前 日志文件清理任務(wù) 的 間隔時間 為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ù)(日志清理間隔)
修改日志文件清理任務(wù) 的 間隔時間 為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進(jìn)程 和 obproxyd守護(hù)進(jìn)程 殺掉
[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]>