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 上，你要挨打哦 <[email protected]> 写道： > 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. >
