【 使用环境 】 测试环境
【 OB or 其他组件 】 obbinlog-ce V4.0.1
【 使用版本 】社区版
【问题描述】obbinlog最后配置完毕后,需要生成binlog的租户,运行show master status无binlog信息
配置信息如下
obbinlog:192.168.6.13:2983
odp: 192.168.128.31:28831
需要生成binlog的租户:monitor
全部配置完毕后
obbinlog输出如下:
| name | ob_cluster | ob_tenant | ip | port | zone | region | group | running | state | obcdc_running | obcdc_state | service_mode | convert_running | convert_delay | convert_rps | convert_eps | convert_iops | dumpers | version | odp_addr |
±-----------±-----------±----------±-------------±-----±-----±-------±------±--------±--------±--------------±------------±-------------±----------------±--------------±------------±------------±-------------±--------±-----------------------------------------------±---------+
| boc3jtzdev | ob01 | monitor | 192.168.6.13 | 8102 | | | | Yes | Running | Yes | Running | enabled | No | 0 | 0 | 0 | 0 | 0 | 4.0.1-92748c6c59534426d187977b13b61b7cdf4fa200 | NULL |
| kabr8jidbw | ob01 | monitor | 192.168.6.13 | 8100 | | | | Yes | Running | Yes | Running | enabled | No | 0 | 0 | 0 | 0 | 0 | 4.0.1-92748c6c59534426d187977b13b61b7cdf4fa200 | NULL |
| az9s6m43ix | ob01 | monitor | 192.168.6.13 | 8101 | | | | Yes | Running | Yes | Running | enabled | No | 0 | 0 | 0 | 0 | 0 | 4.0.1-92748c6c59534426d187977b13b61b7cdf4fa200 | NULL |
±-----------±-----------±----------±-------------±-----±-----
使用root@sys登录odp查询SHOW PROXYCONFIG LIKE ‘binlog_service_ip’;如下
±----------------------±------±-----------------------------------------------------------±------------±--------------+
| name | value | info | need_reboot | visible_level |
±----------------------±------±-----------------------------------------------------------±------------±--------------+
| enable_binlog_service | True | if enabled, obproxy will send binlog request to OBLogProxy | false | SYS |
±----------------------±------±-----------------------------------------------------------±------------±--------------+
查看指定租户的 Binlog 任务的实例运行状态如下
SHOW BINLOG STATUS FOR TENANT ob01.monitor;
| cluster | tenant | status |
±--------±--------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ob01 | monitor | {“binlog_instance”:“kabr8jidbw”,“resources_metrics”:{“client_id”:"/data/oblogproxy/run/kabr8jidbw",“fd_count”:11,“pid”:6143,“cpu_status”:{“cpu_count”:8,“cpu_used_ratio”:0.0},“disk_status”:{“disk_total_size_mb”:307048,“disk_usage_size_process_mb”:0,“disk_used_ratio”:0.0,“disk_used_size_mb”:18525},“memory_status”:{“mem_total_size_mb”:32012,“mem_used_ratio”:0.0004998125950805843,“mem_used_size_mb”:16},“network_status”:{“network_rx_bytes”:29676,“network_wx_bytes”:88455}},“binlog_files”:[]} |
±--------±--------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
使用需要生成binlog的租户登录odp后
show master status;
无binlog
odp日志
2024-12-11 15:45:17.225384,ob01,ob01:monitor:oceanbase,OB_MYSQL,OB_MYSQL_COM_QUERY,OTHERS,success,show master status,260278us,218025us,0us,719us,Y0-00001543B042F060,0,192.168.6.13:8100
obbinlog日志
[2024-12-11 15:45:17.320416] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/kabr8jidbw/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.320459] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.321896] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.321941] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/az9s6m43ix/binlog_instance.socket
[2024-12-11 15:45:17.322532] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/kabr8jidbw/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.322615] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/kabr8jidbw/binlog_instance.socket
[2024-12-11 15:45:17.326790] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.328045] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:17.328096] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/boc3jtzdev/binlog_instance.socket
[2024-12-11 15:45:18.332799] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.333233] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.333427] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/kabr8jidbw/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.334570] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.334635] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/az9s6m43ix/binlog_instance.socket
[2024-12-11 15:45:18.335094] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.335143] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/boc3jtzdev/binlog_instance.socket
[2024-12-11 15:45:18.336010] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/kabr8jidbw/binlog_instance.socket, user: OBM
[2024-12-11 15:45:18.336065] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/kabr8jidbw/binlog_instance.socket
[2024-12-11 15:45:19.342723] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:19.343593] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:19.343949] [info] mysql_protocol.cpp(70): Connect to server through unix domain socket success: ./run/kabr8jidbw/binlog_instance.socket, user: OBM
[2024-12-11 15:45:19.344379] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/az9s6m43ix/binlog_instance.socket, user: OBM
[2024-12-11 15:45:19.344422] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/az9s6m43ix/binlog_instance.socket
[2024-12-11 15:45:19.345137] [info] mysql_protocol.cpp(129): Auth user success of server: ./run/boc3jtzdev/binlog_instance.socket, user: OBM
[2024-12-11 15:45:19.345221] [info] instance_client.cpp(69): Successfully login binlog instance, is_local: true, addr: ./run/boc3jtzdev/binlog_instance.socket