Automating Log Rotation with Logrotate

Automating Log Rotation with Logrotate

Rotating MySQL logs is important because logs can take up a lot of disk space if left unmanaged. For example, an untuned database can lead to a lot of slow queries being logged. The error log can become large if it includes notes and warnings. Additionally, binlogs...
MariaDB Galera Cluster WSREP_SST_METHOD Explained

MariaDB Galera Cluster WSREP_SST_METHOD Explained

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...
The Importance of /etc/hosts on Db2 Systems

The Importance of /etc/hosts on Db2 Systems

Recently, I was working on a system and noticed some odd behavior – running a simple db2pd command was taking what felt like a “long” time. I used the time utility to validate my impression: db2inst1@db2server $ time db2pd – Database Member 0 —...
Common TNS Errors and How to Troubleshoot

Common TNS Errors and How to Troubleshoot

In this blog, I will cover some typical TNS errors that we run across as an Oracle DBA and how to go about troubleshooting the errors. First of all, when you encounter a TNS error you need to understand that it relates to the network communication between a client...