Shulou(Shulou.com)06/01 Report--

How to install mydumper and what is the principle, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

I. installation

Install the dependency package:

Yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel cmake

Download the binary package:

Wget https://launchpadlibrarian.net/225370879/mydumper-0.9.1.tar.gz

Unpack the installation:

Tar zxvf mydumper-0.9.1.tar.gz

Cd mydumper-0.9.1/

Cmake.

Make

Make install

After the installation, two binaries are generated: mydumper and myloader are located in the / usr/local/bin directory

Check to see if it is normal:

Mydumper-help

Introduction of the principle

Mydumper introduction

MySQL's own mysqldump tool supports single-threaded work, exporting multiple tables one by one without a parallel machine, which makes it impossible to back up data quickly.

As a utility, mydumper can support multithreading, which can read data from tables and write to different files in parallel, which makes it faster than traditional mysqldump in processing speed. One of its features is that the list needs to be locked during processing, so if we need to perform backup work during working hours, it will cause DML blocking. But generally speaking, today's MySQL has a master and slave, and most of the backups are carried out on the slave, so the problem of locking can be ignored. In this way, mydumper can better complete the backup task.

Mydumper characteristics

① multithreaded backup

Since ② is a multithreaded logical backup, multiple backup files will be generated after backup.

Applying FTWRL (FLUSH TABLES WITH READ LOCK) to the MyISAM table during ③ backup will block the DML statement

④ ensures the consistency of backup data

⑤ supports file compression

⑥ supports exporting binlog

⑦ supports multithreaded recovery

⑧ supports working in daemon mode, scheduled snapshots and continuous binary logs

⑨ supports slicing backup files

After reading the above, have you mastered how to install mydumper and how it works? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.