Store logs to LMS logs to MySQL


I’m currently writing a python script to process tracking.log for LMS.
I was wondering if there’s a configuration for storing activities on the MySQL database or another format that’s easier to load.
Currently, I need to remove the prefix on each line to extract the JSON which is not scalable.
This is an example of the prefix:
2022-06-24 16:06:22,515 INFO 19 [tracking] [user None] [ip] -

Any help would be appreciated.

You can take a look at the built-in connection to capture most of that data.
6. Analytics — Open edX Developer's Guide documentation