I am trying to use puppet to create and manage mysql instances running under Ubuntu, probably using the puppetlabs-mysql module.
I am running into the issue that if you change the innodb_log_file_size parameter, mysql will complain and fail to start unless you delete the existing ib_logfiles before restarting mysql.
I am mainly concerned about getting mysql running after an initial install. I don't expect to change this paramater much, if at all, after that. However, since the debian package starts on install, it is already running before I can write the config file containing the innodb_log_file_size.
I have only been able to think of inelegant and probably dangerous ways to deal with this. Has anyone come up with a solution for this?