Percona Monitoring and Management (PMM) is a great way to monitor your MongoDB deployment for things like memory, CPU, inter-database metrics like wiredTiger cache utilization, read/write ticket utilization, Query Analytics, and many, many more.  Did you know that in addition to all that, it also has a security threat tool?  In this blog, we’ll go [&]

https://www.percona.com/blog/2021/01/26/achieving-a-more-secure-mongodb-with-percona-monitoring-and-managements-security-tool/

Kubernetes has become an integral part of many architectures and has continued to rise in popularity.  Kubernetes is an open source platform for managing containerized workloads and services.  One approach to running Kubernetes is Redhat’s OpenShift.  OpenShift is RedHat’s name for its family of containerization products.  The main part of OpenShift and the product we’ll [&]

https://www.percona.com/blog/2021/01/22/getting-started-with-mongodb-in-openshift-using-the-percona-server-for-mongodb-kubernetes-operator/

The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, and we were curious to see how it performs with PostgreSQL. The general availability of ARM-based servers for testing and evaluation was a major obstacle. The icebreaker was when AWS announced their ARM-based processors offering [&]

https://www.percona.com/blog/2021/01/22/postgresql-on-arm-based-aws-ec2-instances-is-it-any-good/

Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable you need to modify under most circumstances. But from time to time we get some performance tickets related to this. What problem does this variable cause if it is not properly sized? Let’s find out [&]

https://www.percona.com/blog/2021/01/21/low-value-in-range_optimizer_max_mem_size-might-cause-full-table-scan/

What is Node Draining? Anyone who ever worked with containers knows how ephemeral they are. In Kubernetes, not only can containers and pods be replaced, but the nodes as well. Nodes in Kubernetes are VMs, servers, and other entities with computational power where pods and containers run. Node draining is the mechanism that allows users [&]

https://www.percona.com/blog/2021/01/20/drain-kubernetes-nodes-wisely/

Last week Elastic announced that they were “Doubling Down” on open source by changing their licensing to a non-open license  MongoDB’s Server Side Public License, or SSPL.  Let me clarify in my opinion this is not doubling down  unless, as our good friend @gabidavila highlighted, that maybe the thinking was a double negative [&]

https://www.percona.com/blog/2021/01/20/keeping-open-source-open-or-why-open-is-better/

As many of you have seen already, MySQL 8.0.23 is available for download (release notes). Today our dear LeFred thanked all the numerous contributors to bug fixes.  About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and Kamil Holubicki. Great work guys! On my side, I have reviewed the [&]

https://www.percona.com/blog/2021/01/20/mysql-8-0-23-is-available-highlighting-some-important-points/

Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server. The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the box. It is easy to rebuild a replica or to add new nodes [&]

https://www.percona.com/blog/2021/01/19/the-mysql-clone-wars-plugin-vs-percona-xtrabackup/

Enter pg_stat_monitor: this extension, created here at Percona, has been developed as an advanced replacement of pg_stat_statement, providing new capabilities in addition to the standard fare. As you may recall, PostgreSQL’s pg_stat_statements extension provides a means of tracking execution statistics of all SQL statements executed by the server. But sometimes just having the basics is [&]

https://www.percona.com/blog/2021/01/19/pg_stat_monitor-a-new-way-of-looking-at-postgresql-metrics/

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

https://www.percona.com/blog/2021/01/18/updates-to-percona-xtradb-cluster-new-features-in-percona-toolkit-3-3-0-release-roundup-january-18-2021/

The “SHOW PROCESSLIST command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex. From MySQL 8.0.22, we have an alternative way [&]

https://www.percona.com/blog/2021/01/15/mysql-8-0-22-show-processlist-version-2-now-available-from-performance_schema/

I was once helping one of our customers on how to load MySQL audit logs into a MySQL database and analyze them. But immediately I thought: Hey, this is not the most efficient solution! MySQL or typical RDBMS, in general, were not really meant to store logs after all. So, I decided to explore an [&]

https://www.percona.com/blog/2021/01/14/how-to-store-mysql-audit-logs-in-mongodb-in-a-maintenance-free-setup/

Are you thinking about deploying MongoDB? Is it the right choice for you? Choosing a database is an important step when designing an application. A wrong choice can have a negative impact on your organization in terms of development and maintenance. Also, the wrong choice can lead to poor performance. Generally speaking, any kind of [&]

https://www.percona.com/blog/2021/01/14/thinking-about-deploying-mongodb-read-this-first/

PostgreSQL is one of the leading open-source databases, but, out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using all available resources. PostgreSQL provides a system [&]

https://www.percona.com/blog/2021/01/14/webinar-january-28-tuning-postgresql-for-high-performance-and-optimization/

What is Edge Edge is a buzzword that, behind the curtain, means moving private or public clouds closer to the end devices. End devices, such as the Internet of Things (from a doorbell to a VoIP station), become more complex and require more computational power.  There is a constant growth of connected devices and by [&]

https://www.percona.com/blog/2021/01/13/running-kubernetes-on-the-edge/

The Percona team provided the community with some excellent content and several new releases in 2020. I wanted to highlight some of your favorites (based on popularity) if you missed them. First up is our most-read blog from last year, which ironically was published before 2020. Ananias Tsalouchidis’s blog on when you should use Aurora [&]

https://www.percona.com/blog/2021/01/13/percona-2020-recap-great-content-and-software-releases/

In this blog, we will review all the backup and restore strategies for MySQL, the cornerstones of any application. There are a few options, depending on your topology, MySQL versions, etc. And based on that, there are some questions we need to ask ourselves to make sure we make the right choices. How many backups [&]

https://www.percona.com/blog/2021/01/12/mysql-backup-and-recovery-best-practices/

Join us as Michael Coburn, Percona Product Manager, discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and Percona Monitoring and Management (PMM) Query Analytics. He will also highlight specific Dashboards in PMM that visualize the rate, errors, and duration of MySQL events that may be impacting the stability and [&]

https://www.percona.com/blog/2021/01/12/webinar-january-26-using-percona-monitoring-and-management-to-identify-and-troubleshoot-problematic-mysql-queries/

This week we officially kick-off the Preview of Database as a Service (DBaaS) in Percona Monitoring and Management. We are still looking for users to test and provide feedback during this year-long program, and we would love you to participate!    Our vision is to deliver a truly open source solution that won’t lock you [&]

https://www.percona.com/blog/2021/01/12/the-preview-of-database-as-a-service-dbaas-in-percona-monitoring-and-management-is-now-live/

This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements. Of the many new features and enhancements that have been made, some of the more notable ones include: Space savings and performance gains from de-duplication of [&]

https://www.percona.com/blog/2021/01/11/a-snippet-of-features-reviewing-postgresql-version-13/