Hi ZhengSong:
It is very unexpected and pleasant to receive your invitation, I
am very happy to accept.
This is the first time I have come into this kind of project ,
please give me more advice in the future.
Very tks
在 4/19/22 09:31, ZhengSong Tu 写道:
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.
