BestHub
Sign in
Tagged articles
124 articles
Page 1 of 2
dbaplus Community
dbaplus Community
Apr 6, 2026 · Operations

How Machine Learning Transforms Database Monitoring: From Fixed Thresholds to Intelligent Anomaly Detection

This article explains why traditional threshold‑based database inspections are insufficient, introduces machine‑learning‑driven anomaly detection as a second set of eyes, details feature extraction, algorithm choices, tuning, and alert convergence, and showcases three real‑world scenarios with MySQL and Redis metrics.

DBADatabase MonitoringOperations
0 likes · 23 min read
How Machine Learning Transforms Database Monitoring: From Fixed Thresholds to Intelligent Anomaly Detection
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 24, 2025 · Databases

Why Relying Solely on Large Language Models for Database Migration Is Risky – Insights from SQLShift

The article explains the hidden challenges of database migration, demonstrates that large language models alone cannot reliably handle dialect differences, and describes how the SQLShift tool combines domain‑specific fine‑tuning, multi‑stage verification, and human‑AI collaboration to make migration safer and more predictable.

AIDBASQLShift
0 likes · 9 min read
Why Relying Solely on Large Language Models for Database Migration Is Risky – Insights from SQLShift
IT Xianyu
IT Xianyu
May 23, 2025 · Databases

Step‑by‑Step Guide to Setting Up MySQL Master‑Slave Replication with Docker

This article provides a comprehensive, step‑by‑step tutorial on deploying a MySQL master‑slave replication architecture using Docker containers, covering prerequisite checks, container setup, configuration files, replication user creation, master‑slave linking, testing data sync, and troubleshooting common issues.

DBADockerReplication
0 likes · 8 min read
Step‑by‑Step Guide to Setting Up MySQL Master‑Slave Replication with Docker
Xiaolei Talks DB
Xiaolei Talks DB
Apr 28, 2025 · Databases

How China's DBA Landscape Is Evolving with Domestic Databases and AI

The article examines China's rapid shift toward domestic databases across finance, government, and energy sectors, highlighting how DBAs must upgrade from reactive fire‑fighting to strategic architects by mastering distributed systems, AI‑driven automation, cloud‑native tools, and open‑source community collaboration.

AIDBADistributed Systems
0 likes · 12 min read
How China's DBA Landscape Is Evolving with Domestic Databases and AI
IT Xianyu
IT Xianyu
Apr 24, 2025 · Databases

PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening

This tutorial explains why DBAs need security hardening and log analysis, shows how to configure minimal‑privilege roles and precise permissions in PostgreSQL, demonstrates how to detect and revoke redundant privileges, and provides a step‑by‑step guide to installing and using pgBadger for log analysis and automated reporting.

DBADatabase SecurityPostgreSQL
0 likes · 8 min read
PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening
dbaplus Community
dbaplus Community
Feb 14, 2025 · Databases

How AI Tools Are Transforming the Role of Database Administrators

The article argues that, despite common fears, AI and modern management tools like OEM and DB Console empower DBAs to work more efficiently, improve performance, and stay relevant, while highlighting real-world stories of tool adoption and the challenges of AI hallucinations.

AIDBAPerformance Optimization
0 likes · 7 min read
How AI Tools Are Transforming the Role of Database Administrators
ITPUB
ITPUB
Jan 27, 2025 · Databases

Surviving Oracle’s Dark Ages: Lessons from Classic DBA Nightmares

The article recounts decades‑long Oracle DBA experiences, describing early‑era crashes, notorious ORA‑1591 and ORA‑600 errors, troubleshooting tactics, and how those hardships forged highly skilled DBAs while highlighting the evolution toward more mature database systems.

DBADatabase ErrorsOracle
0 likes · 9 min read
Surviving Oracle’s Dark Ages: Lessons from Classic DBA Nightmares
ITPUB
ITPUB
Nov 10, 2024 · Databases

Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing

The article explains how Oracle DBAs transitioning to PostgreSQL often misinterpret work_mem and cursor sharing, showing how improper settings can drastically change execution plans, increase query time, and cause performance issues, while also highlighting differences in memory management and plan caching between the two systems.

DBAOraclePostgreSQL
0 likes · 8 min read
Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing
ITPUB
ITPUB
Aug 13, 2024 · Databases

Who Should Own Database Change Failures? A Deep Dive into Roles, Risks, and Responsibility

An in‑depth analysis of database change workflows reveals three key players—business developers, DBAs, and change tools—outlines the full lifecycle of a change, illustrates a MySQL VARCHAR length mishap, and argues why the business team should bear primary responsibility while DBAs assume secondary accountability.

DBAdatabase change managementmysql
0 likes · 9 min read
Who Should Own Database Change Failures? A Deep Dive into Roles, Risks, and Responsibility
ITPUB
ITPUB
Jun 17, 2024 · Databases

Boost MySQL DBA Productivity with Essential Open‑Source Tools

This guide introduces a collection of practical MySQL DBA utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit commands such as pt‑duplicate-key-checker, pt‑kill, pt‑mysql-summary, pt‑query-digest, pt‑table-checksum, and pt‑table-sync—showing how to install them, run key commands, and interpret their outputs to streamline database administration tasks.

DBASQL Optimizationmysql
0 likes · 9 min read
Boost MySQL DBA Productivity with Essential Open‑Source Tools
ITPUB
ITPUB
Jun 2, 2024 · Databases

How to Diagnose and Fix Unusable Oracle Indexes in Production

This article walks through a real‑world Oracle index failure, explains why indexes become UNUSABLE, shows how to clean residual metadata, rebuild the index safely, outlines common causes for both regular and partitioned tables, and provides SQL scripts for monitoring invalid indexes.

DBAOracleSQL
0 likes · 7 min read
How to Diagnose and Fix Unusable Oracle Indexes in Production
ITPUB
ITPUB
May 10, 2024 · Databases

Choosing Low‑Risk Strategies for Critical DBA Outages

When a major operations incident strikes, the safest approach is to prioritize simple, low‑risk actions and accept limited responsibility, as illustrated by real DBA lessons from Oracle RAC failures and a data‑center power‑loss disaster.

DBAOperationsOracle RAC
0 likes · 7 min read
Choosing Low‑Risk Strategies for Critical DBA Outages
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book

OceanBase, a distributed open‑source database, offers a free e‑book and an eight‑session tutorial series covering installation, migration, operation, performance tuning, diagnostics, and ecosystem tools such as OCP, OMS, ODC, and obdiag, aimed at students, developers, and DBAs seeking practical skills and certification.

DBAOceanBaseTutorial
0 likes · 10 min read
OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book
ITPUB
ITPUB
Apr 7, 2024 · Databases

How to Choose the Right Database Management Tool: Expert DBA Insights

In this interview, a senior database operations manager shares why building a lightweight, purpose‑built tool is essential, outlines a systematic selection process based on clear operational needs, and highlights key criteria such as usability, security, and controllability while recommending practical solutions.

DBADatabase ToolsSecurity
0 likes · 8 min read
How to Choose the Right Database Management Tool: Expert DBA Insights
ITPUB
ITPUB
Feb 27, 2024 · Databases

How to Choose the Right Database Tool: Expert Insights and Practical Criteria

This article, based on an interview with Huolala's database leader Cai Peng, outlines essential criteria for selecting database tools from both developer and DBA perspectives, compares small‑scale versus comprehensive solutions, and emphasizes the need for integrated, platform‑level tooling in modern cloud‑driven environments.

DBAR&Dplatform
0 likes · 10 min read
How to Choose the Right Database Tool: Expert Insights and Practical Criteria
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.

DBADatabase AdministrationIoT
0 likes · 7 min read
The Evolving Role of Database Administrators: Challenges, Changes, and Future Trends (2023)
Selected Java Interview Questions
Selected Java Interview Questions
Mar 26, 2023 · Databases

9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them

This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.

DBADatabase DeploymentDevOps
0 likes · 11 min read
9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them
Efficient Ops
Efficient Ops
Mar 8, 2023 · Databases

Scaling Multi-Cloud Database Operations: Huolala’s Stability and Automation Playbook

The article details Huolala’s comprehensive approach to managing diverse databases across multiple clouds, covering systematic stability engineering, automated SQL governance, Redis and Kafka reliability strategies, cost‑optimization tactics, and the evolving roles of modern DBAs in a complex, high‑scale environment.

DBADatabase operationsPerformance Optimization
0 likes · 16 min read
Scaling Multi-Cloud Database Operations: Huolala’s Stability and Automation Playbook
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
Aug 25, 2022 · Databases

Understanding Data Consistency in MySQL Semi‑Synchronous Replication and HA Failover

This article explains the principles of MySQL semi‑synchronous replication, analyzes how data consistency is maintained during high‑availability failover, presents detailed step‑by‑step transaction flow, discusses scenarios causing GTID divergence, and offers testing methods and remediation techniques for DBA practitioners.

DBAGTIDSemi-sync replication
0 likes · 14 min read
Understanding Data Consistency in MySQL Semi‑Synchronous Replication and HA Failover
dbaplus Community
dbaplus Community
Jun 21, 2022 · Databases

Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know

This article outlines practical guidance for DBAs transitioning to Chinese domestic databases, highlighting why standard Oracle benchmark tweaks often fail, the limited relevance of buffer‑hit ratios, the importance of SQL execution efficiency, and specific strategies for handling high‑concurrency workloads.

DBADatabase OptimizationDomestic Databases
0 likes · 7 min read
Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know
dbaplus Community
dbaplus Community
Apr 17, 2022 · Databases

Why Killing Slow Queries Often Fails and a Safer MySQL Timeout Solution

The article examines how slow‑query‑induced avalanches arise in MySQL, explains why naïvely killing slow queries is fraught with accuracy, automation and responsibility issues, and proposes a signature‑based timeout mechanism that lets applications safely abort problematic queries.

DBADatabase Performancemysql
0 likes · 17 min read
Why Killing Slow Queries Often Fails and a Safer MySQL Timeout Solution
ITPUB
ITPUB
Dec 20, 2021 · Databases

From Database Developer to New DBA: Boosting MySQL Efficiency and Automation

The article shares a senior DBA's journey from early database engine development to modern MySQL operations, outlining practical methods for improving efficiency, automating monitoring, building data‑driven processes, and redefining the DBA role for proactive, high‑impact service delivery.

AutomationDBADatabase operations
0 likes · 33 min read
From Database Developer to New DBA: Boosting MySQL Efficiency and Automation
dbaplus Community
dbaplus Community
Nov 22, 2021 · Databases

Transforming MySQL Monitoring: From Nagios to Kafka‑Powered Alerts

Qunar’s DBA team overhauled their MySQL monitoring and alert system—originally built on Nagios and NRPE—by integrating a Kafka‑based pipeline, a custom alarm service, and MySQL‑stored alert templates, achieving flexible thresholds, granular silencing, high‑availability processing, and early‑stage intelligent management of alerts, slow queries, and disk space.

AlertingAutomationDBA
0 likes · 14 min read
Transforming MySQL Monitoring: From Nagios to Kafka‑Powered Alerts
Qunar Tech Salon
Qunar Tech Salon
Nov 2, 2021 · Databases

Improving Qunar.com Database Monitoring and Alert System with a Kafka‑Based Alarm Program

The article describes how Qunar.com upgraded its Nagios/NRPE‑based database monitoring by inserting a Kafka‑driven alarm component, centralizing alert configuration in MySQL, adding flexible shielding and multi‑channel notifications, and exploring intelligent features such as slow‑query and disk‑space management.

DBADatabase Monitoringalert system
0 likes · 13 min read
Improving Qunar.com Database Monitoring and Alert System with a Kafka‑Based Alarm Program
dbaplus Community
dbaplus Community
Oct 17, 2021 · Databases

Why a 4‑TB MySQL Instance Hangs on Startup and How to Fix It

A detailed forensic analysis reveals that a MySQL 5.7 instance stalls during startup due to a mismatch between InnoDB flush‑sync settings and truncate‑related redo logs, and the article explains how to diagnose the issue with TOP, stack traces, and source‑code inspection, then offers three practical work‑arounds.

DBADebuggingInnoDB
0 likes · 15 min read
Why a 4‑TB MySQL Instance Hangs on Startup and How to Fix It
Qunar Tech Salon
Qunar Tech Salon
Mar 31, 2021 · Databases

Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration

This article explains how DBAs can use PostgreSQL's extensive logging parameters and log_line_prefix settings to locate and reconstruct every SQL statement within a transaction, illustrated with practical cases, command‑line examples, and step‑by‑step log‑analysis techniques for lock troubleshooting.

DBADatabase LoggingLock Troubleshooting
0 likes · 24 min read
Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration
ITPUB
ITPUB
Mar 30, 2021 · Databases

10 Essential MySQL Development Rules Every DBA and Developer Should Follow

This article outlines ten practical MySQL development guidelines—from always using InnoDB and simple data types to avoiding SELECT *, ENUM, and low‑cardinality indexes, while emphasizing proper naming, charset choices, NOT NULL constraints, and continuous SQL monitoring with Percona Toolkit.

DBADatabase designSQL
0 likes · 5 min read
10 Essential MySQL Development Rules Every DBA and Developer Should Follow
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 18, 2021 · Databases

How to Build a Professional DBA Operations Team: Infrastructure, Standards, Training, Knowledge Base, and Culture

The article explains how to construct an effective DBA operations team by focusing on reusable infrastructure, clear team standards, a structured training system, a comprehensive knowledge base, and a positive team atmosphere, providing practical tools and methods for each aspect.

DBADatabase operationsInfrastructure
0 likes · 4 min read
How to Build a Professional DBA Operations Team: Infrastructure, Standards, Training, Knowledge Base, and Culture
ITPUB
ITPUB
Oct 26, 2020 · Operations

Essential Unix Commands Every PostgreSQL DBA Should Know

This guide compiles the most useful Unix/Linux commands for PostgreSQL administrators, covering background execution, mail queue handling, email with attachments, file searching, cleanup, compression, diffing, remote synchronization, timestamp‑based file moves, and system reboot techniques.

DBALinuxPostgreSQL
0 likes · 11 min read
Essential Unix Commands Every PostgreSQL DBA Should Know
JD Cloud Developers
JD Cloud Developers
Sep 17, 2020 · Databases

Why Traditional DBA Roles Are Threatened by Cloud Computing – What You Need to Know

The article examines the evolving role of Database Administrators, tracing their origins from ops engineers to high‑paid specialists, highlighting how cloud‑based Database‑as‑a‑Service and PaaS offerings are automating traditional DBA tasks, causing job declines and prompting DBAs to adapt their skills toward cloud, performance, security, and business‑oriented data management.

DBAcareerdatabase
0 likes · 12 min read
Why Traditional DBA Roles Are Threatened by Cloud Computing – What You Need to Know
Tencent Cloud Developer
Tencent Cloud Developer
Aug 26, 2020 · Databases

How to Become an Outstanding Data Craftsman: Insights from Database Experts

Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.

Career DevelopmentDBADatabase Architecture
0 likes · 34 min read
How to Become an Outstanding Data Craftsman: Insights from Database Experts
Tencent Cloud Developer
Tencent Cloud Developer
Apr 5, 2020 · Databases

Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong

Senior DBA Yang Jianrong shares how standardized processes, robust security, and modern optimization—such as partitioning, middleware, and NoSQL—combined with high‑availability designs and self‑service tools like automated slow‑log analysis can streamline large‑scale MySQL operations, migrations, and continuous DBA learning.

BackupDBAdatabase
0 likes · 24 min read
Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong
dbaplus Community
dbaplus Community
Mar 30, 2020 · Databases

Intelligent Database Ops: Expert Answers on Monitoring, Prediction & Automation

In a detailed Q&A session, Minsheng Bank’s database specialist shares 16 practical insights on intelligent database operations, covering data storage choices, monitoring tools like Zabbix and Prometheus, anomaly detection, prediction modeling, SQL metric collection, log analysis, and the evolving role of DBAs in the era of AI‑driven ops.

DBAIntelligent OperationsPredictive Modeling
0 likes · 10 min read
Intelligent Database Ops: Expert Answers on Monitoring, Prediction & Automation
dbaplus Community
dbaplus Community
Nov 21, 2019 · Databases

How to Build a Real‑Time MySQL Statistics Platform with ClickHouse

This article explains how a growing company designed, optimized, and deployed a comprehensive MySQL monitoring and analysis pipeline—moving from Flume‑HDFS‑Hive to ClickTail‑ClickHouse, enriching SQL parsing, and applying practical methods for state statistics, trend analysis, permission management, and data‑skew detection.

DBADatabase MonitoringSQL Analytics
0 likes · 16 min read
How to Build a Real‑Time MySQL Statistics Platform with ClickHouse
Efficient Ops
Efficient Ops
Sep 18, 2019 · Databases

Why the DBA Role Is Becoming a Narrowed, High‑Risk Career Path

The article analyzes how the DBA job market is shrinking as traditional enterprises shift away from legacy systems, cloud adoption reshapes responsibilities, and DBAs face limited advancement unless they transition to architecture or data‑analytics roles, highlighting the growing risk and low reward of staying in pure DBA work.

Big DataDBADatabase Administration
0 likes · 7 min read
Why the DBA Role Is Becoming a Narrowed, High‑Risk Career Path
ITPUB
ITPUB
Feb 26, 2019 · Databases

Will Oracle Be Replaced by MySQL? DBA Demand and Database Trends Explained

The article examines whether Oracle will be completely supplanted by MySQL, comparing industry adoption, DBA role differences, performance versus scalability, cost considerations, and cultural factors that influence database choices in traditional and internet sectors.

DBAOraclecost analysis
0 likes · 6 min read
Will Oracle Be Replaced by MySQL? DBA Demand and Database Trends Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 30, 2018 · Databases

Analyzing InnoDB Semaphore Crashes and a DBA Diagnostic Tool

The article explains why InnoDB semaphore waits exceeding 600 seconds trigger server crashes, details the lock structures and functions involved, shows how buffer pool pressure and metadata statistics cause contention, and introduces a small DBA utility that parses MySQL error logs to reveal the relationships between threads, locks, and transactions.

DBAInnoDBdiagnostics
0 likes · 8 min read
Analyzing InnoDB Semaphore Crashes and a DBA Diagnostic Tool
dbaplus Community
dbaplus Community
Dec 16, 2018 · Databases

How to Design an Effective SQL Audit System for Better DB Performance

This article explains why SQL auditing is essential, outlines its core principles, dimensions, scoring model, and workflow, and provides practical guidance on building a self‑service, visualized, and automated audit solution that improves database reliability and developer productivity.

AutomationDBADatabase Auditing
0 likes · 14 min read
How to Design an Effective SQL Audit System for Better DB Performance
Meituan Technology Team
Meituan Technology Team
Dec 13, 2018 · Databases

From Automation to Intelligent Database Operations: Meituan DBA Team’s Journey and Practices

Meituan’s DBA team progressed from simple scripting through tooling, productization, private‑cloud self‑service and full automation to an emerging intelligent‑operation model that leverages extensive data collection, risk‑driven pre‑warning, AI‑assisted analysis, and self‑healing mechanisms to meet rapid growth, stability and scalability demands.

DBADatabase operationsMeituan
0 likes · 14 min read
From Automation to Intelligent Database Operations: Meituan DBA Team’s Journey and Practices
ITPUB
ITPUB
Dec 3, 2018 · Databases

How Ele.me Deployed a Dual‑Active Database System in Just Three Months

This talk details Ele.me’s three‑month rollout of a dual‑active (multi‑active) database system, covering design principles, architecture, migration steps, challenges such as data consistency and DDL handling, the tools built (DRC, D‑Bus, DCP, EMHA), and the performance and reliability benefits achieved.

DBAEle.medata replication
0 likes · 14 min read
How Ele.me Deployed a Dual‑Active Database System in Just Three Months
dbaplus Community
dbaplus Community
Sep 27, 2018 · Databases

How We Built an Automated DBA Platform: Architecture, Design, and Lessons

This article outlines the journey of a financial services company from manual DBA tasks through tool‑assisted operations to a fully automated platform, detailing the platform’s technical stack, functional modules, metadata design principles, evolving SQL audit workflow, and future directions for intelligent database operations.

AutomationDBASQL Auditing
0 likes · 17 min read
How We Built an Automated DBA Platform: Architecture, Design, and Lessons
dbaplus Community
dbaplus Community
Sep 10, 2018 · Operations

Scaling MySQL Management with a Fully Automated DBA Platform

This article details how a DBA team built a standardized, automated MySQL/Redis management platform—covering OS and DB standardization, deployment scripts, a three‑layer web‑task‑module architecture, RESTful APIs, and modular design—to enable a handful of DBAs to manage thousands of instances efficiently.

DBAPythondatabase automation
0 likes · 13 min read
Scaling MySQL Management with a Fully Automated DBA Platform
Meituan Technology Team
Meituan Technology Team
May 17, 2018 · Databases

Understanding MySQL SQL Parsing and Optimization Techniques

The article explains how to extend MySQL’s built‑in lexer and Bison‑based parser to expose table names, query features, and optimization advice via a simple language‑agnostic service, illustrating core data structures, useless‑condition elimination, feature generation for slow‑query analysis, and practical learning tips.

DBASQL parsingcompiler
0 likes · 15 min read
Understanding MySQL SQL Parsing and Optimization Techniques
ITPUB
ITPUB
Apr 19, 2018 · Databases

How Didi Scales MySQL: From Manual Ops to Full Automation

This article outlines Didi's MySQL database architecture, the challenges of managing thousands of instances, and the step‑by‑step automation framework—including dbproxy, high‑availability, backup, monitoring, and deployment modules—that reduces manual DBA work by over 70%.

DBADidiOperations
0 likes · 14 min read
How Didi Scales MySQL: From Manual Ops to Full Automation
dbaplus Community
dbaplus Community
Jan 31, 2018 · Databases

How to Systematically Diagnose and Fix MySQL Master‑Slave Replication Lag

This article walks through a real‑world case of MySQL 5.7 replication delay after switching to TokuDB, presenting a step‑by‑step methodology that examines network, hardware, large transactions, locks, configuration parameters, and multi‑threaded replication to identify and resolve the root cause.

DBALagParallelReplication
0 likes · 12 min read
How to Systematically Diagnose and Fix MySQL Master‑Slave Replication Lag
ITPUB
ITPUB
Dec 15, 2017 · Databases

Top Open-Source MySQL Tools Every DBA Should Know

This guide reviews five essential open‑source MySQL utilities—Mycli, Gh‑ost, phpMyAdmin, Sqlcheck, and Orchestrator—detailing their key features, licensing, contributor statistics, and practical usage scenarios to help database administrators streamline management, migrations, monitoring, and high‑availability tasks.

DBAGitHubmysql
0 likes · 10 min read
Top Open-Source MySQL Tools Every DBA Should Know
ITPUB
ITPUB
Sep 23, 2017 · Databases

Essential DBA Checklist: Avoid Common MySQL Mistakes and Boost Reliability

This guide shares a seasoned DBA's practical checklist covering environment awareness, hardware considerations, runtime monitoring, data security, routine operations, fault‑prevention plans, architecture insights, and the right mindset to help database professionals reduce errors and improve system stability.

DBADatabase operationsdata security
0 likes · 19 min read
Essential DBA Checklist: Avoid Common MySQL Mistakes and Boost Reliability
Efficient Ops
Efficient Ops
Aug 10, 2017 · Operations

Avoid Costly DBA Mistakes: Essential MySQL Operations and Best Practices

This comprehensive guide shares a senior DBA's hard‑learned lessons on MySQL environment setup, data security, routine operations, architecture insights, online execution tips, and the right mindset, helping database professionals prevent common pitfalls and improve reliability.

DBADatabase operationsmysql
0 likes · 19 min read
Avoid Costly DBA Mistakes: Essential MySQL Operations and Best Practices
dbaplus Community
dbaplus Community
Jul 20, 2017 · Databases

Master MySQL Backup, Security, and SQL Best Practices: A Complete Guide

This article provides a comprehensive, step‑by‑step guide on MySQL backup strategies, security hardening, SQL coding standards, and system planning, offering practical recommendations, verification methods, and actionable checklists to help DBAs build resilient and well‑managed database environments.

BackupDBADatabase Planning
0 likes · 26 min read
Master MySQL Backup, Security, and SQL Best Practices: A Complete Guide
dbaplus Community
dbaplus Community
Jul 17, 2017 · Databases

DBA Lessons: From MySQL Restart Pitfalls to Smart Data Migration Strategies

The article shares a DBA's real‑world experiences—from a risky MySQL restart that exposed hidden issues, through practical learning advice and MySQL technical nuances, to a detailed Oracle migration case—offering actionable insights for database professionals seeking robust data management and performance optimization.

DBAData ManagementOracle
0 likes · 15 min read
DBA Lessons: From MySQL Restart Pitfalls to Smart Data Migration Strategies
Qunar Tech Salon
Qunar Tech Salon
Mar 9, 2017 · Databases

MySQL DBA Interview Guidance and Insights

This article offers comprehensive advice on MySQL DBA interview preparation, covering the book’s positioning, essential technical topics such as replication and InnoDB internals, desired personal qualities, interview strategies, and practical tips for both interviewers and candidates.

DBAInnoDBReplication
0 likes · 8 min read
MySQL DBA Interview Guidance and Insights
Meituan Technology Team
Meituan Technology Team
Mar 9, 2017 · Databases

SQLAdvisor: An Open-Source SQL Optimization Tool from Meituan-Dianping

SQLAdvisor, an open-source MySQL optimization utility from Meituan-Dianping, analyzes a given SQL statement—parsing its lexical structure, WHERE clauses, field selectivity, aggregations and multi-table joins—to automatically recommend missing indexes, supporting INSERT/DELETE/UPDATE/SELECT operations, filtering existing indexes, and inviting community contributions on GitHub.

DBASQLindex advisor
0 likes · 8 min read
SQLAdvisor: An Open-Source SQL Optimization Tool from Meituan-Dianping
dbaplus Community
dbaplus Community
Mar 7, 2017 · Databases

Essential MySQL DBA Best Practices: 20+ Rules for Reliable Database Management

This guide presents a comprehensive set of MySQL DBA standards covering change approvals, backup procedures, schema modifications, high‑availability architecture, security policies, indexing strategies, table and column design, and SQL writing techniques to ensure stable, performant, and secure database operations.

DBADatabase designmysql
0 likes · 14 min read
Essential MySQL DBA Best Practices: 20+ Rules for Reliable Database Management
ITPUB
ITPUB
Feb 3, 2017 · Databases

Top Oracle Migration Pitfalls Every DBA Must Avoid

This article outlines common Oracle migration pitfalls—including architectural constraints, resource impacts, application coordination issues, and diverse database problems—drawn from real‑world projects, and offers practical guidance to help DBAs anticipate and mitigate these challenges during system cut‑overs, upgrades, and consolidations.

DBADataGuardDatapump
0 likes · 6 min read
Top Oracle Migration Pitfalls Every DBA Must Avoid
Efficient Ops
Efficient Ops
Jan 24, 2017 · Databases

Essential DBA Holiday Checklist: Keep Your Databases Safe During Chinese New Year

This guide outlines the critical tasks DBA teams should perform before, during, and after the Chinese New Year holiday, including daily security practices, pre‑holiday inspections, on‑call rotations, post‑holiday reviews, and detailed checklist scripts to ensure database reliability and prevent incidents.

DBAHolidayOperations
0 likes · 13 min read
Essential DBA Holiday Checklist: Keep Your Databases Safe During Chinese New Year
dbaplus Community
dbaplus Community
Dec 29, 2016 · Databases

Unlocking MySQL sys Schema: A DBA’s Guide to Views, Performance, and Oracle‑like Insights

This article explains the origins, structure, and practical uses of MySQL's sys schema—including its view hierarchy, comparisons with Oracle data dictionary, performance‑monitoring capabilities, and step‑by‑step examples for troubleshooting locks, analyzing schema statistics, and backing up or rebuilding the sys database.

DBAOracleViews
0 likes · 13 min read
Unlocking MySQL sys Schema: A DBA’s Guide to Views, Performance, and Oracle‑like Insights
dbaplus Community
dbaplus Community
Dec 29, 2016 · Databases

How a Veteran DBA Built the DPM Database Performance Analysis Platform

This article recaps a DBAplus community session where a seasoned DBA shares common operational scenarios, diagnostic techniques, lock‑handling strategies, and step‑by‑step SQL optimization methods, while unveiling the DPM platform that automates inspection, data collection, and performance analysis for Oracle databases.

DBADPMDatabase Performance
0 likes · 22 min read
How a Veteran DBA Built the DPM Database Performance Analysis Platform
dbaplus Community
dbaplus Community
Nov 27, 2016 · Databases

How to Trace Recursive SQL Calls in Oracle Using 10046 and Orasrp

This article demonstrates step‑by‑step how Oracle DBAs can identify the origin of recursive SQL statements by leveraging the 10046 trace at both SQL‑ID and session levels, analyzing the trace with the Orasrp tool, and ultimately pinpointing the PL/SQL function that generated the query.

10046DBAOracle
0 likes · 8 min read
How to Trace Recursive SQL Calls in Oracle Using 10046 and Orasrp
ITPUB
ITPUB
Nov 4, 2016 · Databases

Mastering Oracle Statistics Collection: When, How, and Optimization Tips

This guide explains when and why Oracle statistics are needed, how to control automatic and manual collection, prevent out‑of‑range errors, boost efficiency with parallel and incremental methods, and handle special cases like volatile or temporary tables for optimal query performance.

DBADatabase OptimizationOracle
0 likes · 16 min read
Mastering Oracle Statistics Collection: When, How, and Optimization Tips
ITPUB
ITPUB
Oct 27, 2016 · Databases

Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions

This guide explains the most commonly used Oracle permission‑view tables, shows how to list role assignments, object privileges, system privileges, session privileges, and role memberships, and demonstrates the impact of the WITH ADMIN OPTION through practical SQL examples.

DBAOracleSQL
0 likes · 7 min read
Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions
ITPUB
ITPUB
Oct 21, 2016 · Databases

How I Reclaimed 200 GB by Cleaning SQL Server Backups and Syncing Data

A developer discovers a nearly full 1 TB server disk caused by large SQL Server backup files, learns the backup strategy, removes old backups while keeping monthly snapshots, manually syncs production data to a test server, and reflects on backup file formats and storage optimization.

DBADatabase BackupSQL Server
0 likes · 7 min read
How I Reclaimed 200 GB by Cleaning SQL Server Backups and Syncing Data
ITPUB
ITPUB
Aug 22, 2016 · Databases

How I Passed the Oracle OCP 051 Exam: A DBA’s Journey and Practical Tips

This article recounts a DBA’s personal journey preparing for and passing the Oracle OCP 051 certification, detailing study resources, hands‑on experiments, common Oracle errors, exam strategies, and lessons learned for future database learning.

BackupRestoreDBAExamPreparation
0 likes · 12 min read
How I Passed the Oracle OCP 051 Exam: A DBA’s Journey and Practical Tips