We had our first DevOps Ireland meetup in Dublin on Thursday 7th June, at the Duke, a pub in Dublin. There were only 4 of us this time but the plan is to do more and maybe one day we can convince Patrick Desbois to organize devopsdays in Dublin.
The Tarantino project has a great database change management module. We like it because it is very easy to implement. Migrations are just a bunch of sql scripts in a folder. To determine the order of execution of the migration, Tarantino just sorts the file names. It expects the first part of the file names to be a unique number so that it can easily determine if a given script was already applied to a database.
As we deal with huge data volumes, sometimes our migration scripts run for longer than the default SMO timeout of 10 minutes. To keep things simple, I patched Tarantino so that if it detects the keywords “timeout” or “time-out” in a file name, it will use the first following number to set the timeout in seconds for the execution of that scripts. That allows to name scripts as in “001-My migration with a timeout of 1200 seconds.sql” to set the execution timeout for that script to 20 minutes.
Link to the patch.
Today I have decided to start a devops group in Dublin. First and very easy thing to do: create a Google group called Dublin DevOps.