Thanks Rohan! Not only does it normalize Access and Error log data, it also tracks multiple clients uploading logs from multiple domains in multiple file formats to a centralized MySQL Server.
Table names starting with import_ provide management of clients, devices, upload processes, import processes, imported files, imported file formats, servers and errors.
Last few weeks we've been simultaneously uploading logs from 10 VPS with multiple VirtualHosts on each Server. We are running thousands of files in different formats and millions of log records through it. Current version is solid.
A Web interface built with Express web application frameworks with Drill Down Capability & Apache ECharts frameworks for Log Data Visualization in charts, reports & data analysis interfaces is in development for the MySQL Schema.
For more information and Entity Relationship Diagram of MySQL Database Schema apache_logs tables -
https://willthefarmer.github.io/