MySQL Open Binlog

MySQL open Binlog, as for why to open Binlog, can Google.

# # Set server_id, generally set to ipserver_id=117# # Copy filter: The name of the database to be backed up, multiple libraries separated by commas, output binlog## binlog- Do-db=mydb## Copy filter: No backup database, no output (MySQL library is not synchronized) # # Binlog-ignore-db=mysql# If the synchronization function or the stored procedure needs to be configured, the master will produce an exception that cannot be synchronized log_bin_trust_function_creators=true## Open Binary log function, can be arbitrarily taken, it is better to have meaning log-bin=117-mysql-bin## the memory allocated for each session, which is used to store the cache of the binary log during the transaction binlog_cache_size=1m## master-slave copy format (mixed,statement,row, default format is statement) Binlog_format=mixed## binary Log automatic deletion/the number of days to expire. The default value is 0, which means that it is not automatically deleted. Expire_logs_days=Ten# # Skip all errors encountered in master-slave replication or specify types of errors to avoid slave-side replication interrupts. # # Example: 1062 error refers to some primary key duplication, 1032 error is due to master and slave database data inconsistency slave_skip_errors=1062

MySQL Open Binlog