by Michael Villegas | Apr 4, 2024 | Insight for DBAs, MongoDB, Percona Software
When you design a backup strategy, you need to think about the business requirements, as you will need to shape your backups to meet them. Let’s review the basics briefly; you need to define the RPO and RTO. The RPO stands for “Recovery Point... by Michael Villegas | Jan 2, 2024 | Insight for DBAs, MySQL, Percona Software, Security
Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal required permissions to the different user accounts in the database, as having a user with high-level permission can lead to... by Michael Villegas | Sep 12, 2023 | Insight for DBAs, MySQL
Schema changes are required to add new features or to fix bugs in an application. However, there is no standard procedure to make the changes in a quick and safe manner. If the changes are not made considering the necessary precautions, you may face unwanted outages... by Michael Villegas | Mar 8, 2023 | Insight for DBAs, Insight for Developers, MySQL
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One of the most common problems I faced is the one related to the well-known error “ERROR 1040 (08004): Too many connections”. A lot has been written about this error....