In order to prevent data loss, data backup is essential, I work in the past is done with the backup job agency way, today is to know about the way the database backup, one for physical backup, logical backup, APP based on MYSQL stored data, there will be the primary server and from the server, when the master server downtime, based on the data backup, we can put the failover to the server, as the database data files, log files backup, and then use these files to restore database is physical backup; As with export tool to database tables, the user, export, storage process reuse the import tool to import, this backup way is logical backup,
Like this is only the primary server goes down, began to use from the server, the server utilization is very not enough, so we'll think of some way to do it, speaking, reading and writing, this time need a middleware, at the time of writing, write data to the server, at the same time synchronization to from the server, and then read the data, we can directly read data from the server, so that we can achieve the separation, speaking, reading and writing