Automatic updates
I have given some thought this weekend to the following problem: automate the update process for an application installed on several servers. I am considering the following elements: an update has 2 parts: database update (via sql scripts) and application binaries updates all servers are accessible via ssh I’ve decided to write some thoughts regarding the process. Database update There are a few elements which have to be considered: when connecting to a database identify the current version determine which are the updates to apply keep some record of success and most important of failure Considering the above elements I think a “version” table should consist of at least the following fields: version, updated, status, comments....