Backup:
Mysqldump: The data is exported from the database and imported, the data is exactly the same, but time-sensitive, large amount of data backup can be a nuisance.
Master-slave replication:
MySQL replication: Has the effect of backing up MySQL. The commands executed on the primary MySQL are copied to the Binlog file to be executed again from MySQL, and the data is usually consistent, depending on the size of the network impact. Some commands can cause inconsistent data,
Atlas,mycat and other middleware:
MySQL is usually configured for master-slave use, to achieve reading separation, reduce the resource overhead of primary MySQL, and improve performance. The point is that some special statements, the retrieval of the results of different, such as inserting the MySQL UUID in the data table, after the completion of the Lord, after the execution of this command, then query the MySQL UUID. The resulting UUID value is inaccurate (get from the MySQL uuid, actually want to get the master uuid, then if the value to do other changes, the data inconsistency will be more serious)
Backup and replication of MSYQL and Atlas