Advantages and disadvantages of SBR and RBR (statement-based and row-based Replication) in MySQL Binlog_format

Advantages of statement-based Replication

1 Technology Mature 2 for a large number of operations such as update deletion, only a small number of changes will be written to speed up the log acquisition or backup speed. 3rd logs contain all the changed statements that can be used to validate the database

Disadvantages of statement-based replication

1.1statements in the UDF custom function1.2There are no restrictions in delete and upate using order by1.3The following function cannot be copied in the statement format load_file () UUID () User () Found_rows () and so on, except for the Now () function1.4Compared to the row format, insert ...Selectmore row-level locks are required1.5The UPDATE statement needs to lock a large number of rows for table scanning compared to the row format1.6for InnoDB: Using auto_increment will block other non-conflicting INSERT statements1.7In a complex statement, the statement is evaluated and executed on the slave server before the row is updated or inserted. If the row is replicated, the server only needs to change the affected rows without having to process all the tables1.8In the execution of complex statements from the library, due to evaluation errors, over time, the impact on the row will slowly increase1.9The storage function uses the same now () as the calling function, not the actual condition of the stored procedure.2.1deterministic UDFs must be applied on a dependent. 2.2The primary and the table definitions must be consistent

Advantages and disadvantages of SBR and RBR (statement-based and row-based Replication) in MySQL Binlog_format