Monica Silva
Database Administrator
Monica is a certified MySQL Database Administrator working with multiple clients to provide professional MySQL services. She is currently working towards her AWS Cloud Practitioner certification.
One-way SSL Configuration Steps
With the increasing need for security in data transfer, MySQL provides an option for enabling SSL/TLS encryption to secure communication between the client and the server. SSL (Secure Sockets Layer) and its successor TLS (Transport Layer Security) use a combination of... read more
10 Tips for Securing MySQL Database
MySQL is one of the most widely used relational database management systems in the world. With its popularity comes the need to ensure the security of the data it manages. Below are some tips for securing a MySQL database. 1. Use Strong Passwords Passwords are the... read more
User History Bash Script
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... read more![Holland Backup Manager [ERROR] Insufficient Disk Space](https://virtual-dba.com/wp-content/uploads/Holland-Backup-Manager-_ERROR_-Insufficient-Disk-Space.jpg "Holland Backup Manager [ERROR] Insufficient Disk Space")
Holland Backup Manager [ERROR] Insufficient Disk Space
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:... read more
Getting MySQL User Info: Limitations and Possibilities
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... read more