开发者

Auto Increment in Master - Master

开发者 https://www.devze.com 2023-01-26 05:02 出处:网络
I have set up Master Master replication and in order to avoid the duplicate primary key error, set the auto increment value to add 2 instead of default 1

I have set up Master Master replication and in order to avoid the duplicate primary key error, set the auto increment value to add 2 instead of default 1

auto_increment_offset=1
auto_increment_increment=2

This has helped the MMM setup to work as expected but it has some issues with the application that expects the linear sequence o开发者_如何转开发f numbers for auto ID's. Is there any solution to this problem?

0

精彩评论

暂无评论...
验证码 换一张
取 消