Example Analysis of auto_increment_offset and auto_increment_increment parameters of MySQL Master configuration

This article mainly shows you "MySQL main configuration auto_increase_offset and auto_increase_increase parameter example analysis", the content is simple and easy to understand, clear organization, I hope to help you solve doubts, let Xiaobian lead you to study and learn "MySQL main configuration auto_increase_offset and auto_increase_increase parameter example analysis" this article bar.

The parameters are explained as follows:

auto_increment_offset indicates the number from which the self-increment field starts, and refers to how much the field increments at a time. Its value range is 1.. 65535

auto_increment_increment indicates the increment amount of the self-increment field each time, and refers to the starting value of the self-increment field. Its default value is 1, and the value range is 1.. 65535

In order to avoid conflicts between the values of the self-growth field when two servers update at the same time. Generally, when configuring the master synchronization, you need to configure the auto_increase_increase of both servers to 2,

Auto_increment_offset is configured to 1 and 2 respectively.

The above is "MySQL master configuration auto_increase_offset and auto_increase_increase parameter sample analysis" All the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!