Default repositories in CentOS 7 prioritize MariaDB over MySQL. Executing standard installation commands will result in MariaDB being deployed instead. To utilize the official MySQL packages via the package manager, the specific repository configuration must be added mnaually. Configure the Official...
Before proceeding, ensure your system meets minimum requirements: dual-core CPU, 2GB RAM (4GB+ recommended for concurrent services), and at least 30GB of free disk space. 1. Remove Conflicting Database Packages MySQL and MariaDB share similar binaries and configurations, leading to conflicts. Uninst...
Introduction to Percona XtraBackup Percona XtraBackup is an open-source tool for performing physical backups of MySQL databases. It supports hot backups, meaning data can be backed up without interrupting active transactions. This makes it iddeal for large databases where traditional logical backup...
This article focuses on logical data migration approaches in MySQL 8.0.25, particularly for small to medium-sized datasets (under 100MB). Recently, I installed MySQL 8.0.25 64-bit on Windows. It's evident that Oracle hasn't invested as much in MySQL as they have in their flagship Oracle database, wh...
Recovering data lost due to accidental deletion is a critical task in database administration. MySQL provides multiple mechanisms for data recovery, each suited to different scenarios. Restoring from Backups This method relies on previously created database backups. It recovers the database to the s...
MySQL Installation Uninstalling MySQL Before installing MySQL, it's important to properly uninstall any previous versions: Stop the MySQL service through the Task Manager Uninstall MySQL via Control Panel or using the installer's uninstall option Clean up residual files in installation and data dire...
MySQL User and Privilege Management This article summarizes the content from Professor Song Hongkang's course. 1. User Administration In MySQL, users can be categorized into regular users and root users. The root user has full privileges including creating, deleting, and modifying user passwords, wh...
Fetching and Storing Web Data This example deomnstrates a data pipeline for processing daily epidemic information. The core process involves retrieving JSON data from a web API, parsing the relevant details, and storing them in a MySQL database using batch operations. When handling a dataset conatin...
Currrent Environment Overview Our monitoring infrastructure consists of a central Zabbix server with multiple distributed proxies. The specific configuration details are as follows: Zabbix Server: Source installation, version 5.0.12, MySQL 5.7 (source installation) Zabbix Proxies: Installed via Yum...
Creating Triggers to Monitor Table Opreations This tutorial demonstrates how to implement triggers in MySQL to automatically log operations performed on a table. We'll create triggers that fire on INSERT, UPDATE, and DELETE operations, capturing each action in a separate tracking table. Dataabse Sch...