MySQL备份：mylvmbackup介绍与使用-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

MySQL备份：mylvmbackup介绍与使用

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:33 PM

需要的依赖库Config::IniFilesMIME::LiteDBD::mysqlDBISys::Syslog建议使用CPAN安装，多快好省首先获得全局读锁，接着将缓存中数

需要的依赖库
Config::IniFiles
MIME::Lite
DBD::mysql
DBI
Sys::Syslog
建议使用CPAN安装，多快好省

首先获得全局读锁，接着将缓存中数据写到磁盘，然后执行LVM快照，最后解锁、以下是我采集的一个主要过程

20131105 13:51:17 Info: Connecting to database...

20131105 13:51:17 Info: Flushing tables with read lock...

20131105 13:51:17 Info: Running: lvcreate -s --size=1G --name=mysql_snapshot /dev/vg/mysql

20131105 13:51:18 Info: Unlocking tables...

20131105 13:51:18 Info: Disconnecting from database...

20131105 13:51:18 Info: Running: mount -o rw /dev/vg/mysql_snapshot /var/tmp/mylvmbackup/mnt/backup

20131105 13:51:18 Info: Copying /tmp/mylvmbackup-backup-20131105_135117_mysql-8aDBvc.pos to /var/tmp/mylvmbackup/mnt/backup-pos/backup-20131105_135117_mysql.pos...
20131105 13:51:18 Info: Copying /etc/my.cnf to /var/tmp/mylvmbackup/mnt/backup-pos/backup-20131105_135117_mysql_my.cnf...

20131105 13:51:18 Info: Taking actual backup...
20131105 13:51:18 Info: Creating tar archive /var/tmp/mylvmbackup/backup/backup-20131105_135117_mysql.tar.gz

20131105 13:53:34 Info: Running: umount /var/tmp/mylvmbackup/mnt/backup

20131105 13:53:34 Info: LVM Usage stats:
20131105 13:53:34 Info: LV VG Attr LSize Origin Snap% Move Log Copy% Convert
20131105 13:53:34 Info: mysql_snapshot vg swi-a- 1.00G mysql 0.20

20131105 13:53:34 Info: Running: lvremove -f /dev/vg/mysql_snapshot

整个过程执行完后，只留下backup-20131105_135117_mysql.tar.gz，该tar包里面含二进制日志坐标、my.cnf及mysql所有文件

该工具也有邮件告警的功能，以下是我的配置文件邮件告警部分
# cat /etc/mylvmbackup.conf | grep mail
mail_report_on=always
mail_from=root@localhost
mail_to=645522734@qq.com
mail_subject=mylvmbackup report for localhost
注释
--mail_report_on：取值{never,always,errors},其中never为默认值，always表示总是发邮件，errors只在出错时发

mylvmbackup 的详细介绍：请点这里
mylvmbackup 的下载地址：请点这里

相关阅读：

MySQL备份：mylvmbackup介绍与使用

Linux下通过mysqldump备份MySQL数据库成sql文件

Linux中使用mysqldump对MySQL数据库进行定时备份

linux

，

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

1 months agoByDDD

R.E.P.O. Best Graphic Settings

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

1 weeks agoByDDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.