Hello everyone, in this little post we will review a new feature in MySQL 8. What is CHECK Constraint? This is a new feature to specify a condition to check the value before INSERT or UPDATE into a row. The constraint could return an error if the result of a search condition is FALSE for [&]

https://www.percona.com/blog/2020/10/02/how-to-use-check-constraint-in-mysql-8/

MariaDB 10.5 was released in June 2020 and it will be supported until June 2025. This is the current stable version and comes with more exciting new features. In this blog, I am going to explain the new and exciting features involved in MariaDB 10.5.  Amazon S3 engine Column Store INET 6 data type Binaries [&]

https://www.percona.com/blog/2020/10/02/exciting-and-new-features-in-mariadb-10-5/

Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. Its also lately one of the most popular conversations around the community. But what is it? In plain words: holding up queries for a while, giving air [&]

https://www.percona.com/blog/2020/10/02/rate-limit-throttle-for-mysql-with-proxysql/

Network volumes in Kubernetes provide great flexibility, but still, nothing beats local volumes from direct-attached storage in the sense of database performance. I want to explore ways to deploy both Percona Kubernetes Operators (Percona Kubernetes Operator for Percona XtraDB Cluster and Percona Kubernetes Operator for Percona Server for MongoDB) using local volumes, both on the [&]

https://www.percona.com/blog/2020/10/01/deploying-percona-kubernetes-operators-with-openebs-local-storage/

There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb force. Dropdb force A new command-line option is added to dropdb command, and [&]

https://www.percona.com/blog/2020/10/01/postgresql-13-new-feature-dropdb-force/

This webinar will be delivered in Italian. MongoDB is the most used document-oriented database but some of the more requested features are available only in the Enterprise version. Percona Server for MongoDB (PSMDB) is an alternative to MongoDB with its open source, solid, and 100% compatible server. In this webinar, in Italian, you will learn [&]

https://www.percona.com/blog/2020/10/01/webinar-october-12-percona-server-for-mongodb-a-solid-and-compatible-alternative-to-mongodb/

PostgreSQL 13 is released with some cool features, such as index enhancement, partition enhancements, and many others. Along with these enhancements, there are some security-related enhancements that require some explanation. There are two major ones: one is related to libpq and the other is related to postgres_fdw. As it is known that postgres_fdw  is considered [&]

https://www.percona.com/blog/2020/09/30/postgresql_fdw-authentication-changes-in-postgresql-13/

In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and this can be split in two main ways: vertical [&]

https://www.percona.com/blog/2020/09/30/mysql-101-tuning-mysql-after-upgrading-memory/

With version 2.9.1 of Percona Monitoring and Management (PMM) we delivered some new improvements to its Security Threat Tool (STT). Aside from an updated user interface, you now have the ability to run STT checks manually at any time, instead of waiting for the normal 24 hours check cycle. This can be useful if, for [&]

https://www.percona.com/blog/2020/09/29/using-security-threat-tool-and-alertmanager-in-percona-monitoring-and-management/

So youve installed postgres onto your machine, and you want to start working with it. How? The key to understanding the post-installation procedure is to realize that it depends. It depends on the OS i.e. MSWindows vs Linux. It depends on the flavor of Linux i.e. Debian vs RedHat. It depends if its a package [&]

https://www.percona.com/blog/2020/09/29/postgresql-configuration-changes-you-need-to-make-post-installation/

https://www.percona.com/blog/2020/09/28/3-features-i-love-in-percona-monitoring-and-management-2-10/

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/09/28/new-features-in-percona-monitoring-and-management-2-10-updated-percona-distribution-for-mongodb-release-roundup-september-28-2020/

We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. MySQL server has gone away is one of them. Most of the cases when the error occurs are described in MySQL documentation, but [&]

https://www.percona.com/blog/2020/09/25/diagnosing-and-fixing-mysql-server-has-gone-away-messages/

Database-as-a-service (DBaaS) can be thought of as a platform that can be used to manage an organization’s database environment(s). One of the most well known DBaaS platforms is Aurora powered by AWS. In this webinar, Ananias Tsalouchidis, Senior MySQL DBA at Percona,  will discuss how Percona can convert your DBaaS to a fully-managed solution ensuring [&]

https://www.percona.com/blog/2020/09/24/webinar-october-14-percona-aws-sciencelogic-converting-dbaas-to-a-fully-managed-solution/

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases, along with Load Balancing tools like ProxySQL. It is also ‘cloud ready’, meaning it has support for monitoring DBaaS (Amazon RDS, Aurora, and more). You can run PMM in your own environment for maximum security and [&]

https://www.percona.com/blog/2020/09/23/5-cool-features-in-percona-monitoring-and-management-you-should-try/

Join Peter Zaitsev, Percona CEO, as he discusses eBPFTrace and DTrace on Linux. While eBPF was included in Linux kernel for quite a few years, it lacked a good “front end” to complete Dtrace functionality in the Linux ecosystem. In this presentation, Peter will look into eBPFTrace as a capable Dtrace replacement. He will also [&]

https://www.percona.com/blog/2020/09/23/webinar-october-7-ebpftrace-dtrace-replacement-on-linux/

With Percona Monitoring and Management (PMM) 2.10.0, Percona is releasing a new MongoDB exporter for Prometheus. It is a complete rewrite from scratch with a totally new approach to collect and expose metrics from MongoDB diagnostic commands. The MongoDB exporter in the 0.11.x branch exposes only a static list of handpicked metrics with custom names [&]

https://www.percona.com/blog/2020/09/22/new-mongodb-exporter-released-with-percona-monitoring-and-management-2-10-0/

I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The [crayon-5f6e0f0b18ded966641366-i/] role restricts a monitoring user from accessing user data but only grants access to statistic views [&]

https://www.percona.com/blog/2020/09/22/using-security-definer-to-monitor-postgresql-9-6-or-earlier-using-percona-monitoring-and-management/

As with any database platform, MongoDB security is of paramount importance to keeping your data safe.  MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database.  So how do you keep you and your company’s data from being compromised and from [&]

https://www.percona.com/blog/2020/09/21/mongodb-101-5-configuration-options-that-impact-security-and-how-to-set-them/

In this blog, we will be discussing different backup strategies for MongoDB and their use cases, along with the pros and cons of each. Why Take Backups? Regular database backups are a crucial step in guarding against unintended data loss events. It doesn’t matter if you lose your data because of mechanical failure, a natural [&]

https://www.percona.com/blog/2020/09/18/mongodb-backup-best-practices/