Mon, 20 May 2024 15:48:34 +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/new-valkey-packages-by-percona/ https://www.percona.com/blog/new-valkey-packages-by-percona/#respond Mon, 20 May 2024 15:48:34 +0000 https://www.percona.com/blog/?p=96358 Valkey 7.2.5 has been officially released as the first General Availability (GA) version, a significant milestone for the project. It is now available in multiple formats: as an official Docker container, through Fedora/EPEL yum repositories, and as binary tarballs for both Ubuntu Bionic and Ubuntu Focal. This availability ensures straightforward installation on rpm-based systems, though […]]]> https://www.percona.com/blog/new-valkey-packages-by-percona/feed/ 0 96358 https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/ https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/#respond Mon, 20 May 2024 13:06:30 +0000 https://www.percona.com/blog/?p=96350 If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]]]> https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/feed/ 0 96350 https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/ https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/#respond Thu, 16 May 2024 12:46:12 +0000 https://www.percona.com/blog/?p=96342 Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting their similarities […]]]> https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/feed/ 0 96342 https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/ https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/#respond Mon, 13 May 2024 13:19:30 +0000 https://www.percona.com/blog/?p=96293 Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]]]> https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/feed/ 0 96293 https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/ https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/#respond Wed, 08 May 2024 18:11:31 +0000 https://www.percona.com/blog/?p=96112 Coroot, an open source observability tool powered by eBPF, went generally available with version 1.0 last week. As this tool is cloud-native, we were curious to know how it can help troubleshoot databases on Kubernetes.In this blog post, we will see how to quickly debug PostgreSQL with Coroot and Percona Operator for PostgreSQL.PrepareInstall CorootThe easiest […]]]> https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/feed/ 0 96112 https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/ https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/#respond Wed, 08 May 2024 13:25:22 +0000 https://www.percona.com/blog/?p=92932 Percona Monitoring and Management (PMM) has become a valuable tool for database professionals, providing comprehensive insights into database health and performance. A recent update (version 2.41.0) introduced a significant enhancement: the ability to run PMM in high availability (HA) mode. This feature, currently in technical preview, offers exciting possibilities for ensuring the reliability and robustness […]]]> https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/feed/ 0 92932 https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/ https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/#respond Fri, 26 Apr 2024 15:54:53 +0000 https://www.percona.com/blog/?p=96020 The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared to our previous MVP release. In addition to lots of bug fixes, the new release supports multi-tenancy and key rotation with a simplified configuration mechanism. Note that the Tech Preview release is not recommended for […]]]> https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/feed/ 0 96020 https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/ https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/#respond Fri, 26 Apr 2024 12:46:44 +0000 https://www.percona.com/blog/?p=96016 Cloud-native databases are becoming the norm, and containerized databases are a common trend (see the report from Dynatrace and Figure 1). Kubernetes—the de facto standard for platform engineers—and operators simplify database deployment and management. But what are the performance implications of running databases in Kubernetes? To answer this question, we compared the performance of Percona Server for […]]]> https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/feed/ 0 96016 https://www.percona.com/blog/why-mariadb-is-better-than-mysql/ https://www.percona.com/blog/why-mariadb-is-better-than-mysql/#respond Tue, 23 Apr 2024 15:36:53 +0000 https://www.percona.com/blog/?p=95980 Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […]]]> https://www.percona.com/blog/why-mariadb-is-better-than-mysql/feed/ 0 95980 https://www.percona.com/blog/mongodb-4-4-eol-with-5-0-not-far-behind/ https://www.percona.com/blog/mongodb-4-4-eol-with-5-0-not-far-behind/#respond Wed, 10 Apr 2024 14:52:44 +0000 https://www.percona.com/blog/?p=95596 February 2024 marked the end of life (EOL) of MongoDB 4.4.Another year, another EOL, is a fitting summary. Time goes by fast, and looking from this perspective, 5.0 is one we will soon also say goodbye to, as this year, 5.0 is also going EOL in October.Why is MongoDB 4.4 EOL significant?In case you and […]]]> https://www.percona.com/blog/mongodb-4-4-eol-with-5-0-not-far-behind/feed/ 0 95596 https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/ https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/#respond Tue, 09 Apr 2024 16:02:36 +0000 https://www.percona.com/blog/?p=95688 We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now that MySQL 5.7 has reached EOL, MySQL 8 […]]]> https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/feed/ 0 95688 https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/ https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/#respond Tue, 09 Apr 2024 12:41:11 +0000 https://www.percona.com/blog/?p=95493 Tech Preview release of pg_tde now availableAs organizations collect, store, and analyze vast amounts of data, ensuring its confidentiality and integrity becomes a top priority. For PostgreSQL users, the tech preview release availability of the new encryption extension pg_tde delivers unmatched protection for vital data assets.What is pg_tde?pg_tde, developed by Percona, is an open source […]]]> https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/feed/ 0 95493 https://www.percona.com/blog/querying-percona-operator-for-mongodb-logs-using-logcli/ https://www.percona.com/blog/querying-percona-operator-for-mongodb-logs-using-logcli/#respond Fri, 05 Apr 2024 15:08:36 +0000 https://www.percona.com/blog/?p=95653 With all the convenience Kubernetes operators provide in managing resources, it can still be a challenge to conveniently store, query, manage, and download the database logs from the pods. Since the pod logs are rotated after a certain period or size depending on the configuration and workload, it’s necessary to collect them to analyze for […]]]> https://www.percona.com/blog/querying-percona-operator-for-mongodb-logs-using-logcli/feed/ 0 95653 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/mysql-101-how-to-find-and-tune-a-slow-sql-query/ https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/#respond Wed, 03 Apr 2024 12:02:51 +0000 https://www.percona.com/blog/?p=69394 This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […]]]> https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/feed/ 0 69394 https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/ https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/#respond Tue, 02 Apr 2024 13:55:28 +0000 https://www.percona.com/blog/?p=84444 This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It is used to quickly locate data without having to […]]]> https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/feed/ 0 84444 https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/ https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/#comments Tue, 02 Apr 2024 11:23:21 +0000 https://www.percona.com/blog/?p=84466 This blog was originally published in January 2023 and was updated in April 2024.Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. While working, the customer raised two interesting questions: how […]]]> https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/feed/ 1 84466 https://www.percona.com/blog/mysql-key-performance-indicators https://www.percona.com/blog/mysql-key-performance-indicators#respond Tue, 02 Apr 2024 09:00:29 +0000 https://www.percona.com/blog/?p=88829 This blog was originally published in June of 2023 and updated in April of 2024.As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for […]]]> https://www.percona.com/blog/mysql-key-performance-indicators/feed/ 0 88829 https://www.percona.com/blog/percona-pg_tde-project-keyring-options/ https://www.percona.com/blog/percona-pg_tde-project-keyring-options/#respond Mon, 01 Apr 2024 13:17:52 +0000 https://www.percona.com/blog/?p=95492 Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. We are actively asking you to test this code to help build a better project. So please test pg_tde!As you have probably read in earlier blogs on pg_tde, it depends on a keyring.Two keysEncrypting the data requires two types of keys.The first […]]]> https://www.percona.com/blog/percona-pg_tde-project-keyring-options/feed/ 0 95492 https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/ https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/#respond Mon, 01 Apr 2024 09:00:09 +0000 https://www.percona.com/blog/?p=86687 This blog was published in April of 2023 and updated in April 2024.PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability, scalability, and performance. However, as the size of your database grows, it can […]]]> https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/feed/ 0 86687