1. Configure System Time Ensure the system clock is synchronized: systemctl restart chronyd systemctl enable chronyd hwclock -w 2. Install Apache and MariaDB Install the required packages: yum -y install httpd mariadb mariadb-server systemctl enable --now httpd systemctl enable --now mariadb 3. Secu...
Download the binary tarball from the official MariaDB website. Ensure you select a version that aligns with your requirements; for instance, MariaDB 10.2 is functionally equivalent to MySQL 5.7. Consult the official installation guide for binary tarballs to understand the process. Before proceeding,...
While MySQL Enterprise Edition includes a proprietary audit plugin, MariaDB provides an open-source alternative known as the server_audit plugin. This tool allows administrators to track database activity, monitoring user connections, queries, and table access for security and compliance purposes. I...
Installing and Configuring MariaDB 1. Clock Synchronization Install Chrony, restart it, and enable it for automatic startup: sudo yum -y install chrony sudo systemctl restart chronyd sudo systemctl enable chronyd 2. Installing MariaDB and Apache HTTP Server Install the required packages: sudo yum -y...
Measure storage use in the Zabbix schema Identify which tables consume the most space before pruning. SELECT t.table_name AS tbl, ROUND((t.data_length + t.index_length) / 1024 / 1024, 2) AS size_mb FROM information_schema.tables AS t WHERE t.table_schema = 'zabbix' ORDER BY size_mb DESC; Large footp...
1. Agent fails to start, PID file missing, semaphore errors Sample logs: PID file /run/zabbix/zabbix_agentd.pid not readable (yet?) after start zabbix-agent.service never wrote its PID file. Failing Agent log indicates IPC/semaphore allocation failure: zabbix_agentd[5922]: cannot open log: cannot cr...
When Zabbix server starts and reports Z3001 with "Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’", it typically means Zabbix is pointing too a socket path that does not exist or differs from the one MySQL/MariaDB actually created. Symptom Example log excerpt...