Hi all, I have setup a maxscale instance to proxy to the local mysql server running on a different port. All this is working fine. I have also setup a filter to catch deletes on a single table. I can see the deletes in the filter but only when I restart maxscale service. Is there something that I can set so that the log is flushed immediately to the flle. The filter definition is the following [WaCountriesDomainsDeleteFilter] type=filter module=qlafilter options=ignorecase,extended filebase=/tmp/maxscale.wa_countries_domains.delete match=DELETE.*wa_countries_domains.* log_type=unified append=true kind regards -- Atif Ghaffar
Got my answer from reading the sourcecode.. https://github.com/mariadb-corporation/MaxScale/blob/2.1/server/modules/filt... I must set flush=true Was also in the documentation but I missed it. kind regards -- Atif Ghaffar On Tue, Jun 6, 2017 at 4:38 PM, Atif Ghaffar <atif.ghaffar@gmail.com> wrote:
Hi all,
I have setup a maxscale instance to proxy to the local mysql server running on a different port. All this is working fine.
I have also setup a filter to catch deletes on a single table.
I can see the deletes in the filter but only when I restart maxscale service.
Is there something that I can set so that the log is flushed immediately to the flle.
The filter definition is the following
[WaCountriesDomainsDeleteFilter] type=filter module=qlafilter options=ignorecase,extended filebase=/tmp/maxscale.wa_countries_domains.delete match=DELETE.*wa_countries_domains.* log_type=unified append=true
kind regards -- Atif Ghaffar
Hi, (Cross-posting to the MaxScale mailing list) Currently the filter flushes the log files to disk after the session is closed. If you are using MaxScale 2.1, you can use the /flush=true/ parameter to flush messages to the log after each write. The 2.1 qlafilter documentation can be found here <https://mariadb.com/kb/en/mariadb-enterprise/6328/>. Flushing the log to disk at a set intervals instead of after every write sounds like a good addition to the filter, perhaps you could drop a feature request on the MaxScale Jira <https://jira.mariadb.org/browse/MXS>? Markus On 06/06/17 17:38, Atif Ghaffar wrote:
Hi all,
I have setup a maxscale instance to proxy to the local mysql server running on a different port. All this is working fine.
I have also setup a filter to catch deletes on a single table.
I can see the deletes in the filter but only when I restart maxscale service.
Is there something that I can set so that the log is flushed immediately to the flle.
The filter definition is the following
[WaCountriesDomainsDeleteFilter] type=filter module=qlafilter options=ignorecase,extended filebase=/tmp/maxscale.wa_countries_domains.delete match=DELETE.*wa_countries_domains.* log_type=unified append=true
kind regards -- Atif Ghaffar
_______________________________________________ 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
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
participants (2)
-
Atif Ghaffar -
Markus Mäkelä