安徽汽车网网站建设,wordpress 知乎,做网站的代码难吗,商品推广软文范例200字简介
obproxy 属于OceanBase的代理#xff0c;生产环境中 OceanBase 数据库的数据 会以 多副本的形式 存放在各个 OBServer 节点上#xff0c;obproxy 接收用户发出的 SQL 请求#xff0c;并将 SQL 请求转发至最佳目标 OBServer 节点#xff0c;最后将执行结果返回给用户生产环境中 OceanBase 数据库的数据 会以 多副本的形式 存放在各个 OBServer 节点上obproxy 接收用户发出的 SQL 请求并将 SQL 请求转发至最佳目标 OBServer 节点最后将执行结果返回给用户该工具一般部署在observer所在的服务器上。 查看obproxy信息(查看进程)
可以看出当前只有一台 obproxy, 端口号为2883目录在 /opt/myoceanbase/obproxy
[rootrac1 ~]# 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 --colorauto obproxy
[rootrac1 ~]# 安装目录
通过查看 obproxy 进程运行状态得出 obproxy 安装目录是 /opt/myoceanbase/obproxy 进入安装目录
可以看到在安装目录下 存在 obproxy 自身的一些文件和目录信息: 日志目录log, 进程id目录run, 配置目录etc, 守护进程 obproxyd.sh
[rootrac1 ~]# cd /opt/myoceanbase/obproxy
[rootrac1 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
[rootrac1 obproxy]#
[rootrac1 obproxy]#
[rootrac1 obproxy]#
[rootrac1 obproxy]# cd log/
[rootrac1 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
[rootrac1 log]#
[rootrac1 log]# cd ..
[rootrac1 obproxy]# cd run/
[rootrac1 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
[rootrac1 run]# obproxyd.sh
该文件位于 obproxy 安装目录下负责启停 obproxy并检查obproxy运行状态当obproxy 挂掉obproxyd.sh 会负责将其拉起来属于 obproxy 的守护进程 日志
obproxy 日志 保存 obproxy 的运行信息根据实际需求查看相关日志也可以通过obproxy日志查询慢SQL的基础信息
[rootrac1 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
[rootrac1 log]#
[rootrac1 log]#
[rootrac1 log]#
[rootrac1 log]# pwd
/opt/myoceanbase/obproxy/log
[rootrac1 log]# grep -i slow query obproxy.log.20240521210000 使用 obproxy 登录 OB
[rootrac1 log]# obclient -h10.0.0.197 -P2883 -urootsys#myoceanbase -paaAA11__ -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 参数
查看全部参数
obclient [oceanbase] show proxyconfig 查看某个参数(日志清理间隔)
可以看到 当前 日志文件清理任务 的 间隔时间 为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 参数(日志清理间隔)
修改日志文件清理任务 的 间隔时间 为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 指定 特定节点 的obproxy 重启
[adminserver070 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
[adminserver070 oceanbase-ce]$
[adminserver070 oceanbase-ce]$
[adminserver070 oceanbase-ce]$ 手动重启
将 obporxy-ce进程 和 obproxyd守护进程 杀掉
[adminserver070 ~]$ 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
[adminserver070 ~]$
[adminserver070 ~]$
[adminserver070 ~]$
[adminserver070 ~]$
[adminserver070 ~]$ kill 15091
[adminserver070 ~]$
[adminserver070 ~]$
[adminserver070 ~]$
[adminserver070 ~]$ kill 15110
[adminserver070 ~]$
[adminserver070 ~]$ 启动 obproxy 节点
[adminserver070 ~]$ cd /home/admin/obproxy-ce/
[adminserver070 obproxy-ce]$ ./bin/obproxy
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$ chmod 733 obproxyd.sh
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$ sh obproxyd.sh /home/admin/obproxy-ce 127.0.0.1 2883
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$ ps -ef | grep obproxy | grep -v grep
admin 27105 1 2 17:37 ? 00:00:01 ./bin/obproxy
[adminserver070 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 --colorauto obproxy
[adminserver070 obproxy-ce]$
[adminserver070 obproxy-ce]$ 验证启动成功
通过 obproxy 可以登录集群
[adminserver070 oceanbase-ce]$ obclient -h127.0.0.1 -P2883 -urootobmysql -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]
