Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.