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