Automating MySQL Operations with Shell Scripts
MariaDB Installation
yum install mariadb mariadb-server mariadb-libs -y
systemctl start mariadb
netstat -tnlp | grep :3306
MariaDB runs without a default password, allowing direct access via the mysql command.
Database Setup
CREATE DATABASE school DEFAULT CHARACTER SET utf8;
Table Definitions
CREATE TABLE student (
s_id VARCHAR(20),
s ...
Posted on Tue, 23 Jun 2026 17:47:34 +0000 by IAK
Mastering Zabbix: Comprehensive Deployment, Agent Management, and Advanced Monitoring Architectures
System Baseline & Environment Hardening
Before deploying the monitoring stack, ensure the operating environment meets minimum requirements and security baselines. Synchronize system clocks, disable interference services, and verify network reachability.
# Verify release version and kernel architecture
cat /etc/redhat-release
uname -r
# Tem ...
Posted on Thu, 28 May 2026 22:01:40 +0000 by camdenite
Manual WordPress Deployment on Rocky Linux 8.9 with LAMP Stack
Environment Setup
Rocky Linux 8.9 is used as the depolyment environment. Install Apache, MariaDB, and PHP manually. Disable SELinux and firewalld for testing purposes:
# Set SELinux to permissive mode temporarily
setenforce 0
# Disable firewalld
systemctl stop firewalld
systemctl disable firewalld
Apache Configuration
Installation
yum install ...
Posted on Wed, 20 May 2026 01:59:38 +0000 by fragger
Installing MariaDB on Ubuntu Systems
MariaDB Installation Process
Execute the following command to install both server and client components:
sudo apt-get install mariadb-server mariadb-client
Verifying Installation Status
Checking Version
mysql --version
Example output:
mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64)
Checking Service Status
sudo service m ...
Posted on Sun, 17 May 2026 05:44:59 +0000 by TheFilmGod
Understanding and Implementing Zabbix for System Monitoring
Zabbix is an enterprise-grade open-source monitoring solution renowned for its ability to track the performance and availability of servers, networks, and applications. Before delving into Zabbix's specifics, it's beneficial to understand foundational monitoring concepts, particularly the Simple Network Management Protocol (SNMP), and to compar ...
Posted on Fri, 15 May 2026 19:27:38 +0000 by Marc