Hey!

I was looking into how I could change the behavior of AUTOINCREMENT in our database, specifically innodbautoinclockmode from 2 to 0. I cannot any way to make this change, does anyone know how I can apply this change to my cluster/database? Help is much appreciated!

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi there

I understand you want to change the variable innodbautoinclock_mode from 2 to 0 for managed database. Unfortunately, we do not currently support that configuration change as there are some implications(mentioned in below link) which needs to analyse first before implementing this change.

https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html

But we have created a feature request ticket in our backlog for our engineering team to add it and you will be informed with any updates.

Please let us know if you have additional questions/concerns.

Regards
DigitalOcean Support

Submit an Answer