Hey!
I was looking into how I could change the behavior of AUTO_INCREMENT in our database, specifically innodb_autoinc_lock_mode 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!
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.
Hi there
I understand you want to change the variable innodb_autoinc_lock_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
Woops auto formatting. The variable I was looking to change is
innodb_autoinc_lock_mode