Tagged articles

mydumper

7 articles · Page 1 of 1

Jun 8, 2026 · Databases

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.

BinlogRecoveryXtraBackup

0 likes · 52 min read

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

Aikesheng Open Source Community

Feb 6, 2026 · Databases

Rebuilding a MySQL Replica Fast with MyDumper and MyLoader

This guide explains how to use MyDumper for logical backups and MyLoader for fast, parallel replica reconstruction, covering backup parameters, metadata configuration, replication setup, handling faulty replicas, and final restoration steps to ensure data consistency and minimal downtime.

Logical BackupMyLoadermydumper

0 likes · 11 min read

Rebuilding a MySQL Replica Fast with MyDumper and MyLoader

Ray's Galactic Tech

Dec 8, 2025 · Databases

Build a Production-Ready Automated MySQL Backup with mydumper

Learn how to install mydumper on various Linux distributions, use its multithreaded, compressed, and incremental backup features, and deploy a robust Bash script that automates full and incremental MySQL backups, handles encryption, cleanup, logging, notifications, and restoration with myloader.

AutomationEncryptionShell script

0 likes · 10 min read

Build a Production-Ready Automated MySQL Backup with mydumper

Aikesheng Open Source Community

Apr 22, 2024 · Databases

Testing MySQL Triggers with the LIKE Clause and a More Reliable Approach

This article demonstrates how the MySQL LIKE clause can give misleading results when filtering triggers, walks through a step‑by‑step lab that creates tables and triggers, shows the pitfalls of LIKE, and presents a safer WHERE‑based method for retrieving trigger definitions.

LIKE clauseSQLdatabase testing

0 likes · 7 min read

Testing MySQL Triggers with the LIKE Clause and a More Reliable Approach

Aikesheng Open Source Community

Oct 12, 2023 · Databases

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

This article compares various MySQL data import/export methods—including mysqldump, mydumper, SELECT OUTFILE, and MySQL Shell utilities—explaining their commands, configuration options, performance results, and best‑practice recommendations based on testing with a 10‑million‑row table.

ExportMySQL ShellSELECT OUTFILE

0 likes · 16 min read

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

ITPUB

Jun 15, 2017 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies

This guide explains MySQL backup fundamentals, comparing cold backups, LVM snapshot backups, logical tools like mysqldump and mydumper, and physical solutions such as Percona Xtrabackup, detailing each method’s workflow, advantages, limitations, and how to achieve consistent recovery points and times.

LVMXtraBackupbackup

0 likes · 10 min read

Mastering MySQL Backups: From Cold Copies to Xtrabackup Strategies

ITPUB

May 9, 2016 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond

This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.

DatabasesLVMXtraBackup

0 likes · 11 min read

Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond