/usr/local/mysql/bin/mysqlbinlog-vv/var/lib/bin/mysql-bin.000008 --base64-output=decode-rows - -start-pos=307Question: What exactly does this mean?[Email protected]
The importance of data backupIn a production environment, the security of data is critical, and any loss of data can have serious consequences. The importance can be reflected in the following points:1. Improved system high availability and disaster
In a production environment, the security of data is critical, and any loss of data can have serious consequences. So the database needs to be backed up. Here is an example of a new mysql5.7.First, database backup classification:
From a
The importance of database backup
Improve the system's high availability and disaster recoverability, when the database system crashes, no data backup can not find data.
Restoring a database using a database backup is the best solution
IntroductionIncremental backup means that after a full or last incremental backup, each subsequent backup needs only to back up the files that were added or modified compared to the previous one. This means that the object of the first incremental
MySQL suppresses the binlog part in the BINLOG part, and mysql suppresses the binlog part.
MySQL uses binlog to record the entire data change process. Therefore, we only need MySQL binlog to completely restore the database. There are three different
Incremental backup concept:Backup files or content that have been added or changed since the last backupFeatures of incremental backups:Advantages: No duplication of data, backup volume is small, time is short.Disadvantage: All incremental backups
Binlog is a binary log file of MySQL record operation, there are three formats to choose from, but the old SBR is not suitable for most business needs now, so most of them are recommended to use MBR and RBR, that is, mixed or row, and the reason for
Why use incremental backups?There are two ways to fully backup, one is to use tar to package the data file, and the other is to use mysqldump for a full backup. The problem with a full backup is easy to see, every time the data content is backed up,
For details about the event types in MySQL binlog, mysqlbinlog
All operations recorded by MySQL binlog actually have corresponding event types. For example, DML operations in STATEMENT format correspond to QUERY_EVENT types, while DML operations in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.