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?

Table of contentsWhat is XtraBackup?What is MySQL Enterprise Backup?Key DifferencesWhich MySQL Backup Should You Choose?Final Thoughts When it comes to backing up large MySQL databases, especially without downtime, two tools dominate the conversation: Percona... read more

Master to Master Replication in MySQL: Configuration Setup

Table of contentsMaster-to-Master Replication Advantages and DisadvantagesAdvantagesDisadvantagesSteps to Configure Master-to-Master Replication in MySQLStep 1. Configure my.cnf (or my.ini)Step 2. Create Replication UsersStep 3. Sync DatabasesStep 4: Configure GTID... 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