Deploying MySQL on Amazon EC2 – 8 Best Practices
|

Deploying MySQL on Amazon EC2 – 8 Best Practices

There are a lot of considerations for deploying MySQL in the Cloud. Some concepts and details won’t be obvious to DBAs used to deploying on traditional servers. For this, we have provided eight best practices in this guide that will certainly set you off on the right foot. Let’s explore them below. This article is part…

Did MySQL & Mongo Have a Beautiful Baby Called Aurora? 

Did MySQL & Mongo Have a Beautiful Baby Called Aurora? 

Amazon recently announced RDS Aurora a new addition to their database as a service offering. Here’s Mark Callaghan’s take on what’s happening under the hood and thoughts from Fusheng Han. Amazon is uniquely positioned with RDS to take on offerings like Clustrix. So, it’s definitely worth reading Dave Anselmi’s take on Aurora. Features of Aurora Here are what you can get…

Don’t Be That Guy–Social Tips for Geeks

Don’t Be That Guy–Social Tips for Geeks

As a tech consultant, one of the most interesting parts of the job is being able to observe human relations at work. I’ve learned through the years that because tech people and non-tech people speak different ‘languages’, bridging the communication gap is a critical part of my role as a consultant. How Should You Treat…

How Not to Handle “We’re Not Paying” Emails…?

How Not to Handle “We’re Not Paying” Emails…?

I saw this thread recently posted on Hacker News. “We’re not paying invoices due to the pandemic” – How to handle these. What shocked me is what Patrick McKenzie (@patio11) suggested: “The right response is probably ‘I have received your letter. The invoice is good. I demand payment by the date on the invoice, under the…

How to Optimize MySQL for High Speed
|

How to Optimize MySQL for High Speed

There is no need to mention that speed is one of the most sought-after attributes in any database system. Optimizing MySQL for high speed is essential to ensure responsive applications and efficient data processing. There are basically two best ways to speed up UNION in MySQL – using UNION ALL and using push-down conditions. In…

How To Setup An Amazon ECS Cluster With Terraform | A Step-By-Step Guide

How To Setup An Amazon ECS Cluster With Terraform | A Step-By-Step Guide

ECS is Amazon’s Elastic Container Service. That’s Greek for how you get docker containers running in the cloud. It’s sort of like Kubernetes without all the bells and whistles. It takes a bit of getting used to, but This terraforms how to, should get you moving. You need an EC2 host to run your containers…