arkdb / arkproxy Goto Github PK

高性能、高可靠的数据库跨云中间件，完全兼容MySQL技术体系，由极数云舟出品开源

License: GNU Lesser General Public License v2.1

Shell 0.81% CMake 0.81% C 50.50% C++ 38.89% Perl 3.26% Roff 1.17% Assembly 0.01% Batchfile 0.04% Objective-C 0.76% Pascal 0.39% NASL 1.57% PHP 0.01% HTML 1.62% SourcePawn 0.01% Raku 0.01% VBA 0.01% POV-Ray SDL 0.01% M4 0.09% Makefile 0.01% XS 0.03%

arkproxy's People

Stargazers

Watchers

arkproxy's Issues

关于启动/停止的操作

怎么停止呢？

文档中只有start的操作，但是却没有找到stop的命令，是直接kill掉吗？有没有优雅一点的stop方法？

启动就退出，没有日志报错

启动命令：

/usr/local/arkproxy/arkproxy --defaults-file=/usr/local/arkproxy/arkproxy.cnf &

启动后的状态信息：

[root@localhost arkproxy]# /usr/local/arkproxy/arkproxy --defaults-file=/usr/local/arkproxy/arkproxy.cnf &
[1] 18268
[root@localhost arkproxy]# 2020-09-08 10:30:21 139774839484928 [Note] /usr/local/arkproxy/arkproxy (arkproxy 20.04.23) starting as process 18268 ...

[1]+  Exit 1                  /usr/local/arkproxy/arkproxy --defaults-file=/usr/local/arkproxy/arkproxy.cnf

请问，这是什么原因呢？

proxy heartbeat error

arkproxy version:
20.04.23
报错信息如下：

2020-12-10  1:51:51 140451613242112 [Warning] proxy heartbeat error(retry: 1): 0, Got packets out oforder
2020-12-10  1:51:51 140451613242112 [Warning] proxy heartbeat error(retry: 2): 0, Got packets out oforder
2020-12-10  1:51:51 140451613242112 [Warning] proxy heartbeat error(retry: 3): 0, Got packets out oforder
2020-12-10  1:51:51 140451613242112 [Warning] backend connection closed. host:192.168.50.49, port:3306, reconnect times...:1

请问下，这个日志报错正常吗？

在centos8上编译成功，运行报错

系统centos8，gcc8.5.0
编译成功，但是运行出错，应该怎么处理呢还是缺少了什么依赖吗？

buffer overflow detected

咨询下
下面遇到的这个问题是否是status里面的参数超出了？有没有哪个参数可以调整下

 show proxy status;
+------------------+--------------------+--------------------+------------------+------------------+-----------+
| Connection_Count | Min_Con_Buffer_Mem | Max_Con_Buffer_Mem | Total_Packet_Mem | Total_Buffer_Mem | Total_Mem |
+------------------+--------------------+--------------------+------------------+------------------+-----------+
|               60 |             137506 |            2794665 |         84672000 |        113333230 | 198005230 |
+------------------+--------------------+--------------------+------------------+------------------+-----------+
1 row in set (0.00 sec)

2020-10-13 19:30:49 140349055181568 [Note] assemble_kill_packet: KILL CONNECTION 2105942
2020-10-13 19:30:49 140349055181568 [Note] assemble_kill_packet: KILL CONNECTION 2105942
2020-10-13 19:30:54 140349055181568 [Note] assemble_kill_packet: KILL CONNECTION 2105942
2020-10-13 19:30:54 140349055181568 [Note] assemble_kill_packet: KILL CONNECTION 2105942
2020-10-13 19:31:03 140349055181568 [Note] assemble_kill_packet: KILL CONNECTION 2105942
*** buffer overflow detected ***: /usr/local/arkproxy/bin/arkproxy terminated
*** buffer overflow detected ***: /usr/local/arkproxy/bin/arkproxy terminated
======= Backtrace: =========
======= Backtrace: =========
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fa696604577]
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fa696604577]
/lib64/libc.so.6(+0x1166f2)[0x7fa6966026f2]
/usr/local/arkproxy/bin/arkproxy(_Z22init_backend_conn_infoP19backend_conn_structPcS1_S1_j+0x27)[0x561f1c833467]
/lib64/libc.so.6(+0x1166f2)[0x7fa6966026f2]
/usr/local/arkproxy/bin/arkproxy(_Z25mysql_fetch_server_statusP19backend_conn_struct+0x85)[0x561f1c833555]
/usr/local/arkproxy/bin/arkproxy(_Z22init_backend_conn_infoP19backend_conn_structPcS1_S1_j+0x27)[0x561f1c833467]
/usr/local/arkproxy/bin/arkproxy(_Z19proxy_timer_checkerP3THD+0x168)[0x561f1c837de8]
/usr/local/arkproxy/bin/arkproxy(_Z25mysql_fetch_server_statusP19backend_conn_struct+0x85)[0x561f1c833555]
/usr/local/arkproxy/bin/arkproxy(command_executer+0xab)[0x561f1c837f0b]
/usr/local/arkproxy/bin/arkproxy(_Z19proxy_timer_checkerP3THD+0x168)[0x561f1c837de8]
/lib64/libpthread.so.0(+0x7ea5)[0x7fa697e21ea5]
/usr/local/arkproxy/bin/arkproxy(command_executer+0xab)[0x561f1c837f0b]
/lib64/libc.so.6(clone+0x6d)[0x7fa6965ea8dd]
======= Memory map: ========
/lib64/libpthread.so.0(+0x7ea5)[0x7fa697e21ea5]
561f1c285000-561f1d0d1000 r-xp 00000000 fd:01 1319346                    /usr/local/arkproxy/bin/arkproxy
561f1d2d0000-561f1d3bd000 r--p 00e4b000 fd:01 1319346                    /usr/local/arkproxy/bin/arkproxy
561f1d3bd000-561f1d461000 rw-p 00f38000 fd:01 1319346                    /usr/local/arkproxy/bin/arkproxy
561f1d461000-561f1dc9e000 rw-p 00000000 00:00 0
561f1ef99000-561f202fe000 rw-p 00000000 00:00 0                          [heap]
7fa581a9a000-7fa581a9b000 ---p 00000000 00:00 0

设置proxy_digest_trace和proxy_sql_trace参数不生效

版本：v20.06.30
参数配置：

proxy_digest_trace = ON
proxy_sql_trace = ON

问题描述：

想查看业务访问语句的digest信息。但是配置了
proxy_digest_trace = ON
proxy_sql_trace = ON
这两个参数，却不生效，日志也没有打印出来，这就和文档中的配置描述有出入
文档对于proxy_sql_trace是这样描述的：
ArkProxy的sql trace是否开启开关，默认是true，如果开启了，则会将所有的 SQL访问都记下来，存储到proxy_config_host:proxy_config_port设置的目标数据库中，可能会对中间层的性能有影响。依赖proxy_digest_trace，只有proxy_digest_trace打开了， proxy_sql_trace打开之后才能起作用。

想得到的效果
通过参数配置arkproxy.cnf文件，可以查看到业务访问语句的digest信息

开启了proxy_digest_trace，arkproxy就不能启动

用户不能对数据库进行隔离

场景

一个数据库实例下，有多个数据库，一个数据库对应一个项目，每个项目的账号看到的数据库都是不一样的，
这种该如何实现呢？

运行build.sh脚本报错

-- Configuring done
CMake Error at cmake/libutils.cmake:108 (ADD_LIBRARY):
Cannot find source file:

debug_sync_service.c

Tried extensions .c .C .c++ .cc .cpp .cxx .cu .m .M .mm .h .hh .h++ .hm
.hpp .hxx .in .txx
Call Stack (most recent call first):
libservices/CMakeLists.txt:36 (ADD_CONVENIENCE_LIBRARY)

CMake Error at sql/CMakeLists.txt:173 (ADD_LIBRARY):
Cannot find source file:

debug_sync.cc

Tried extensions .c .C .c++ .cc .cpp .cxx .cu .m .M .mm .h .hh .h++ .hm
.hpp .hxx .in .txx

CMake Error at cmake/libutils.cmake:108 (ADD_LIBRARY):
No SOURCES given to target: mysqlservices
Call Stack (most recent call first):
libservices/CMakeLists.txt:36 (ADD_CONVENIENCE_LIBRARY)

CMake Error at sql/CMakeLists.txt:173 (ADD_LIBRARY):
No SOURCES given to target: sql

CMake Generate step failed. Build files cannot be regenerated correctly.

arkproxy不能设置最大使用内存么，生产中运行，使用的内存会一直增加

mysql 8.0 支持吗？

mysql 8.0 支持吗

arkdb / arkproxy Goto Github PK

arkproxy's People

Stargazers

Watchers

Forkers

arkproxy's Issues

怎么停止呢？

启动命令：

启动后的状态信息：

场景

Recommend Projects

Recommend Topics

Recommend Org