How to handle ib_logfile size parameter in MySQL

80 views
Skip to first unread message

Byron Appelt

unread,
Aug 17, 2012, 5:36:30 PM8/17/12
to puppet...@googlegroups.com
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? 


Reply all
Reply to author
Forward
0 new messages