I know how grok pattern works a little bit but not sure if it can do more work.
Here is what I want to do:
Use logparser to parse MySQL logs. capture lines which contain ‘start semi_sync’ or ‘stop semi_sync’.
Once it matched ‘start semi_sync’, convert it to number 1. Once it matched ‘stop semi_sync’, convert it to number 0. Upload the data into Influxdb and Grafana can display it.
The reason I need to convert string to int is because I don’t think Grafana can display string in the dashboard. Correct me if I am wrong.