Freaks City

Understanding MySQL Binary Logs The binary log (often called binlog) is a set of files that stores details about data modifications and potentially data-changing events. It captures operations like INSERT, UPDATE, and DELETE, along with timestamps and execution details. Queries that do not alter data, such as SELECT or SHOW, are omitted. These ...

MySQL Database Backup and Recovery Using mysqldump Overview of Backup Approaches MySQL database backups can be categorized into two primary types: Cold Backup Hot Backup Cold backup in MySQL doesn't have a dedicated tool. Instead, it involves shutting down the database and using OS commands to copy database files. Hot backup refers to online ...

Introduction to LVM What is LVM LVM (Logical Volume Manager) originated as IBM's storage management solution for AIX. It introduces a logical abstraction layer between physical disks and partitions, allowing multiple partitions or entire disks to be combined into a single logical volume (functioning as a virtual hard drive). This approach signi ...

1. Physical Drive InventoryTo recover a RAID 5 configuration after a disk failure or hardware relocation, execute the following command to list the status of all physical drives attached to Adapter 0. Ensure that application I/O is halted during this process to prevent data corruption.MegaCli -PDList -a02. Identifying the Failed DriveScan the o ...

Core Operational Controls The binary log captures server-side data modifications and schema changes, acting as the backbone for asynchronous replication, crash recovery, and auditing. Effective administration requires precise control over log generation, retention, and extraction workflows. -- Query active log files along with current disk util ...