by Monica Silva | Apr 11, 2023 | Blog, MySQL
If you’re reading this blog, you know that Holland Backup Manager is an easy and efficient way to configure backups. Most of the issues I have experienced are user errors, specifically how I configured the backups. The following error is one such example:...
by Monica Silva | Oct 28, 2022 | Blog, Database, MySQL
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...
by Cheryl Bryll | Jan 20, 2022 | Blog, MySQL
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...
by Ian Bjorhovde | Aug 10, 2021 | Blog, Db2
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 —...
by Cheryl Bryll | Jan 14, 2021 | Blog, Oracle
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...
by Cheryl Bryll | Aug 18, 2020 | Blog, Oracle
In this blog, I’ll be giving a tutorial on an Oracle hidden gem using an Oracle tool to securely allow you to run RMAN without passing the password in cleartext. The Oracle Database Secure External Password Store feature, which does not require any additional...