Thu, 04 Apr 2024 13:01:57 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/percona-backup-for-mongodb-restore-a-single-collection-from-backup/ https://www.percona.com/blog/percona-backup-for-mongodb-restore-a-single-collection-from-backup/#respond Thu, 04 Apr 2024 13:01:57 +0000 https://www.percona.com/blog/?p=95593 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 Objective”, which means how far back you will be able to […]]]> https://www.percona.com/blog/percona-backup-for-mongodb-restore-a-single-collection-from-backup/feed/ 0 95593 https://www.percona.com/blog/audit-drop-statements-in-percona-server-for-mysql/ https://www.percona.com/blog/audit-drop-statements-in-percona-server-for-mysql/#respond Tue, 02 Jan 2024 14:17:52 +0000 https://www.percona.com/blog/?p=93025 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 unexpected results, such as having an index drop affecting the system performance or even more […]]]> https://www.percona.com/blog/audit-drop-statements-in-percona-server-for-mysql/feed/ 0 93025 https://www.percona.com/blog/how-to-make-schema-changes/ https://www.percona.com/blog/how-to-make-schema-changes/#respond Tue, 12 Sep 2023 14:06:14 +0000 https://www.percona.com/blog/?p=90608 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 on the database that can cause serious problems to […]]]> https://www.percona.com/blog/how-to-make-schema-changes/feed/ 0 90608 https://www.percona.com/blog/dealing-with-too-many-connections-error-in-mysql-8/ https://www.percona.com/blog/dealing-with-too-many-connections-error-in-mysql-8/#comments Wed, 08 Mar 2023 12:58:53 +0000 https://www.percona.com/blog/?p=85961 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. Still, the users keep falling into […]]]> https://www.percona.com/blog/dealing-with-too-many-connections-error-in-mysql-8/feed/ 1 85961 https://www.percona.com/blog/pt-archiver-misbehaving-with-secondary-index/ https://www.percona.com/blog/pt-archiver-misbehaving-with-secondary-index/#comments Thu, 27 Oct 2022 12:06:41 +0000 https://www.percona.com/blog/?p=83258 Not long ago, we found a long-running query in one of our clients on Managed Services. While reviewing this long-running query, we found it was generated by a pt-archiver operation. That doesn’t sound good, right?I was able to reproduce the issue on my test environment. In this article, I will show you how to use […]]]> https://www.percona.com/blog/pt-archiver-misbehaving-with-secondary-index/feed/ 3 83258