When we run ALTER statements on our big tables we have to plan ahead to keep from breaking whatever service is using the database. In MySQL, many times* a simple change to a column (say, from being a short varchar to being a text field) can read-lock the entire table for however long it takes to make the change. If you have a service using the table when you begin the query you’ll start eating into your downtime budget.
Jared, Stuart, and Andy recently spent some time focusing on one of the Marketplace’s biggest hurdles for new contributors: how do I get all these moving pieces set up and talking to each other?
This post is a celebration of finishing a migration off of Wordpress for this site and on to flat files, built by Jekyll from Markdown files. I’m definitely looking forward to writing more Markdown and fewer HTML tags.
The AMO team is meeting this week to discuss road maps and strategies and among the topics is our backlog of open bugs. Since mid-2011 there has averaged around 1200 bugs open at any one time.
A few years ago we deployed a landfill for AMO - a place where people could play around with the site without affecting our production install and developers could easily get some data to import into their local development environment.