maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04746
Re: How spy database alterations
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
References