Monica Silva

Associate Database Systems Engineer

As a member of the MySQL team, Monica works with multiple clients to provide professional MySQL services such as database monitoring. She is currently working towards her MySQL 8.0 Database Administrator certification.

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... read more

The Elements of A Bash Script

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,... read more

Simple Steps for Rotating the Error Log

The error log is an important tool for troubleshooting. The size of the error log file can get quite large if left unattended. For starters, there are not many parameters that can be adjusted to impact its size in any way, unlike the binlog that has a few system... read more

Start Using Binlogs: A Quick Guide

Binary logs play an important role in replication and data recovery. In replication, source databases communicate data changes recorded in its binary logs to the replica’s relay logs. They can also be used to repair a replica experiencing data drift. In a... read more

Prepping for MySQL 5.7 Upgrade

MySQL 5.6 reached its end-of-life (EOL) in February 2021. If you haven’t upgraded to MySQL 5.7, you are not the only one. It can be an intimidating endeavor. There are configuration, system table, server, Innodb and SQL changes to consider. And, documentation is... read more

Migrating from SUPER to Dynamic Privileges

When performing health checks on a database, I look at how many users are granted SUPER privileges. If you’re reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to... read more