ECS is Amazon’s elastic container service. If you have a dockerized app, this is one way to get it deployed in the cloud. It is basically an Amazon bootleg Kubernetes clone. And not nearly as feature-rich! That said, ECS does work, and it will allow you to get your application going on Amazon. Soon enough…
I was recently talking with a colleague of mine about where AWS is today. Obviously, these companies are migrating to EC2 & the cloud rapidly. The growth rates are staggering. The question was… “What’s good and bad with Amazon today?” It’s an interesting question. I think there are some dirty little secrets here, but also…
I was flipping through the AWS Reddit channel and found this excellent presentation from RE: Invent by Laura Grit. She’s in charge of Amazon Retail and worked very closely with teams on migrating to AWS. She goes in-depth on what that cost in terms of development, what it saved in terms of unused capacity, and surprisingly operational…
You want to make your wordpress site bulletproof? No server outage worries? Want to make it faster & more reliable. And also host on cheaper components? I was after all these gains & also wanted to kick the tires on some of Amazon’s latest devops offerings. So, I plotted a way forward to completely automate…
If you run MySQL as your backend datastore is there one thing you can do to improve performance across the application? Those SQL queries are surely key. And the quickest way to find the culprits is to regularly analyze your log. I’ve put together a howto & script for doing this on Amazon RDS. Automate mysql…
I like the image of the city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the world’s largest cities today, New York. I’m a long-time relational database guy. I worked at scores of dot-coms in the 90’s as an old-guard Oracle DBA, and pivoted…
Amazon’s spot market for computing power is set up as an open market for surplus servers. The price is dynamic and depends on demand. So, when demand is low, you can get computing instances for rock-bottom prices. When you do that, you normally set a range of prices you’re willing to pay. If it goes…
SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. You can write tighter queries in MySQL easily by following 3 simple tricks – SUBQUERIES, UNION, and PAGING. In this article, we will explain all these patterns to write MySQL codes more efficiently. 3 Best…
In the realm of database management and development, optimizing SQL performance is a perennial challenge. If you’re looking to up your SQL performance tuning game, Markus Winand’s book “SQL Performance Explained” is a must-have in your arsenal. It’s become the go-to resource for understanding and mastering all things SQL performance. Let’s explore the five great…
Deploying new code that includes changes to your database schema doesn’t have to be a process fraught with stress and burned fingers. For better database change management, you need to be a little bit tricky. You can make it more efficient by deploying roll forward and rollback scripts, performing backups, reviewing tests, and much more….