Overview

This document describes how to install and enable the binlog optimization feature on a Kunpeng server.

MySQL's binary log (binlog) records all database data changes (such as INSERT, UPDATE, and DELETE), and is primarily used for data replication and restoration. After the binlog function is enabled, MySQL uses two-phase commit to ensure data consistency between the redo log and binlog, with the binlog acting as the coordinator of transactions. The two-phase commit mechanism makes the binlog a performance bottleneck. Kunpeng BoostKit provides several optimizations to improve system performance. This document uses Percona-Server as an example to describe how to use the binlog optimization feature on a Kunpeng server. Sysbench write-only tests show that the feature can improve the performance of Percona-Server 5.7.44-53 running on a container with 8 vCPU and 16 GB memory by 13%.