In my previous blog, "Getting MySQL User Info: Limitations and Possibilities," I described how I found a solution to obtaining a history of login information for a specific user logging into the database from different servers if the audit log plugin is not installed...
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: [ERROR]...
As a business owner, you understand how important it is to keep your data safe and secure. Your company's data is one of its most valuable assets, and you cannot afford to lose it. That's why it's crucial to implement a point-in-time recovery plan for your MySQL...
As data becomes more and more central to business operations, it is crucial that companies ensure that their MySQL databases are running optimally. XTIVIA, a leading provider of database solutions, offers a comprehensive MySQL database health check that can help...
A client recently asked me if I could get the hostname or IP address of every server a MySQL user was using to connect for the past 30 days. I never thought of retrieving login information retrospectively. I wasn't sure if I could. Spoiler alert: it is only possible...
Unused indexes warrant an evaluation for several reasons. It can be a red flag that the MySQL Optimizer is not choosing to use the index, meaning that the index is not worth the effort to use. Additionally, unused indexes can take up valuable disk space. In MySQL...
Recently, I had a client that had a rack-mounted server that went into a hard lock on a Saturday morning. Monday morning, when it could be rebooted, MySQL received the dreaded "Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could...
Patching the operating system is essential to keeping your server secure and performing optimally. Patching is as easy as running an apt-get update and apt-get upgrade. However, this can cause some unintended consequences. For one, MySQL server will also be upgraded...
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...
Database administrators need to know databases as well as the operating system (OS) their database is running on. Bash scripting is where the two merge. For the beginner, bash scripting can be intimidating, but all have the same basic structure: a beginning, middle,...