maria-discuss team mailing list archive

[Markus Mäkelä <markus.makela@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxxx
> 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