You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@apisix.apache.org by 你要挨打哦 <12...@qq.com.INVALID> on 2022/04/18 02:45:21 UTC
[Feature Request]Add MySQL logger to persist logs from apisix
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.
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by zhixiongdu027 <ro...@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 上，你要挨打哦 <12...@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.
>>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by Joey Ma <ma...@apache.org>.
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 <tz...@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 上，你要挨打哦 <12...@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.
> >
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by zhixiongdu027 <ro...@libssl.com>.
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 <ro...@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 上，你要挨打哦 <12...@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.
>>
>>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by ZhengSong Tu <tz...@gmail.com>.
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 <ro...@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 上，你要挨打哦 <12...@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.
>
> >
>
>
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by ZhengSong Tu <tz...@gmail.com>.
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 上，你要挨打哦 <12...@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.
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by mango <12...@qq.com.INVALID>.
Yes, I noticed that APISIX will support different backend as source of confirmation instead of etcd, and I’d like to word if there's anything need support.
And this feature request may work as a logger such as Kafka-logger to save request Log.
> 2022年4月18日 上午11:19，Chever John <ch...@gmail.com> 写道：
>
> Hi,
>
> Great suggestion!
>
> In fact I understand that APISIX may have plans to support mysql this year.
> I think you could keep an eye on the APISIX roadmap and of course if you
> can provide support for that, you'd be very welcome!
>
> I look forward to hearing from you!
>
> Best wish,
> John Chever
>
>
> On Apr 18, 2022 at 11:14:19, 你要挨打哦 <1253319389@qq.com.invalid <ma...@qq.com.invalid>> wrote:
>
>> Thanks for your guidance. I have sent an email to
>> dev-subscribe@apisix.apache.org <ma...@apisix.apache.org> <mailto:dev-subscribe@apisix.apache.org <ma...@apisix.apache.org>>
>> and received a comfirmation email from dev-help@apisix.apache.org <ma...@apisix.apache.org> <mailto:
>> dev-help@apisix.apache.org <ma...@apisix.apache.org>> who told me that The address
>>
>> 1253319389@qq.com <ma...@qq.com> <mailto:1253319389@qq.com <ma...@qq.com>>
>>
>> was already on the dev mailing list when I received
>> your request, and remains a subscriber.
>>
>> 2022年4月18日 上午10:53，Zhiyuan Ju <juzhiyuan@apache.org <ma...@apache.org>> 写道：
>>
>>
>> Hi,
>>
>>
>> Glad to hear from you!
>>
>>
>> I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
>> Please follow this guide[1] to subscribe and discuss.
>>
>>
>> I am also waiting for more ideas about this feature request :)
>>
>>
>> [1]
>> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
>> <
>> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list <https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list>
>>>
>>
>> Best Regards!
>>
>> @ Zhiyuan Ju <https://github.com/juzhiyuan <https://github.com/juzhiyuan>>
>>
>>
>> 你要挨打哦 <1253319389@qq.com.invalid <ma...@qq.com.invalid>> 于2022年4月18日周一 10:45写道：
>>
>> 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 <https://db-engines.com/en/ranking> <
>> https://db-engines.com/en/ranking <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 <https://github.com/openresty/lua-resty-mysql> <
>> https://github.com/openresty/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.
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by mango <12...@qq.com.INVALID>.
Hi Jintao & John Chever:
Thanks for your different views, it is very useful and constructive for me.
By the way, the PR about this feature request already done, if there are more agree, I’d very like to push it.
Best wish,
mango
> 2022年4月18日 下午12:14，Chever John <ch...@gmail.com> 写道：
>
> Hi, Jintao & mango
>
> It is my pleasure to express my opinion about this problem. My opinion is
> that we can add MySQL support.
>
> My reasons as follows:
>
> 1. Maybe 90% of companies don’t use MySQL, there are also 10% left. In
> fact, it can’t be that few.
> 2.
>
> As Jintao said, we're excited to see the APISIX ecosystem become even
> richer. So it will be a good chance for potential contributor.
>
>
> By the way, you are welcome to add your support for MySQL!
>
> Best wish,
> John Chever
>
> On Apr 18, 2022 at 11:44:52, Jintao Zhang <zh...@gmail.com> wrote:
>
>> Hi, glad to see you have this suggestion.
>>
>> The views below are my own.
>> I've seen people use MongoDB to store logs, but I haven't seen an actual
>> production environment that uses MySQL to store logs.
>> In terms of technical implementation, I don't think it's difficult, and I'm
>> also happy to see the APISIX ecosystem become more abundant.
>> But from a practical point of view, I personally do not recommend it.
>>
>>
>> In fact I understand that APISIX may have plans to support mysql this
>>
>> year.
>>
>> @Chever Sorry, you may have misunderstood. You are not talking about the
>> same thing.
>>
>>
>>
>> Chever John <ch...@gmail.com> 于2022年4月18日周一 11:20写道：
>>
>> Hi,
>>
>>
>> Great suggestion!
>>
>>
>> In fact I understand that APISIX may have plans to support mysql this year.
>>
>> I think you could keep an eye on the APISIX roadmap and of course if you
>>
>> can provide support for that, you'd be very welcome!
>>
>>
>> I look forward to hearing from you!
>>
>>
>> Best wish,
>>
>> John Chever
>>
>>
>>
>> On Apr 18, 2022 at 11:14:19, 你要挨打哦 <12...@qq.com.invalid> wrote:
>>
>>
>>> Thanks for your guidance. I have sent an email to
>>
>>> dev-subscribe@apisix.apache.org <ma...@apisix.apache.org>
>>
>>> and received a comfirmation email from dev-help@apisix.apache.org
>>
>> <mailto:
>>
>>> dev-help@apisix.apache.org> who told me that The address
>>
>>>
>>
>>> 1253319389@qq.com <ma...@qq.com>
>>
>>>
>>
>>> was already on the dev mailing list when I received
>>
>>> your request, and remains a subscriber.
>>
>>>
>>
>>> 2022年4月18日 上午10:53，Zhiyuan Ju <ju...@apache.org> 写道：
>>
>>>
>>
>>>
>>
>>> Hi,
>>
>>>
>>
>>>
>>
>>> Glad to hear from you!
>>
>>>
>>
>>>
>>
>>> I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
>>
>>> Please follow this guide[1] to subscribe and discuss.
>>
>>>
>>
>>>
>>
>>> I am also waiting for more ideas about this feature request :)
>>
>>>
>>
>>>
>>
>>> [1]
>>
>>>
>>
>>
>> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
>>
>>> <
>>
>>>
>>
>>
>> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
>>
>>>>
>>
>>>
>>
>>> Best Regards!
>>
>>>
>>
>>> @ Zhiyuan Ju <https://github.com/juzhiyuan>
>>
>>>
>>
>>>
>>
>>> 你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
>>
>>>
>>
>>> 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 <
>>
>>> 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 <
>>
>>> 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.
>>
>>>
>>
>>>
>>
>>>
>>
>>
>>
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by Chever John <ch...@gmail.com>.
Hi, Jintao & mango
It is my pleasure to express my opinion about this problem. My opinion is
that we can add MySQL support.
My reasons as follows:
1. Maybe 90% of companies don’t use MySQL, there are also 10% left. In
fact, it can’t be that few.
2.
As Jintao said, we're excited to see the APISIX ecosystem become even
richer. So it will be a good chance for potential contributor.
By the way, you are welcome to add your support for MySQL!
Best wish,
John Chever
On Apr 18, 2022 at 11:44:52, Jintao Zhang <zh...@gmail.com> wrote:
> Hi, glad to see you have this suggestion.
>
> The views below are my own.
> I've seen people use MongoDB to store logs, but I haven't seen an actual
> production environment that uses MySQL to store logs.
> In terms of technical implementation, I don't think it's difficult, and I'm
> also happy to see the APISIX ecosystem become more abundant.
> But from a practical point of view, I personally do not recommend it.
>
>
> In fact I understand that APISIX may have plans to support mysql this
>
> year.
>
> @Chever Sorry, you may have misunderstood. You are not talking about the
> same thing.
>
>
>
> Chever John <ch...@gmail.com> 于2022年4月18日周一 11:20写道：
>
> Hi,
>
>
> Great suggestion!
>
>
> In fact I understand that APISIX may have plans to support mysql this year.
>
> I think you could keep an eye on the APISIX roadmap and of course if you
>
> can provide support for that, you'd be very welcome!
>
>
> I look forward to hearing from you!
>
>
> Best wish,
>
> John Chever
>
>
>
> On Apr 18, 2022 at 11:14:19, 你要挨打哦 <12...@qq.com.invalid> wrote:
>
>
> > Thanks for your guidance. I have sent an email to
>
> > dev-subscribe@apisix.apache.org <ma...@apisix.apache.org>
>
> > and received a comfirmation email from dev-help@apisix.apache.org
>
> <mailto:
>
> > dev-help@apisix.apache.org> who told me that The address
>
> >
>
> > 1253319389@qq.com <ma...@qq.com>
>
> >
>
> > was already on the dev mailing list when I received
>
> > your request, and remains a subscriber.
>
> >
>
> > 2022年4月18日 上午10:53，Zhiyuan Ju <ju...@apache.org> 写道：
>
> >
>
> >
>
> > Hi,
>
> >
>
> >
>
> > Glad to hear from you!
>
> >
>
> >
>
> > I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
>
> > Please follow this guide[1] to subscribe and discuss.
>
> >
>
> >
>
> > I am also waiting for more ideas about this feature request :)
>
> >
>
> >
>
> > [1]
>
> >
>
>
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
>
> > <
>
> >
>
>
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
>
> > >
>
> >
>
> > Best Regards!
>
> >
>
> > @ Zhiyuan Ju <https://github.com/juzhiyuan>
>
> >
>
> >
>
> > 你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
>
> >
>
> > 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 <
>
> > 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 <
>
> > 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.
>
> >
>
> >
>
> >
>
>
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by Jintao Zhang <zh...@gmail.com>.
Hi, glad to see you have this suggestion.
The views below are my own.
I've seen people use MongoDB to store logs, but I haven't seen an actual
production environment that uses MySQL to store logs.
In terms of technical implementation, I don't think it's difficult, and I'm
also happy to see the APISIX ecosystem become more abundant.
But from a practical point of view, I personally do not recommend it.
> In fact I understand that APISIX may have plans to support mysql this
year.
@Chever Sorry, you may have misunderstood. You are not talking about the
same thing.
Chever John <ch...@gmail.com> 于2022年4月18日周一 11:20写道：
> Hi,
>
> Great suggestion!
>
> In fact I understand that APISIX may have plans to support mysql this year.
> I think you could keep an eye on the APISIX roadmap and of course if you
> can provide support for that, you'd be very welcome!
>
> I look forward to hearing from you!
>
> Best wish,
> John Chever
>
>
> On Apr 18, 2022 at 11:14:19, 你要挨打哦 <12...@qq.com.invalid> wrote:
>
> > Thanks for your guidance. I have sent an email to
> > dev-subscribe@apisix.apache.org <ma...@apisix.apache.org>
> > and received a comfirmation email from dev-help@apisix.apache.org
> <mailto:
> > dev-help@apisix.apache.org> who told me that The address
> >
> > 1253319389@qq.com <ma...@qq.com>
> >
> > was already on the dev mailing list when I received
> > your request, and remains a subscriber.
> >
> > 2022年4月18日 上午10:53，Zhiyuan Ju <ju...@apache.org> 写道：
> >
> >
> > Hi,
> >
> >
> > Glad to hear from you!
> >
> >
> > I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
> > Please follow this guide[1] to subscribe and discuss.
> >
> >
> > I am also waiting for more ideas about this feature request :)
> >
> >
> > [1]
> >
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
> > <
> >
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
> > >
> >
> > Best Regards!
> >
> > @ Zhiyuan Ju <https://github.com/juzhiyuan>
> >
> >
> > 你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
> >
> > 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 <
> > 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 <
> > 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.
> >
> >
> >
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by Chever John <ch...@gmail.com>.
Hi,
Great suggestion!
In fact I understand that APISIX may have plans to support mysql this year.
I think you could keep an eye on the APISIX roadmap and of course if you
can provide support for that, you'd be very welcome!
I look forward to hearing from you!
Best wish,
John Chever
On Apr 18, 2022 at 11:14:19, 你要挨打哦 <12...@qq.com.invalid> wrote:
> Thanks for your guidance. I have sent an email to
> dev-subscribe@apisix.apache.org <ma...@apisix.apache.org>
> and received a comfirmation email from dev-help@apisix.apache.org <mailto:
> dev-help@apisix.apache.org> who told me that The address
>
> 1253319389@qq.com <ma...@qq.com>
>
> was already on the dev mailing list when I received
> your request, and remains a subscriber.
>
> 2022年4月18日 上午10:53，Zhiyuan Ju <ju...@apache.org> 写道：
>
>
> Hi,
>
>
> Glad to hear from you!
>
>
> I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
> Please follow this guide[1] to subscribe and discuss.
>
>
> I am also waiting for more ideas about this feature request :)
>
>
> [1]
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
> <
> https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
> >
>
> Best Regards!
>
> @ Zhiyuan Ju <https://github.com/juzhiyuan>
>
>
> 你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
>
> 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 <
> 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 <
> 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.
>
>
>
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by 你要挨打哦 <12...@qq.com.INVALID>.
Thanks for your guidance. I have sent an email to dev-subscribe@apisix.apache.org <ma...@apisix.apache.org> and received a comfirmation email from dev-help@apisix.apache.org <ma...@apisix.apache.org> who told me that The address
1253319389@qq.com <ma...@qq.com>
was already on the dev mailing list when I received
your request, and remains a subscriber.
> 2022年4月18日 上午10:53，Zhiyuan Ju <ju...@apache.org> 写道：
>
> Hi,
>
> Glad to hear from you!
>
> I noticed you haven't subscribed to Apache APISIX's Dev Mailing List. Please follow this guide[1] to subscribe and discuss.
>
> I am also waiting for more ideas about this feature request :)
>
> [1] https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list <https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list>
> Best Regards!
> @ Zhiyuan Ju <https://github.com/juzhiyuan>
>
> 你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
> 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 <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 <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.
Re: [Feature Request]Add MySQL logger to persist logs from apisix
Posted by Zhiyuan Ju <ju...@apache.org>.
Hi,
Glad to hear from you!
I noticed you haven't subscribed to Apache APISIX's Dev Mailing List.
Please follow this guide[1] to subscribe and discuss.
I am also waiting for more ideas about this feature request :)
[1]
https://apisix.apache.org/zh/docs/general/join#subscribe-to-the-mailing-list
Best Regards!
@ Zhiyuan Ju <https://github.com/juzhiyuan>
你要挨打哦 <12...@qq.com.invalid> 于2022年4月18日周一 10:45写道：
> 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.