Ask Your Question

How best to handle config settings stored in database not files

asked 2013-07-26 04:27:01 -0500

mobcdi gravatar image

Puppet allows me to easily work with configuration settings that reside in files but whats the best way of handling configuration settings that get stored in an app's database instead.

Example: I want to configure a blog server and be able to reproduce and manage the configuration via puppet. I use forge modules to configure the web server & db and install wordpress but now I only a generic wordpress.

How do I go about making sure the wordpress cms is configured as I need it and reproducable e.g the title is X, the theme is Y but possibly ... (more)

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted

answered 2013-07-26 07:16:08 -0500

llowder gravatar image

As far as a direct answer goes, you have a few options.

What I've done in cases like this was to puppetize anything that was configured via a config file, and anything that was entered via a GUI (and stored in a database) I simply backed up.

The idea being that I could then easily roll out a new instance and then restore the backup in the event of a disaster.

That does not, however, directly answer the question.

If you want to puppetize these database based config items, you will need to either create a custom type and ... (more)

edit flag offensive delete link more

answered 2013-07-26 07:49:18 -0500

mobcdi gravatar image

Thanks for responding. Can I ask how you manage the documentation and change management of the GUI configurations that get backed up and if you relate that back to puppet stored configurations or is puppet mainly aimed at getting hosts 80% ready and the final 20% made up of data & additional configurations would be carried out either by restoring from a backup or manually configurating from documentation while puppet makes sure its work isn't undone

edit flag offensive delete link more


In my situation, I was responsible for the server, so I just had to worry about getting the appropriate software on it and configuring the bits that those not in ...(more)

llowder gravatar imagellowder ( 2013-07-26 08:46:05 -0500 )edit

I did, however, make sure that there were regular backups & that the backups were usable. At that job, the main reason we used puppet was for DR. The automation & other ...(more)

llowder gravatar imagellowder ( 2013-07-26 08:48:02 -0500 )edit

answered 2013-07-26 09:25:38 -0500

ethrbunny gravatar image

If you are using MySQL to manage your WP (or other settings) and have a base-config that you start from, you can zip up the relevant files from the MySQL folder and copy them to your client / agent. When you restart MySQL it will pickup these new files and setup the relevant tables / other structures for you.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2013-07-26 04:27:01 -0500

Seen: 228 times

Last updated: Jul 26 '13