There is an on-going shift within many organizations where the focus placed on application engineers is expanding while at the same time infrastructure teams within the DBA landscape are being trimmed back. The result is application engineers with little to no database experience and DBAs who are completely overwhelmed  both looking for resources to [&]

https://www.percona.com/blog/2020/10/20/introducing-the-percona-enterprise-platform/

Percona is pleased to announce the release of Percona Distribution for PostgreSQL 13. This release is available for immediate download and includes all of the latest features of PostgreSQL 13 Core Distribution. Reduce Resource Usage This release includes enhancements to existing features that deliver a more streamlined and optimized environment, helping you to reduce overall [&]

https://www.percona.com/blog/2020/10/19/announcing-percona-distribution-for-postgresql-13/

Percona Monitoring and Management (PMM) is an open-source tool developed by Percona that allows you to monitor and manage your MongoDB, MySQL, and PostgreSQL databases.  This blog will give you an overview of troubleshooting your MongoDB deployments with PMM. Let’s start with a basic understanding of the architecture of PMM. PMM has two main architectural [&]

https://www.percona.com/blog/2020/10/19/pmm-101-troubleshooting-mongodb-with-percona-monitoring-and-management/

MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up. Oftentimes, developers want a quick environment to just test out an idea they have for an application or to try and figure out a good data model for their data without waiting for their Operations team [&]

https://www.percona.com/blog/2020/10/19/5-things-developers-should-know-before-deploying-mongodb/

Changing the default value (3) of log_error_verbosity in MySQL/Percona Server for MySQL 5.7 can have a hidden unintended effect! What does log_error_verbosity do exactly? As per the documentation: “The log_error_verbosity system variable specifies the verbosity for handling events intended for the error log.“ Basically a value of 1 logs only [Errors]; 2 is 1)+[Warnings]; and [&]

https://www.percona.com/blog/2020/10/16/danger-of-changing-default-of-log_error_verbosity-on-mysql-percona-server-for-mysql-5-7/

MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up for a DBA.  Oftentimes, relational DBAs will inherit MongoDB databases without knowing all there is to know about MongoDB.   I encourage you to check out our Percona blogs as we have lots of great information [&]

https://www.percona.com/blog/2020/10/16/dbas-should-know-before-deploying-mongodb/

I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database.  Why? Because if you look from an application developer’s point of view, once a database is provisioned and you can connect to it, responding to your queries promptly and correctly is [&]

https://www.percona.com/blog/2020/10/14/announcing-pg_stat_monitor-tech-preview-get-better-insights-into-query-performance-in-postgresql/

Its release roundup time here at Percona! Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself. Todays post includes those releases and [&]

https://www.percona.com/blog/2020/10/13/percona-distribution-for-mysql-pxc-variant-8-0-20-fixes-for-security-vulnerability-release-roundup-october-13-2020/

From time to time we are asked how to limit users to viewing only some dashboards or servers in Percona Monitoring and Management (PMM). Here are some hints on how to do this. Lets imagine you want the following: Users user1 and user2 are only allowed to see the CPU Utilization Details dashboard for server1, [&]

https://www.percona.com/blog/2020/10/12/setup-teams-users-with-limited-access-in-percona-monitoring-and-management/

Have you recently visited Percona’s Community Forum? It’s your hub for direct Q&A with top database experts, including Percona CEO Peter Zaitsev and CTO Vadim Tkachenko. Last quarter over 450 users participated, including 45 engineers from Percona’s staff. Since it was first launched in 2006 and revamped earlier this year, our Forum has built up [&]

https://www.percona.com/blog/2020/10/12/ask-an-expert-on-perconas-community-forum/

For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking about a multi-primary setup where I can write at [&]

https://www.percona.com/blog/2020/10/09/amazon-aurora-multi-primary-first-impression/

As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes is becoming more popular as companies are investigating and adopting this technology. [&]

https://www.percona.com/blog/2020/10/08/the-criticality-of-a-kubernetes-operator-for-databases/

Percona Monitoring and Management (PMM) is a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases. In this blog, we will look at troubleshooting MySQL issues and performance bottlenecks with the help of PMM. We can start troubleshooting MySQL after selecting the appropriate server or cluster from the PMM dashboard. [&]

https://www.percona.com/blog/2020/10/08/mysql-101-troubleshooting-mysql-with-percona-monitoring-and-management/

Recently I was dealing with an unexpected issue raised by our Support customer, in which data became inconsistent after a schema change was applied. After some investigation, it turned out that affected tables had a special word in the comments of some columns, which triggered an already known (and fixed) issue with the TableParser.pm library [&]

https://www.percona.com/blog/2020/10/08/dangerous-edge-case-warning-for-percona-toolkit-and-pt-online-schema-change/

Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the queries themselves. Having info on all the stats around query execution is priceless, and Percona Monitoring and Management (PMM) offers that in the form of the Query Analytics dashboard (QAN). But where to start? QAN [&]

https://www.percona.com/blog/2020/10/07/how-to-find-query-slowdowns-using-percona-monitoring-and-management/

Any good system must be built to expect the unexpected. None are perfect and at some point, something WILL happen to render the system non-operational causing failure. Join Dimitri Vanoverbeke, Senior Percona Engineer, as he discusses the concepts of High Availability, Disaster Recovery, common missteps that happen along the way, and how to ultimately prepare [&]

https://www.percona.com/blog/2020/10/07/webinar-october-27-disaster-recovery-and-high-availability-the-concepts-the-mistakes-and-how-to-properly-plan-for-failure/

Hey Community! This is my first blog post so let me introduce myself. My name is Vasyl Yurkovych. I am a QA Automation Engineer at Percona and I have solid experience in software testing.  Software quality is one of the main focuses of Percona so we put a lot of energy into it (hopefully so [&]

https://www.percona.com/blog/2020/10/07/our-approach-to-percona-monitoring-and-management-upgrade-testing/

Schema changes are the big challenges in Galera replication. So, it is recommended to understand the schema changes operation for everyone who uses the Percona XtraDB Cluster (PXB)/Galera clusters. In this blog, I am going to explain the operation and impact of the various schema changes methods used in the PXB/Galera cluster. Schema changes with [&]

https://www.percona.com/blog/2020/10/06/various-ways-to-perform-schema-upgrades-with-percona-xtradb-cluster/

Would you like to get the latest in Percona gear 100% free, shipped to you anywhere in the world? Maybe that sounds too good to be true, but it’s true!  It’s easy and takes as little as 20 minutes to earn your swag. Here are some examples of the swag items you can claim: So [&]

https://www.percona.com/blog/2020/10/05/grab-your-percona-swag/

We are excited to share the great lineup of speakers from the open source database community who will be spotlighting key technological, industry, and social topics throughout the event, including talks specific to MySQL, PostgreSQL, and MongoDB to close out our 28-hour Percona Live ONLINE event. View the Full Agenda and Register Now! Opening Keynotes [&]

https://www.percona.com/blog/2020/10/02/keynote-speakers-for-percona-live-online-have-been-announced/