How to Avoid Trouble in Database Operations | 10 Effective Ways

How to Avoid Trouble in Database Operations | 10 Effective Ways

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…

30 Questions To Ask A Serverless Fanboy
|

30 Questions To Ask A Serverless Fanboy

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…

Effective MySQL | Optimizing SQL Statements

Effective MySQL | Optimizing SQL Statements

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,…

Bulletproofing MySQL Replication with Checksums
|

Bulletproofing MySQL Replication with Checksums

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…

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…

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…

Is Upgrading RDS Like A Shit-Storm That Will Not End?
|

Is Upgrading RDS Like A Shit-Storm That Will Not End?

Can RDS worsen an outage ?? That’s another way to think about this question. In my experience, it very clearly increases outages, by tying one or both hands behind your back. Believe me, when I say, that is terribly frustrating when you’re putting out fires! Downsides of Upgrading RDS There are several downsides to upgrading RDS….

Oracle DBA Interview Questions

Oracle DBA Interview Questions

Oracle Database Administrators or often called DBAs are an indispensable part of your operations team. They manage the systems that house all your business data, your customers, products, transactions, and all that analytical data on what customers are actually doing. If you’ve ever been on the hunt, you may wonder, why the shortage of DBAs. To…