BestHub
Sign in
Tagged articles
170 articles
Page 1 of 2
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

BackupDatabase AdministrationRecovery
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
ITPUB
ITPUB
Mar 5, 2026 · Databases

How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide

This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.

Data RecoveryDatabase AdministrationOracle
0 likes · 5 min read
How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide
Ops Community
Ops Community
Mar 3, 2026 · Databases

Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning

This comprehensive guide walks you through PostgreSQL 17 deployment, explains its multi‑process architecture and MVCC model, details environment requirements, shows essential configuration parameters, provides step‑by‑step backup and PITR procedures, demonstrates streaming replication setup, and shares best‑practice tuning, security, and monitoring tips for reliable production use.

BackupDatabase AdministrationHA
0 likes · 24 min read
Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2026 · Databases

Essential MySQL Replication Best Practices to Keep Your Replicas Stable

This guide presents practical, DBA‑tested MySQL replication best practices—including GTID, row‑based replication, mandatory primary keys, schema consistency, binlog tuning, read‑only protection, dedicated replication users, latency monitoring, parallel workers, and SSL encryption—to ensure reliable, predictable replica behavior.

Database AdministrationGTIDReplication
0 likes · 9 min read
Essential MySQL Replication Best Practices to Keep Your Replicas Stable
IT Xianyu
IT Xianyu
Jan 17, 2026 · Databases

Master Oracle OCP Exam: Tablespaces, Privileges, and RMAN Backup Explained

This article walks through three common Oracle OCP exam questions—distinguishing permanent, temporary, and UNDO tablespaces, choosing the correct object versus system privilege syntax, and selecting the safest RMAN command for a hot backup—providing detailed explanations and the correct answers.

Database AdministrationOCPOracle
0 likes · 6 min read
Master Oracle OCP Exam: Tablespaces, Privileges, and RMAN Backup Explained
Ray's Galactic Tech
Ray's Galactic Tech
Dec 26, 2025 · Databases

Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops

This comprehensive guide explains PostgreSQL's Write-Ahead Logging (WAL) fundamentals, its role in durability, crash recovery, PITR and streaming replication, details the checkpoint mechanism, essential monitoring queries, production‑grade configuration recommendations, backup and recovery procedures, and practical DBA checklists for reliable operations.

Database AdministrationReplicationWAL
0 likes · 7 min read
Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops
Ray's Galactic Tech
Ray's Galactic Tech
Dec 11, 2025 · Databases

Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing

An in‑depth guide to MySQL binary logs explains their role in replication, point‑in‑time recovery, auditing, and real‑time data pipelines, covering binlog formats, GTID, encryption, multi‑threaded replication, cleanup strategies, and practical mysqlbinlog commands for monitoring and troubleshooting.

BinlogDatabase AdministrationRecovery
0 likes · 10 min read
Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing
Raymond Ops
Raymond Ops
Nov 28, 2025 · Databases

Essential DBA Guide to Enterprise MySQL Architecture, Optimization & Ops

This comprehensive guide equips DBAs with enterprise‑level MySQL strategies, covering master‑slave replication, InnoDB cluster setup, performance tuning parameters, index design, backup and recovery methods, monitoring scripts, security hardening, and emergency response procedures to ensure a stable, high‑performance database environment.

Database Administrationbackup and recoverymonitoring
0 likes · 15 min read
Essential DBA Guide to Enterprise MySQL Architecture, Optimization & Ops
dbaplus Community
dbaplus Community
Nov 13, 2025 · Databases

Why Modern DBAs Must Evolve into Data‑Business Architects (DBA²)

The article explores the challenges faced by traditional DBAs, redefines the DBA role as a blend of data, business, administration and architecture, presents multiple real‑world cases, and shows how AI and a DBA² mindset can dramatically improve efficiency and career prospects.

AI integrationBusiness strategyCareer Development
0 likes · 19 min read
Why Modern DBAs Must Evolve into Data‑Business Architects (DBA²)
ITPUB
ITPUB
Oct 7, 2025 · Operations

100+ Essential IT Operations Checklist to Keep Your Infrastructure Running Smoothly

This comprehensive guide presents a standardized operations manual covering over one hundred core maintenance checkpoints across server hardware, network devices, storage systems, operating systems, databases, virtualization platforms, backup solutions, security appliances, and data‑center facilities, helping IT teams ensure stable and reliable service delivery.

Database AdministrationIT OperationsInfrastructure Maintenance
0 likes · 34 min read
100+ Essential IT Operations Checklist to Keep Your Infrastructure Running Smoothly
ITPUB
ITPUB
Oct 6, 2025 · Databases

What Happens When a KingbaseES License Expires? A Practical Guide

This article explains the structure of KingbaseES license files, distinguishes commercial and non‑commercial license types, describes the actual behavior of the database when a license expires, and provides step‑by‑step workarounds such as OS date tweaking, license inspection, file replacement, and server reload commands.

Database AdministrationDatabase LicenseKingbaseES
0 likes · 10 min read
What Happens When a KingbaseES License Expires? A Practical Guide
Raymond Ops
Raymond Ops
Sep 16, 2025 · Databases

One‑Click MariaDB Binary Installation Across Major Linux Distros

This guide walks you through installing MariaDB from binary packages on various Linux distributions, covering user and group creation, downloading and extracting the tarball, configuring environment variables and my.cnf, initializing the database, securing the installation, testing the server, and using a ready-made shell script for automated deployment.

Binary InstallationDatabase AdministrationLinux
0 likes · 22 min read
One‑Click MariaDB Binary Installation Across Major Linux Distros
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 10, 2025 · Databases

Master SQL Server Operations: From Installation to High‑Availability

The Aikexing open‑source community announces a giveaway of the technical book “SQL Server Operations Guide”, detailing its four‑part content on installation, performance tuning, security, multimodal data, and high‑availability architecture, authored by veteran DBA Lin Yonghua, and inviting beginners, developers, and educators to participate.

Book GiveawayDatabase AdministrationSQL Server
0 likes · 12 min read
Master SQL Server Operations: From Installation to High‑Availability
Raymond Ops
Raymond Ops
Aug 14, 2025 · Databases

Master MySQL Log Management: Error, General, Binlog & Slow Query Tips

This guide explains MySQL logging types—including error, general, binary, and slow query logs—their default settings, how to enable or modify them, how to view and interpret log contents, and practical commands for backup, recovery, and cleanup.

Database AdministrationLog Managementbinary log
0 likes · 11 min read
Master MySQL Log Management: Error, General, Binlog & Slow Query Tips
ITPUB
ITPUB
Aug 5, 2025 · Databases

Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime

This guide details how to restore a CDH cluster after MySQL metadata loss caused by an accidental deletion of the MySQL data directory, covering database locking, locating deleted file handles, reconstructing shared and independent tablespaces, and verifying consistency to bring the platform back online quickly.

CDHData RecoveryDatabase Administration
0 likes · 6 min read
Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime
dbaplus Community
dbaplus Community
Jul 20, 2025 · Databases

Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide

This guide walks through diagnosing a MySQL metadata loss in a CDH cluster, locking the database, locating deleted file handles, restoring shared and independent tablespace files, fixing table structures, verifying consistency, and explains the underlying Linux and MySQL mechanisms.

CDHData RecoveryDatabase Administration
0 likes · 6 min read
Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL backup strategies, compares full, incremental, and differential backups, details built‑in tools like mysqldump, mysqlpump, and third‑party solutions such as Percona XtraBackup, and provides scripts, scheduling tips, verification methods, and best‑practice recommendations for secure data protection and recovery.

Database AdministrationRecoverymysql
0 likes · 23 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
MaGe Linux Operations
MaGe Linux Operations
Jul 5, 2025 · Databases

Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization

This comprehensive guide walks DBAs through enterprise‑level MySQL architecture, master‑slave replication, high‑availability clustering, performance tuning, index optimization, backup and recovery strategies, monitoring, security hardening, fault diagnosis, and best‑practice checklists to build a stable, efficient, and secure database environment.

Database Administrationbackup and recoverymysql
0 likes · 15 min read
Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization
MaGe Linux Operations
MaGe Linux Operations
Jun 14, 2025 · Databases

Essential DM Database Management SQL Commands You Need to Know

This guide presents a comprehensive collection of frequently used SQL commands for managing the DM (DaMeng) database, covering version and license queries, server configuration, session monitoring, object management, tablespace handling, backup procedures, and performance tuning, all illustrated with clear examples and code snippets.

DM DatabaseDatabase AdministrationSQL Commands
0 likes · 6 min read
Essential DM Database Management SQL Commands You Need to Know
Practical DevOps Architecture
Practical DevOps Architecture
May 29, 2025 · Databases

Quick Solutions for MySQL Table Locks

This guide outlines a step‑by‑step method to diagnose and release MySQL table locks by checking open tables, inspecting running processes, querying InnoDB transaction and lock tables, and generating KILL statements to terminate blocking sessions.

Database Administrationmysqlsql
0 likes · 3 min read
Quick Solutions for MySQL Table Locks
ITPUB
ITPUB
Apr 26, 2025 · Databases

SQL Server Admin Essentials: Monitoring, Backup, Performance Tuning & Users

This guide compiles a comprehensive set of SQL Server commands for administrators, covering version checks, server and database properties, connection statistics, backup and restore procedures, user and role management, performance diagnostics, cache cleanup, and various maintenance tasks to streamline daily operations.

BackupDatabase AdministrationRestore
0 likes · 19 min read
SQL Server Admin Essentials: Monitoring, Backup, Performance Tuning & Users
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2025 · Databases

Implementing a MySQL Configuration Comparison Script: Key Considerations and Common Pitfalls

This article explains how to build a MySQL configuration comparison script by retrieving runtime variable values, parsing my.cnf and mysqld-auto.cnf files, handling formatting and case issues, and accurately comparing values while addressing typical challenges such as unit conversion, boolean representation, and legacy variable names.

Database AdministrationShellawk
0 likes · 8 min read
Implementing a MySQL Configuration Comparison Script: Key Considerations and Common Pitfalls
IT Xianyu
IT Xianyu
Apr 15, 2025 · Databases

What Does a DBA Do? A Beginner’s Guide to Database Administration, Core Skills, and Career Path

This article explains the role of a DBA using a library analogy, outlines essential database fundamentals, Linux commands, hardware choices, common pitfalls, cloud‑era advantages, intelligent operations, and provides a detailed career roadmap with salary insights for aspiring database administrators.

Career DevelopmentCloud DatabasesDatabase Administration
0 likes · 6 min read
What Does a DBA Do? A Beginner’s Guide to Database Administration, Core Skills, and Career Path
MaGe Linux Operations
MaGe Linux Operations
Jan 29, 2025 · Databases

Master MySQL Log Management: From Error to Slow Query Logs

This guide explains MySQL’s error, general, binary, and slow query logs, covering default settings, how to enable or modify them, binary log formats and recovery procedures, as well as tools for analyzing slow queries, providing a comprehensive reference for database administrators.

Database AdministrationLog Managementbinary log
0 likes · 11 min read
Master MySQL Log Management: From Error to Slow Query Logs
Top Architect
Top Architect
Dec 5, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article explains how database administrators can monitor system resource usage with commands like top, iostat, and vmstat, and configure MySQL slow query logging, including enabling the log, setting thresholds, viewing logs, and applying best‑practice recommendations for analysis and issue resolution.

Database AdministrationSlow Query Loglinux-commands
0 likes · 8 min read
Database Monitoring and Slow Query Log Management Guide
dbaplus Community
dbaplus Community
Oct 27, 2024 · Databases

Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts

This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.

BackupDatabase AdministrationOracle
0 likes · 19 min read
Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts
ITPUB
ITPUB
Oct 15, 2024 · Databases

8 Essential MongoDB Admin Scripts to Master Database Management

This guide presents eight practical MongoDB shell scripts—covering database size analysis, connection monitoring, long‑running query termination, table‑scan detection, replica‑set health checks, and slow‑query profiling—plus usage tips and cautions for reliable administration.

Database AdministrationMongoDBPerformance Monitoring
0 likes · 15 min read
8 Essential MongoDB Admin Scripts to Master Database Management
Java Architecture Stack
Java Architecture Stack
Oct 10, 2024 · Databases

Master MySQL Backup & Recovery: Strategies for Every Business Scenario

This guide walks through five practical MySQL backup and restoration workflows—including scheduled full backups, hourly incremental binlog backups for high‑frequency trading, development‑environment data masking, selective table dumps, and cold‑storage disaster recovery—providing exact commands, configuration tweaks, and step‑by‑step procedures.

BackupDatabase AdministrationIncremental Backup
0 likes · 7 min read
Master MySQL Backup & Recovery: Strategies for Every Business Scenario
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2024 · Databases

Understanding and Managing MySQL Undo Tablespaces

This article explains the purpose, evolution, configuration parameters, and step‑by‑step maintenance procedures for MySQL Undo tablespaces, covering versions from pre‑5.6 to 8.0 and providing practical commands for viewing, creating, truncating, and dropping Undo tablespaces.

Database AdministrationInnoDBUndo Tablespace
0 likes · 11 min read
Understanding and Managing MySQL Undo Tablespaces
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 8, 2024 · Databases

Understanding LOG_DISK Resource Limits and Tenant Memory Allocation in OceanBase

This article analyzes why creating a resource pool with 4C12G fails in an OceanBase single‑node cluster despite sufficient CPU and memory, explains the relationship between LOG_DISK size and tenant memory, provides calculation formulas, verification steps, and practical recommendations to avoid LOG_DISK resource shortages.

Database AdministrationLOG_DISKOceanBase
0 likes · 11 min read
Understanding LOG_DISK Resource Limits and Tenant Memory Allocation in OceanBase
Open Source Linux
Open Source Linux
Jun 12, 2024 · Databases

How to Reset MySQL Root Password and Manage User Accounts Safely

This guide walks through three common MySQL administration scenarios—resetting the root password using skip‑grant‑tables, adding new user accounts with proper privileges, and changing passwords via UPDATE, SET PASSWORD, ALTER USER, GRANT, or mysqladmin—while highlighting version‑specific commands and security considerations.

Database AdministrationRoot PasswordUser Management
0 likes · 7 min read
How to Reset MySQL Root Password and Manage User Accounts Safely
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2024 · Databases

OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path

The OceanBase community offers a detailed, eight‑session DBA tutorial covering the platform’s architecture, deployment, migration, performance tuning, diagnostic tools, and ecosystem components, complemented by live streaming, hands‑on exercises, certification incentives, and real‑world user testimonials to help developers and DBAs master this distributed database.

Database AdministrationOceanBaseTutorial
0 likes · 9 min read
OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2024 · Databases

Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer

The article investigates why altering a MySQL VARCHAR column from a length that fits within 255 bytes to one that exceeds this limit (e.g., VARCHAR(63) to VARCHAR(64) in utf8mb4) triggers a costly copy operation, analyzes the storage mechanics, reproduces the issue, and provides practical recommendations to avoid performance penalties.

Character SetDatabase AdministrationOnline DDL
0 likes · 13 min read
Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer
MaGe Linux Operations
MaGe Linux Operations
Apr 22, 2024 · Databases

How to Reset MySQL Root Password and Manage User Grants Safely

This guide walks through three MySQL administration scenarios—resetting the root password using the --skip-grant-tables option, adding user accounts with proper grants, and changing passwords via UPDATE, SET PASSWORD, ALTER USER, GRANT, and mysqladmin—providing step‑by‑step commands and precautions.

Database AdministrationRoot PasswordUser Management
0 likes · 7 min read
How to Reset MySQL Root Password and Manage User Grants Safely
dbaplus Community
dbaplus Community
Apr 18, 2024 · Databases

How I Rescued a MySQL Table After a Massive Bad‑Group Insertion

A Java developer recounts a production MySQL outage caused by a faulty batch insert, walks through failed delete and lock‑free attempts, then details a series of table‑recreation, truncate, and index‑rebuilding steps that finally restored data integrity and performance.

DDLDatabase AdministrationIndex Recovery
0 likes · 13 min read
How I Rescued a MySQL Table After a Massive Bad‑Group Insertion
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2024 · Databases

Understanding MySQL Instant DDL: What DBAs Should Know

The article explains MySQL 8.0's INSTANT DDL algorithm, its default behavior, limitations such as the 64‑change cap, and provides practical recommendations for always specifying the algorithm, monitoring instant changes via INFORMATION_SCHEMA, and safely rebuilding tables when needed.

Database AdministrationInnoDBInstant DDL
0 likes · 7 min read
Understanding MySQL Instant DDL: What DBAs Should Know
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 30, 2024 · Databases

Troubleshooting VARCHAR Column Expansion Issues with MySQL Online DDL

This article analyzes why ALTER TABLE operations that extend VARCHAR columns sometimes fail in MySQL, explains the underlying Online DDL constraints, presents several real‑world problems such as default‑value handling, indexed columns, and hidden table‑rebuild quirks, and offers practical solutions for each case.

ALTER TABLEDatabase AdministrationOnline DDL
0 likes · 17 min read
Troubleshooting VARCHAR Column Expansion Issues with MySQL Online DDL
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 20, 2023 · Information Security

MySQL User Security Hardening: Password Policy, Connection Control, and Password Change Strategies

This article details how to strengthen MySQL user security by implementing comprehensive password complexity requirements, connection control policies, and password change strategies, including configuration of the validate_password component, connection_control plugin, and password expiration settings for MySQL 5.7 and 8.0, with practical examples and code snippets.

Connection ControlDatabase AdministrationPassword policy
0 likes · 21 min read
MySQL User Security Hardening: Password Policy, Connection Control, and Password Change Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 30, 2023 · Databases

Step‑by‑Step In‑Place Upgrade Guide for MySQL 8.0 (MGR Cluster)

This article provides a comprehensive, step‑by‑step guide for performing an in‑place upgrade of MySQL 8.0 (including MGR clusters) from earlier versions, covering pre‑upgrade checks, backup procedures, configuration changes, data dictionary upgrade, server upgrade, verification, rollback, and common pitfalls.

Database AdministrationMGRReplication
0 likes · 15 min read
Step‑by‑Step In‑Place Upgrade Guide for MySQL 8.0 (MGR Cluster)
MaGe Linux Operations
MaGe Linux Operations
Oct 23, 2023 · Databases

Master Oracle Daily Health Checks: Essential Commands for DB Stability

This guide details essential Oracle database daily inspection commands—covering instance status, tablespace health, resource usage, performance metrics, server CPU/memory/I/O checks, and security audits—to help DBAs ensure system stability and quickly diagnose issues.

Daily InspectionDatabase AdministrationOracle
0 likes · 11 min read
Master Oracle Daily Health Checks: Essential Commands for DB Stability
dbaplus Community
dbaplus Community
Oct 16, 2023 · Databases

How to Monitor MySQL Performance in Real-Time with mysqlstat

The mysqlstat command‑line tool provides real‑time monitoring and analysis of MySQL servers, offering metrics such as QPS, TPS, network bandwidth, top‑executed SQL statements, hot tables, lock and deadlock information, index analysis, connection counts, table size statistics, binlog insights, and replication status, with usage examples and download instructions.

Database AdministrationPerformance Monitoringcommand-line
0 likes · 8 min read
How to Monitor MySQL Performance in Real-Time with mysqlstat
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 16, 2023 · Databases

The Evolving Role of Database Administrators: Challenges, Changes, and Future Trends (2023)

The article examines how the responsibilities of database administrators are shifting due to massive data volumes, heightened security concerns, cloud adoption, DevOps integration, and emerging AI and IoT technologies, outlining current challenges, recent changes, and key trends shaping the DBA profession.

Artificial IntelligenceDBADatabase Administration
0 likes · 7 min read
The Evolving Role of Database Administrators: Challenges, Changes, and Future Trends (2023)
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 12, 2023 · Databases

Understanding MySQL 8.0 Password Policy Options and Common Misunderstandings

This article analyzes MySQL 8.0 password‑related parameters, explains the meaning of NULL values in the mysql.user table, demonstrates how global settings interact with per‑user attributes, and clarifies the priority rules between password_history and password_reuse_interval through practical test scenarios.

ALTER USERCREATE USERDatabase Administration
0 likes · 9 min read
Understanding MySQL 8.0 Password Policy Options and Common Misunderstandings
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 14, 2023 · Databases

Using MySQL 8.0.34 validate_password.changed_characters_percentage to Enforce Password Change Requirements

MySQL 8.0.34 adds the validate_password.changed_characters_percentage variable, allowing administrators to require a minimum percentage of different characters when users change passwords, and the article demonstrates how to enable the policy, set up a test environment, and verify behavior with various password change scenarios.

Database Administrationchanged_characters_percentagemysql
0 likes · 11 min read
Using MySQL 8.0.34 validate_password.changed_characters_percentage to Enforce Password Change Requirements
Efficient Ops
Efficient Ops
Aug 9, 2023 · Databases

Elevating DBA Skills: Practical Insights from a Bank’s Database Team

This article explores how bank DBAs continuously improve their capabilities through standardized daily inspections, automated environment provisioning, careful upgrade planning, development support, and disciplined incident response, while also encouraging a broader understanding of diverse database technologies and core relational concepts.

Database AdministrationRelational DatabasesSQL Performance
0 likes · 9 min read
Elevating DBA Skills: Practical Insights from a Bank’s Database Team
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2023 · Databases

Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch

This article explains the MySQL event_scheduler thread, why killing it during master‑slave failover produces an "Unknown thread id" warning in MySQL 8.0, how to manage events, and the impact of these internal daemon sessions on replication and failover processes.

Database AdministrationEvent SchedulerMaster-Slave Switch
0 likes · 15 min read
Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch
Laravel Tech Community
Laravel Tech Community
Jun 7, 2023 · Databases

MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures

This article explains the differences between MySQL logical and physical backups, introduces Percona XtraBackup, provides step‑by‑step installation commands, details common parameters, and demonstrates full and incremental backup and recovery workflows with practical code examples.

Database AdministrationIncremental BackupPercona XtraBackup
0 likes · 13 min read
MySQL Logical vs Physical Backup and Percona XtraBackup Installation, Configuration, and Backup/Restore Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 27, 2023 · Databases

Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

Database AdministrationDumpFreeze
0 likes · 14 min read
Diagnosing Freeze and Dump Issues in OceanBase Memstore
ITPUB
ITPUB
Mar 8, 2023 · Databases

Why Cloud Migration Won’t Make DBAs Obsolete – New Roles and Challenges

Moving databases to the cloud changes DBA tasks but does not eliminate the role; it introduces new responsibilities such as migration planning, cross‑cloud compatibility, performance tuning, and acting as a bridge between cloud providers and enterprises.

Cloud DatabasesDBADatabase Administration
0 likes · 10 min read
Why Cloud Migration Won’t Make DBAs Obsolete – New Roles and Challenges
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

Database AdministrationOceanBaseTenant Deletion
0 likes · 7 min read
OceanBase Tenant Deletion Methods and Syntax
ITPUB
ITPUB
Feb 20, 2023 · Databases

18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills

Discover 18 essential MySQL 8.0 management enhancements—including persistent global variables, admin IP/port settings, minimal installation packages, resource groups, read‑only databases, improved SHOW PROCESSLIST, instant DDL, faster DROP/TRUNCATE, OS thread visibility, connection memory limits, enriched slow‑log details, backup options, Clone plugin, upgrade process, client defaults, and RESTART command usage.

8.0Database Administrationmysql
0 likes · 12 min read
18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills
dbaplus Community
dbaplus Community
Feb 14, 2023 · Databases

10 Common PostgreSQL Mistakes and How to Avoid Them

This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.

BackupConnection PoolingDatabase Administration
0 likes · 16 min read
10 Common PostgreSQL Mistakes and How to Avoid Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2023 · Databases

Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views

This article analyzes why MySQL 8.0 reports an illegal mix of collations when querying a view that joins tables with different character sets, demonstrates reproducing the issue, explains the role of the CONVERT function and default collation variables, and provides practical recommendations to avoid such errors.

Character SetConvert FunctionDatabase Administration
0 likes · 9 min read
Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2023 · Databases

Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug

The article explains how MySQL Shell 8.0.31's util.debug component provides built‑in functions to gather comprehensive diagnostic data—including error logs, replica status, InnoDB metrics, and OS metrics—and demonstrates practical command‑line examples for generating and analyzing zip‑packed diagnostic reports.

Database AdministrationMySQL Shellcollect_diagnostics
0 likes · 8 min read
Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug
Open Source Linux
Open Source Linux
Jan 10, 2023 · Databases

Essential MySQL Scripts: Export, Import, and Manage Databases & Tables

This guide compiles a comprehensive set of MySQL command‑line scripts for exporting whole databases, individual tables or schemas, importing data, and performing common database and table operations such as creation, selection, alteration, deletion, granting privileges, and viewing structure, all illustrated with ready‑to‑use code examples.

DDLData ExportDatabase Administration
0 likes · 11 min read
Essential MySQL Scripts: Export, Import, and Manage Databases & Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 28, 2022 · Databases

Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure

This article describes the background, architecture, and a detailed troubleshooting process for restoring a mistakenly deleted Greenplum standby data directory, including status checks, configuration cleanup, standby initialization, verification commands, and additional recommendations for handling master failures in a distributed database cluster.

Database AdministrationGreenplumStandby Recovery
0 likes · 10 min read
Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure
Top Architect
Top Architect
Aug 20, 2022 · Databases

Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips

An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.

BackupDatabase AdministrationReplication
0 likes · 24 min read
Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 16, 2022 · Databases

Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL

This article explains why Percona Xtrabackup backups of MySQL 5.7 can fail with "Too many open files" errors, demonstrates how to reproduce the issue under both non‑root and root users, analyzes the open‑files‑limit settings, and provides practical solutions to adjust system and user limits for successful backups.

BackupDatabase AdministrationLinux
0 likes · 12 min read
Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL
Architect's Guide
Architect's Guide
Mar 2, 2022 · Databases

How to Perform Scheduled MySQL Backups Using mysqldump and Cron

This article explains various methods for scheduled MySQL backups, covering mysqldump command usage, example backup commands for whole or specific databases, a Bash script to retain a fixed number of backups, and configuring cron jobs to automate the backup and restoration processes.

BackupBashDatabase Administration
0 likes · 11 min read
How to Perform Scheduled MySQL Backups Using mysqldump and Cron
ITPUB
ITPUB
Jan 29, 2022 · Databases

Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices

This guide explains MySQL’s permission system, shows how to configure remote access for the root user by setting the host field to ‘%’, granting all privileges, flushing privileges, and clarifies the role of the skip‑grant‑tables option, while detailing the underlying tables and privilege levels.

Database AdministrationGrantPermissions
0 likes · 7 min read
Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices
Qunar Tech Salon
Qunar Tech Salon
Dec 20, 2021 · Databases

From Database Development to the New DBA: Strategies for Efficiency, Automation, and Career Growth

The article shares the author’s journey from early database development at DM6/DM7 through MySQL operations at Qunar, offering practical advice on demand‑driven implementation, data‑driven management, intelligent alerting, full‑log analysis, slow‑query risk modeling, high‑availability, and automation to transform traditional DBA work into a proactive, efficient New DBA role.

Database Administrationautomationmysql
0 likes · 31 min read
From Database Development to the New DBA: Strategies for Efficiency, Automation, and Career Growth
Liangxu Linux
Liangxu Linux
Oct 7, 2021 · Databases

Automate MySQL Backups with Bash and Cron

This guide explains why database backups are essential, walks through checking disk space, creating a backup directory, writing a MySQL dump script, making it executable, scheduling it with cron, and verifying that backups run reliably on a Linux server.

Database AdministrationLinuxcron
0 likes · 6 min read
Automate MySQL Backups with Bash and Cron
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 30, 2021 · Databases

Modifying Trusted IP Whitelist for MySQL Users

This article explains how MySQL implements trusted IP access control via user@host definitions, demonstrates creating and updating user accounts and associated metadata tables, and provides step‑by‑step procedures—including DCL commands, metadata updates, and handling of stored objects—to safely modify trusted IPs in production environments.

Database AdministrationTrusted IPUser Management
0 likes · 20 min read
Modifying Trusted IP Whitelist for MySQL Users
Qunar Tech Salon
Qunar Tech Salon
Sep 1, 2021 · Databases

Implementing Transparent Table Partitioning in PostgreSQL: Strategies, Code Samples, and Performance Gains

This article explains why and when to use table partitioning in PostgreSQL, describes inheritance‑based and declarative partitioning methods (list, range, hash), provides complete SQL and C code examples for creating and maintaining partitions, compares version differences, and shows a real‑world performance improvement case from Qunar.

C extensionsDatabase AdministrationSQL Performance
0 likes · 24 min read
Implementing Transparent Table Partitioning in PostgreSQL: Strategies, Code Samples, and Performance Gains
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2021 · Databases

Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors

The article explains why MySQL can hit the max_connections limit, introduces the MySQL 8.0 administrative connection interface and its configuration variables, demonstrates how to create a privileged user and test connection limits with code examples, and offers best‑practice recommendations to prevent connection saturation.

Administrative Connection InterfaceConnection PoolingDatabase Administration
0 likes · 9 min read
Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors
dbaplus Community
dbaplus Community
Aug 1, 2021 · Databases

Bind Slow MySQL Queries to Resource Groups with a Simple PHP Tool

This guide introduces a PHP utility that automatically assigns slow MySQL statements (running over 10 seconds) to a dedicated CPU core using MySQL 8.0 resource groups, explaining installation, configuration, execution, and verification steps, along with required system capabilities.

Database AdministrationPHPResource Groups
0 likes · 5 min read
Bind Slow MySQL Queries to Resource Groups with a Simple PHP Tool
Liangxu Linux
Liangxu Linux
Jul 4, 2021 · Databases

How to Automate MySQL Backups with Shell Scripts and Cron

This guide explains why database backups are essential, walks through creating a backup directory, writing a mysqldump shell script, compressing the dump, granting execution rights, and scheduling the script with cron to run every minute.

Database AdministrationLinuxcron
0 likes · 6 min read
How to Automate MySQL Backups with Shell Scripts and Cron
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2021 · Databases

Designing an Online DDL Work Order System for MySQL

This article examines the pain points of MySQL DDL operations for large tables, analyzes the limitations of online DDL, compares tools like gh‑ost and pt‑osc, and outlines a comprehensive workflow and implementation details for an automated online DDL work‑order system.

DDLDatabase AdministrationOnlineDDL
0 likes · 9 min read
Designing an Online DDL Work Order System for MySQL
ITPUB
ITPUB
Apr 20, 2021 · Databases

How to Rescue MySQL Data from a Crashed Linux VM Using LVM

This guide walks through a step‑by‑step experiment that shows how to recover MySQL files from a Linux virtual machine that cannot boot, by mounting its disk on a new VM, activating LVM volumes, copying configuration and data files, and restarting the database.

Data RecoveryDatabase AdministrationLVM
0 likes · 7 min read
How to Rescue MySQL Data from a Crashed Linux VM Using LVM
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 18, 2021 · Databases

Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication

The article experimentally evaluates three ways of creating replication users—only on the master, separately on master and slave with CREATE statements, and separately with GRANT statements—to show how each method affects MySQL 5.7 master‑slave replication, error handling, and compatibility with GTID and MySQL 8.0.

Database AdministrationGTIDGrant
0 likes · 8 min read
Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2021 · Information Security

Configuring SELinux for MySQL: Managing Access Controls and Directory Contexts

This article explains how SELinux enforces mandatory access control on Linux, describes its three modes, shows how to view and modify SELinux contexts for MySQL processes and data directories, and provides step‑by‑step commands to add custom paths, logs, PID files, and ports while preserving system security.

Database AdministrationLinux securitySELinux
0 likes · 8 min read
Configuring SELinux for MySQL: Managing Access Controls and Directory Contexts
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 21, 2020 · Databases

MySQL Backup and Recovery: Strategies, Tools, and Best Practices

This article explains the importance of MySQL backup and recovery, outlines common failure scenarios, recommends backup architectures and verification processes, reviews popular logical and physical backup tools such as mysqldump, mydumper, and xtrabackup, and shares practical case studies and best‑practice guidelines.

BackupDatabase AdministrationRecovery
0 likes · 10 min read
MySQL Backup and Recovery: Strategies, Tools, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 18, 2020 · Databases

How to Persist Global System Variables in MySQL 8

This article explains MySQL 8's persisted system variables feature, showing how to use SET PERSIST and SET PERSIST_ONLY to make variable changes survive restarts, how to view and clear persisted settings, how to disable persistence, required privileges, and how to monitor persisted variables via performance_schema.

Database AdministrationSET PERSISTmysql
0 likes · 7 min read
How to Persist Global System Variables in MySQL 8
ITPUB
ITPUB
Nov 10, 2020 · Databases

Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring

This comprehensive cheat sheet gathers over eighty practical T‑SQL statements covering instance properties, configuration, system views, lock monitoring, backup progress, replication, Always On, FILESTREAM, job management, index maintenance, and security, providing DBAs with ready‑to‑run commands for everyday SQL Server administration and troubleshooting.

Database AdministrationReplicationSQL Server
0 likes · 29 min read
Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring
Qunar Tech Salon
Qunar Tech Salon
Nov 5, 2020 · Databases

Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution

This article explains why a low‑traffic PostgreSQL 11 database can accumulate massive WAL files, analyzes relevant configuration parameters and replication slots, demonstrates diagnostic SQL commands, and provides step‑by‑step actions—including adjusting archive_timeout, handling replication slots, and forcing a checkpoint—to reclaim disk space.

Database AdministrationWALperformance tuning
0 likes · 8 min read
Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution
MaGe Linux Operations
MaGe Linux Operations
Oct 28, 2020 · Databases

Step‑by‑Step: Install PostgreSQL 12 and pgAdmin4 on RHEL 8

This guide walks you through installing PostgreSQL 12 and the web‑based pgAdmin4 management tool on RHEL 8, covering module selection, database initialization, service configuration, and Apache‑based server‑mode setup with necessary SELinux and firewall adjustments.

Database AdministrationLinuxRHEL 8
0 likes · 6 min read
Step‑by‑Step: Install PostgreSQL 12 and pgAdmin4 on RHEL 8
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 21, 2020 · Databases

How to Reset a Forgotten MySQL Root Password

This guide explains how to recover a lost MySQL root password by editing the MySQL configuration to skip grant tables, restarting the service, and then setting a new password via SQL commands, with platform-specific steps for Windows, macOS, and Linux.

ConfigurationDatabase AdministrationLinux
0 likes · 4 min read
How to Reset a Forgotten MySQL Root Password
Java Captain
Java Captain
Aug 15, 2020 · Databases

Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

This article provides a detailed collection of SQL Server commands and techniques covering database creation, table and index management, common DML statements, advanced set operators, various join types, grouping, pagination, maintenance tasks, replication setup, linked‑server usage, and a synchronization stored procedure.

Database AdministrationLinked ServerSQL Server
0 likes · 22 min read
Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication