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

Source: Internet
Author: User

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

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.