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!
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....
This blog article will explain what the SST method choices are and what you need to consider when choosing one over another. To start with, the wsrep_sst_method is a configuration parameter used with Galera Clustering. This parameter tells the database server which...
Encrypted connections for MySQL replication are the default as of 8.0. The following simple example shows a basic setup for encrypted replication using Ubuntu 20.04 and MySQL Community 8.0.27. The steps may be similar for other Linux distributions. The necessary files...
With the release of Db2 11.5.7.0, IBM has finally started providing cryptographically signed installation image files. This is important because it provides a means to verify that the installation image has not been tampered with or corrupted during download....
When IBM switched from old-school DMS and SMS tablespaces to Automatic Storage tablespaces, it became significantly easier for DBAs to create and manage tablespaces. This can lead to a proliferation of tablespaces; over time, some of these tablespaces may no longer be...
Deadlocking is a common issue in SQL Server that can have a direct negative impact on your users. What is deadlocking and how can it be resolved? All relational database management systems provide some kind of locking by design. There are times you want a table to be...
IBM Passport Advantage is the offering that can be used by customers as a one-stop-shop to view their IBM licensing entitlements, purchase orders and a plethora of other information. Oftentimes, when you need to download the latest binaries for a product that you need...
Recently I had a client ask me if there was a way to calculate the size of individual indexes on a table and how to interpret what is reported by the table function sysproc.admin_get_index_info. The client asked whether the value is reported as a sum per table or per...
What is a deadlock and what exactly does it mean in regards to databases? In order to fully define what a deadlock is, it's important to note that a 'lock' itself occurs when multiple processes are simultaneously trying to access the same resource. A deadlock occurs...
Understanding thread concurrency can help troubleshoot performance issues by optimizing how InnoDB multitasks between transaction requests simultaneously, but it is not a simple FIFO (first in: first out) process. That would not be efficient or leave much for a DBA to...