MySQL migration's huge data volume rapid migration solution

MySQL migration huge amount of data fast migration solution-incremental backup and recovery

--chenjianwen

First, preface:

When MySQL library size reaches dozens of g or hundreds of G, migrating up is a very troublesome thing, business interruption, export import time consuming a lot, so, need to consider how to save time.

Second, the programme:

1. Make maintenance time, interrupt business, log in to MySQL, refresh log

2. Full data, after backup to get binlog log file mysql-bin.000001

3. Migrate the Binlog log file before leaving, leaving only mysql-bin.000001

4. Recovery of Business

5. Import full-size SQL Big data files into a new library "time consuming"

6. Establish the official migration time, stop the business

7. Obtain the data for the period increment through the current mysql-bin.000001 Mysql-000001.sql

8. Import Mysql-000001.sql directly into the new library

9. Modify the business connection MySQL configuration, start the service

Third, the advantages

1. Significantly reduces the time required to import new libraries, which translates into less time for business disruption

Iv. Detailed Implementation steps

1.

MySQL migration's huge data volume rapid migration solution