Database Management Archives - Page 3 of 6

ARE SQL DATABASES DEAD?

August 16, 2023 / BY Nolan Granger

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 …

3 Simple Patterns for Tighter MySQL Code

August 16, 2023 / BY Nolan Granger

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 …

5 Tips for Better Database Change Management

August 16, 2023 / BY Nolan Granger

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 …

How To Fortify MySQL Replication | 5 Best Ways

August 16, 2023 / BY Nolan Granger

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 …

Accidental DBA’s Guide to MySQL Management

August 16, 2023 / BY Nolan Granger

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 …

Effective MySQL | Optimizing SQL Statements

August 16, 2023 / BY Nolan Granger

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 …

Bulletproofing MySQL Replication with Checksums

August 16, 2023 / BY Nolan Granger

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 …

Deploying MySQL on Amazon EC2 – 8 Best Practices

August 16, 2023 / BY Nolan Granger

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 …

Did MySQL & Mongo Have a Beautiful Baby Called Aurora?

August 16, 2023 / BY Nolan Granger

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 …

How to Optimize MySQL for High Speed

August 16, 2023 / BY Nolan Granger

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 …

Oracle DBA Interview Questions

August 16, 2023 / BY Nolan Granger

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 …

Ten Things to Remember About MySQL Backups

August 16, 2023 / BY Nolan Granger

In today’s data-driven world, ensuring the safety of your valuable data is crucial. To safeguard this data using MySQL, implementing a robust backup strategy is essential. For this, we have …