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.
