MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database. All of these goals can…
MySQL databases are great workhorses of the internet. They back tons of modern websites, from blogs and checkout carts to huge sites like Facebook. But these technologies don’t run themselves. When you’re faced with a system that is slowing down, you’ll need the right tools to diagnose and troubleshoot the problem. MySQL has a huge community following…
While working with database operations, it is common to face a variety of errors. But when the error occurs, it gives us a lot of pain in the head. Fortunately, there are some tricks to avoid these troubles in database operations. So, why you should face trouble when you have options in your hand to…
Everyone is hot under the collar again. So-called serverless or no-ops services are popping up everywhere allowing you to deploy “just code” into the cloud. Not only won’t you have to login to a server, you won’t even have to know they’re there. In this guide, I’m going to provide you with 30 questions that…
So, you’ve been tasked with managing the MySQL databases in your environment, but you’re not sure where to start. Here’s the quick & dirty guide. Oh yeah, and for those who love our stuff, take a look to your right. See that subscribe button? Grab our newsletter! Steps to MySQL Management Here are the steps that…
Recently I was searching Google for “startup consultant” to see what I might find. I came across this article by John Greathouse titled Beware the Consultant. No self-respecting, hard-working consultant would sit back and take hits without defense, so in true poetry slam style, I thought I’d write a quick retort. Beware the Client… Truth Is…
I like that this book is small; 150 pages means you can carry it easily. It’s also very no-nonsense. It does not dig too deeply into theory unless it directly relates to your day-to-day needs. And those needs probably cluster heavily around optimizing SQL queries, as those pesky developers are always breaking things Jokes aside,…
Are your MySQL replicas running well? You might not even know if they aren’t. One of the scariest things about MySQL replication is that it can drift out of sync with the master “silently”. No errors, no warnings.In this article, we have explained bulletproofing MySQL replication with checksums. Let’s check them out! What Is MySQL…
What does a cloud computing expert need to know? In part one of the cloud interview guide we covered some basic unix & Linux systems administration skills, and cloud computing and infrastructure concepts. Those are key starting points. You might also want to jump to part 3 cloud dba, architecture and management interview questions. In this second part,…
What does a cloud computing expert need to know? How do you hire a cloud computing expert? Competition for operations & DBAs is fierce, so you’ll want to know how to find the best. If you’re a systems administrator or ops guy, you may want to prepare for an interview for such a position. Meanwhile, if…