Hi zhixiong, For this year's GSoC, one of the topics for APISIX application is to add Elasticsearch plugin: https://issues.apache.org/jira/browse/COMDEV-449
I am the mentor of this topic, I hope this tpoic can go on smoothly, and I also invite you to participate in the mentoring of this topic. *ZhengSong Tu* My GitHub: https://github.com/tzssangglass Apache APISIX: https://github.com/apache/apisix 在 2022年4月19日 09:16:02 上，zhixiongdu027 <r...@libssl.com> 写道： > Hi all: > > compared to kafka, mongo, > elasticsearch is a bit more used for storing logs. > I think apisix needs an elasticsearch-logger more > > > 在 4/18/22 23:53, ZhengSong Tu 写道: > > Hi, mango, > > > I have the same confusion as JinTao. > > > IMO, MySQL is a relational database and is better suited for expressing > > relationships between objects. But for logging scenarios, there doesn't > > seem to be that strong a relational model present. > > > Currently APISIX already supports ClickHouse database for storing logs, > > which is understandable. ClickHouse supports OLTP and OLAP to support user > > storage and retrieval and analysis of logs. > > > Perhaps a scenario is needed to explain why need to use MySQL to store > > logs. what problems it can solve. > > > Please excuse me for being perhaps a bit strict, just because I didn't > > think of MySQL as a log storage service in the usage scenario. > > > My concern is that storing log content in json format or request/response > > body in a mysql property, for example (I've seen people use MySQL this > > way), is not an easy way to retrieve and analyze logs. > > > > *ZhengSong Tu* > > My GitHub: https://github.com/tzssangglass > > Apache APISIX: https://github.com/apache/apisix > > > > 在 2022年4月18日 10:45:21 上，你要挨打哦 <1253319...@qq.com.invalid> 写道： > > > > Hello, > > > > > > The APISIX has some plugin loggers like http-logger,kafka-logger which > > > can receive log from apisix to persistence or analysis, but without MySQL > > > logger. > > > > > > Today, MySQL is the second ranking RDBMS solution in the world, according > > > to DB Engines <https://db-engines.com/en/ranking> and it is a > > > free-to-use, open-source database that facilitates effective management > of > > > databases by connecting them to the software. It is a stable, reliable > and > > > powerful solution with advanced features like the following Data > Security, > > > High Performance and so on, so there are many users or companies already > > > use MySQL to persist data. > > > > > > And lua-resty-mysql <https://github.com/openresty/lua-resty-mysql> is a > > > MySQL client driver for the ngx_lua nginx module, it support basic > > > operation of CURD, maybe we can use it to persist request logs from > apisix. > > > > > > Please leave your comments below if there's anyone agrees with me. > > > > > > Thank you. > > > > > >
