MySql autoincrement counter resetting after server restart
MySQL fix
After 14.5 years this is fixed in MySQL version 8.0
[6 Oct 16:40] Daniel Price Posted by developer: Fixed in 8.0.0 by WL#6204.
- WL#6204: InnoDB persistent max value for autoinc columns
MariaDB fix
Also this was MariaDB 10.2.4 released on July 12, 2017
- MDEV-6076 Persistent AUTO_INCREMENT for InnoDB.
I found out this change was finally added on the 2ndquadrant blog,
- Why PostgreSQL is better than MySQL