[Maria-discuss] How spy database alterations
Hi. Working with a web application (PHP, Nginx, MariaDB) that doesn't really work as expected, I'm looking for a way to monitor/spy database alterations done when some action is performed on the FrontEnd. It would be faster by far than to read the application's source code. So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ? Thanks ! P.S. : I know that I could add triggers on all database operation, but that would require adding a awful quantity of triggers and would not be easy to realize.
Am 20.07.2017 um 15:12 schrieb lemmel:
Working with a web application (PHP, Nginx, MariaDB) that doesn't really work as expected, I'm looking for a way to monitor/spy database alterations done when some action is performed on the FrontEnd. It would be faster by far than to read the application's source code.
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
general_log = 1 general_log_file = /var/log/mysql_query.log
Thanks. When it is so simple, one may feel dumb. Le jeudi 20 juillet 2017, 15:16:31 CEST Reindl Harald a écrit :
Am 20.07.2017 um 15:12 schrieb lemmel:
Working with a web application (PHP, Nginx, MariaDB) that doesn't really work as expected, I'm looking for a way to monitor/spy database alterations done when some action is performed on the FrontEnd. It would be faster by far than to read the application's source code.
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
general_log = 1 general_log_file = /var/log/mysql_query.log
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
You can enable/disable the general query log on the fly : https://mariadb.com/kb/en/mariadb/general-query-log/ Another solution is to use MaxScale as a proxy between the app and the database to log only specific queries : https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/maxscale-qu... And if you dont like MaxScale you can do something similar with MySQLProxy. Le 20/07/2017 à 15:12, lemmel a écrit :
Hi.
Working with a web application (PHP, Nginx, MariaDB) that doesn't really work as expected, I'm looking for a way to monitor/spy database alterations done when some action is performed on the FrontEnd. It would be faster by far than to read the application's source code.
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
Thanks !
P.S. : I know that I could add triggers on all database operation, but that would require adding a awful quantity of triggers and would not be easy to realize.
Thanks. As to MaxScale, it seems that is associated to the Enterprise version of MariaDB. As to MySQLProxy (https://downloads.mysql.com/archives/proxy/), it seems a now forsaken project (no release since 2014, url includes archives), and being superceeded by MySQL Router (the last being associated to InnoDB Cluster). I will use either general_log or audit-plugin. Thanks again, and sorry for having not look for enough in the docs (I was looking for monitoring or spy keywords and found nothing: I was a bit stupid). Le jeudi 20 juillet 2017, 15:17:04 CEST Jean Weisbuch a écrit :
You can enable/disable the general query log on the fly : https://mariadb.com/kb/en/mariadb/general-query-log/
Another solution is to use MaxScale as a proxy between the app and the database to log only specific queries : https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/maxscale-qu ery-log-all-filter/
And if you dont like MaxScale you can do something similar with MySQLProxy.
Le 20/07/2017 à 15:12, lemmel a écrit :
Hi.
Working with a web application (PHP, Nginx, MariaDB) that doesn't really work as expected, I'm looking for a way to monitor/spy database alterations done when some action is performed on the FrontEnd. It would be faster by far than to read the application's source code.
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
Thanks !
P.S. : I know that I could add triggers on all database operation, but that would require adding a awful quantity of triggers and would not be easy to realize.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
https://mariadb.com/kb/en/mariadb/about-the-mariadb-audit-plugin/ Imo more flexible than the general query log since you can include/exclude users/events. rr
Thanks for the suggestion: a new repository of tools (https://mariadb.com/kb/ en/mariadb/plugin-maturity/) ! Le jeudi 20 juillet 2017, 17:05:03 CEST Reinis Rozitis a écrit :
So is there a non-invasive way to monitor/spy database alterations performed after a given time, or triggered manually ?
https://mariadb.com/kb/en/mariadb/about-the-mariadb-audit-plugin/
Imo more flexible than the general query log since you can include/exclude users/events.
rr
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (4)
-
Jean Weisbuch -
lemmel -
Reindl Harald -
Reinis Rozitis