MariaDB compatible
1/30/2025 I attended a MariaDB webinar and was very impressed with technical knowledge and passion the four presenters conveyed about MariaDB. I spent that night installing database on MariaDB. Last night I ran 11,600 Apache Access and Error log files with 763,560 Access and 86,480 Error records thru both MySQL and MariaDB. MariaDB processes execute in about half the time as MySQL. I am liking MariaDB over MySQL. The Log Rotation functionality is very cool as well! Summary of changes below.
- [3.2.0] Database function and procedure modifications required for compatibility with MariaDB. Application processes have been tested with version 11.6. MariaDB tests twice as fast as MYSQL.
- [3.2.0] Major reworking of logs2mysql.py logging process messaging and incorporate Log File Rotation functionality with environment variables - BACKUP_DAYS and BACKUP_PATH
- [3.2.0] modify Store Function
apache_logs.importFileExistsfor Log File Rotation functionality. - [3.2.0] modify Store Function
apache_logs.importProcessIDfor compatibility with MariaDB. - [3.2.0] add Python function
def copy_backup_file(log_path_file, log_days)to reuse log file copy and delete functionality, - [3.2.0] add log summary to end of Python
processLogsinlogs2mysql.pyto provide more process information to PM2 logs.