Hi, Thank you all for the advice about this mysql-logger.
>From my perspective, in order to figure out whether apisix needs a mysql-logger, we not only need the technical view, but also the views of product solution or community ecosystem. MySQL is still a widely used relational database, which also supports cluster mode with high performance and stored lots of data of legacy systems. In the scenario of system integration, customers may use MySQL to do data processing along with other management systems to resolve auditing, transactional data reading/writing and etc. MongoDB, ClickHouse and Cassandra are definitely all better than MySQL for logging storage, but actually this does not mean no one will still use MySQL to store logs. :-) Looking forward to your feedback. Thanks. Regards, Joey On Mon, Apr 18, 2022 at 11:53 PM ZhengSong Tu <tzssanggl...@gmail.com> wrote: > 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. > > >
