obproxy

obproxy copied to clipboard

一、背景： 测试ODP(4.2.1) + OB(4.2) + logproxy(2.0.0-bp/2.0.0)的可行性。 二、现象描述： 1. 直接连接到 oblogproxy 执行 show master status 并发执行没有问题 2. 通过 obproxy 连接上，执行 show master status 并发执行会有问题，ODP会偶发连接不上binlog service，任务失败 3.通过java sdk监听binlog数据 没有问题，即使通过sysbench并发写入时，监听也不会报错 4.相关报错的日志 mysql 客户端：...

xiaotouming1112222

## Summary ## Solution Description fix issue #38

xiaoleizi2016

### Task Description #45 ### Solution Description ### Passed Regressions ### Upgrade Compatibility ### Other Information ### Release Note

xiaoleizi2016

[Feature]: 物理主备库不能利用obproxy实现读写分离

2

**Use Case** 某业务比较小，只有2台服务器， 做物理主备比较合适，但在读写分离时遇到了问题，好像4.1版本的obproxy不支持物理主备库的读写分离，希望能支持。 **Describe the solution you'd like** 程序连接obproxy，根据设置或hint提示 可以访问主库，也可以访问备库 **Describe alternatives you've considered** 目前主库上并不能获取到备库的信息。 建议可以在obproxy中配置物理主备库的信息（路由缓存），可以根据健康检查脚本的返回结果去判断当前主备库的状态（处于主库、备库或者宕机状态）， 类似于proxysql吧 **Additional context**

adleylcm

[Feature]: ODP不支持物理主备库的读写分离

2

**Use Case** 某业务比较小，只有2台服务器， 做物理主备比较合适，但在读写分离时遇到了问题，好像4.1版本的obproxy不支持物理主备库的读写分离，4.2版本支持基于网络的主备库，好像也不支持。 希望能支持。 **Describe the solution you'd like** 程序连接obproxy，根据设置或hint提示 可以访问主库，也可以访问备库 **Describe alternatives you've considered** 目前主库上并不能获取到备库的信息，odp也就没办法从主库获取备库的信息。 建议可以在obproxy中配置物理主备库的信息（路由缓存），可以根据健康检查脚本的返回结果去判断当前主备库的状态（处于主库、备库或者宕机状态）， 类似于proxysql吧 **Additional context**

adleylcm

**Describe the bug** obproxy的nc健康检查，因为不是完备的mysql协议，导致obproxy不停地打Connect error链接错误。 2023-07-04 10:37:33.341153,app,,,,::,OB_MYSQL,,,COM_LOGIN,,failed,-4124,,801us,0us,0us,0us,Y0-7D44730143A0,,,,0,,Connect error 2023-07-04 10:38:33.261336,app,,,,::,OB_MYSQL,,,COM_LOGIN,,failed,-4124,,145us,0us,0us,0us,Y0-7D44730143A0,,,,0,,Connect error 2023-07-04 10:41:48.266505,app,,,,::,OB_MYSQL,,,COM_LOGIN,,failed,-4124,,87us,0us,0us,0us,Y0-7D44722143A0,,,,0,,Connect error 2023-07-04 10:43:33.211679,app,,,,::,OB_MYSQL,,,COM_LOGIN,,failed,-4124,,406us,0us,0us,0us,Y0-7D44730143A0,,,,0,,Connect error 2023-07-04 10:44:33.376363,app,,,,::,OB_MYSQL,,,COM_LOGIN,,failed,-4124,,2813us,0us,0us,0us,Y0-7D44722143A0,,,,0,,Connect error **Environment** - OS Version and CPU Arch(`uname -a`): 所有环境 -...

xiaoleizi2016

[Question]: <title>使用 Anolis OS 8.8 编译 obproxy。master分支，编译构建出现如下报错，请帮忙排查

10

If the question is concise and probably has a short answer, asking it in [community Slack](https://join.slack.com/t/oceanbase/shared_invite/zt-1e25oz3ol-lJ6YNqPHaKwY_mhhioyEuw) **Question** **Environment** - OS Version and CPU Arch(`uname -a`): - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`):...

angelra1994

### What changes were proposed in this pull request? devdeps-gtest - 1.8.0-3.el8.x86_64.rpm -> evdeps-gtest-1.8.0- 132022101316 .el8.x86_64.rpm ### Why are the changes needed? centos8 build fail ### Will break the compatibility?...

donghy-coredumped

### Check Before Asking - [X] Please check the issue list and confirm this feature is encountered for the first time. - [X] Please try full text in English and...

caoyj1024

### Check Before Asking - [X] Please check the issue list and confirm this bug is encountered for the first time. - [X] Please try full text in English and...

xiaoleizi2016