What is the basic process of Mysqldump backup

This article introduces the relevant knowledge of "what is the basic process of Mysqldump backup". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The basic process of mysqldump backup is as follows:

1. Call FTWRL (flush tables with read lock) to disable reading and writing globally

two。 Turn on snapshot reading and take the snapshot at this time (only for innodb tables)

3. Back up non-innodb table data (* .frm, * .myi,*.myd, etc.)

4. Release the FTWRL lock after the non-innodb table is backed up

5. Back up the innodb data one by one

6. Backup complete.

The detailed process of the backup can be illustrated by the following figure:

This is the end of the content of "what is the basic process of Mysqldump backup". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!