Binary logs play an important role in replication and data recovery. In replication, source databases communicate data changes recorded in its binary logs to the replica's relay logs. They can also be used to repair a replica experiencing data drift. In a similar way,...
Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
Troubleshooting Transient AlwaysOn and Windows Failover Cluster Service Timeouts
You may see events in your error logs reporting transient connection failures between cluster nodes or AlwayOn. You may observe high Asynch_Network_IO in [sys].[dm_os_wait_stats]. And you may have even brought it to the attention of your Network folks, only to be sent...
Azure Monitor
There are quite a few monitoring tools out there that can benefit you in your environment, but if you want to capitalize on robust alerting and monitoring within the Azure space, then Azure Monitor is the ideal solution to use. Azure Monitor will allow your...
Best Practices for Migrating Servers and Applications to Microsoft Azure
In this article, you will learn best practices on migrating on-premise servers and applications to Azure. The push to the cloud is expediting, and it is essential to understand best practices and how to migrate on-premise servers and applications to Microsoft Azure....
The Difference Between Blocking and Deadlocks
When I was learning about Microsoft SQL Server issues a DBA needs to understand, I was reading about deadlocks. At first, I was confused because it sounded like the definition of blocking, which I was already more familiar with. I re-read it a couple of times and...
Investigating Locking in Db2
The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these...
Prepping for MySQL 5.7 Upgrade
MySQL 5.6 reached its end-of-life (EOL) in February 2021. If you haven't upgraded to MySQL 5.7, you are not the only one. It can be an intimidating endeavor. There are configuration, system table, server, Innodb and SQL changes to consider. And, documentation is not...
Migrating from SUPER to Dynamic Privileges
When performing health checks on a database, I look at how many users are granted SUPER privileges. If you're reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
Resolving SQLCODE -551 on View Creation
I recently faced an interesting challenge. I was working to replace (rebuild) a view with updated DDL, but when executing the CREATE OR REPLACE VIEW statement, Db2 returned error code SQL0551N. This error means that the user ID doesn't have authority to perform the...
Percona XtraBackup Example
For this example, the following software versions were in use: Ubuntu v20.04.3MySQL server v5.7.35Percona XtraBackup v2.4.24 It is important to note that Percona XtraBackup 8.0 is not compatible with MySQL version 5.7 and was introduced for use with MySQL version 8.0....