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.

Percona XtraBackup vs MySQL Enterprise Backup: Which One Should You Choose?

SUMMARY: Database administrators must select between the free, open-source Percona XtraBackup and the commercial MySQL Enterprise Backup (MEB) to perform reliable hot backups of large MySQL deployments, weighing cost savings against integrated enterprise features and... read more

Master to Master Replication in MySQL: Configuration Setup

SUMMARY: Senior database administrators implement MySQL Master-to-Master replication (bidirectional replication) to achieve high availability and load balancing by enabling read/write operations on two servers, a configuration that requires careful setup using Global... read more

Easy Steps to Creating a MySQL Password Policy

Creating a password policy by enforcing strong, complex passwords for user accounts is an essential step to improve database security. While enforcing a password policy can seem restrictive, it is crucial to securing your database and protecting sensitive data. MySQL... read more

Easy Guide to MariaDB Auditing

The MariaDB Audit Plugin is a powerful tool for database administrators aiming to improve security and accountability within their MariaDB environments. The MariaDB Audit Plugin logs user activities at the database level, like SQL queries, logins, and access patterns,... read more

MySQL Patch Updates: Linux MySQL Patching Steps

MySQL is an open-source relational database management system that individuals and organizations use. Its popularity has become a prime target for cyber attackers looking for vulnerabilities to exploit. To ensure the security of MySQL, Oracle releases critical patch... read more

Understanding the MySQL General Log

The MySQL General Query Log is a helpful tool for tracking and monitoring queries executed by the server. It logs every SQL query received from clients and server startup and shutdown events. This log can be an invaluable asset for database administrators and... read more