As you may know, Percona Monitoring and Management (PMM) is based on Grafana, and all our frontend applications are either Grafana plugins or dashboards. Weve just released PMM version 2.10 and it includes a lot of improvements and new functionality. In this article, I would like to highlight some. They are quite important for users [&]

https://www.percona.com/blog/2020/09/16/grafana-7-arrives-with-percona-monitoring-and-management-2-10-0/

Google, Microsoft, and Apple have it. So do open source organizations like MongoDB, Red Hat, and SUSE. What do all these companies provide? A customer portal that enables anyone to create an identity with the company. To date, Percona hasn’t had a customer portal with a free user account   but that’s about to change. [&]

https://www.percona.com/blog/2020/09/16/percona-customer-portal-and-your-new-free-user-account/

There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples of such bugs for MySQL I have: Bug #15815  This is where InnoDB on an 8-CPU system performed worse than on a 4-CPU system with increased concurrency. Bug #29847  This is a similar [&]

https://www.percona.com/blog/2020/09/16/mongodb-4-4-performance-regression-overwhelmed-by-memory/

Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W Workload, and the recent release of Percona Server for MongoDB 4.4, I wanted to evaluate 4.2 vs 4.4 in similar scenarios. Hardware Specs For the client and server, I will use identical bare metal servers, connected [&]

https://www.percona.com/blog/2020/09/15/percona-server-for-mongodb-4-2-vs-4-4-in-python-tpcc-benchmark/

If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. [crayon-5f64865049410279473204/] What Does it Mean? It means that replication has tried [&]

https://www.percona.com/blog/2020/09/15/how-to-inject-an-empty-xa-transaction-in-mysql/

Today, we’re excited to announce the agenda for Percona Live ONLINE taking place on 20-21 October 2020. As the conference could not go ahead in person in Amsterdam as planned, we have once again moved to an online format that saw more than 6,500 people join us over 24 hours for our May conference. We’ll [&]

https://www.percona.com/blog/2020/09/15/announcing-the-agenda-for-percona-live-online-20-21-october-2020/

In this webinar, we will explore the Percona Kubernetes Operator for the Percona Server for MongoDB (PSMDB) database. Kubernetes is a widely-deployed orchestration platform for container management.  Recently, more and more companies are moving towards containerized platforms to increase availability while lowering operational costs and utilize existing infrastructure. Percona has recognized this, and many companies [&]

https://www.percona.com/blog/2020/09/15/webinar-september-29-learn-about-percona-kubernetes-operator-for-percona-server-for-mongodb/

We really enjoyed presenting Percona Server for MongoDBs data-at-rest encryption functionality. The webinar Percona Server for MongoDB Data-at-Rest Encryption was recorded and can be viewed here at any time. We had several great questions, which we would like to address with everyone and help further elaborate on the answers given during the webinar. Q: Where [&]

https://www.percona.com/blog/2020/09/14/q-a-on-webinar-percona-server-for-mongodb-data-at-rest-encryption/

MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many of [&]

https://www.percona.com/blog/2020/09/14/how-to-upgrade-to-mysql-8-0-free-course-at-percona-university-online/

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/14/improvements-to-percona-xtrabackup-updates-to-percona-distribution-for-postgresql-release-roundup-september-14-2020/

In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant [&]

https://www.percona.com/blog/2020/09/11/data-consistency-for-rds-for-mysql-the-8-0-version/

One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer activated, killing process altogether. Before adjusting memory usage, either by [&]

https://www.percona.com/blog/2020/09/11/how-much-memory-does-the-process-really-take-on-linux/

Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash,  GIN, GIST, and BRIN indexes. And because the development around indexes is still going on, PostgreSQL 13 provides some enhancements. [&]

https://www.percona.com/blog/2020/09/10/index-improvements-in-postgresql-13/

It is very common to see many customer cases where a sudden increase in disk space usage is caused by a lot of WAL segments filling up the WAL directory (pg_wal). Panicking customers generally ask Why isnt PostgreSQL deleting them?. The most common reasons we used to find were: Failing WAL archival A slot holding [&]

https://www.percona.com/blog/2020/09/09/why-postgresql-wal-archival-is-slow/

MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of running pt-table-checksum to verify data consistency between a primary [&]

https://www.percona.com/blog/2020/09/08/data-consistency-for-rds-for-mysql-pt-table-checksum-pt-query-digest/

Join Peter Zaitsev, Percona CEO, as he discusses DBaaS and Kubernetes. DBaaS is the fastest growing way to deploy databases. It is fast and convenient and it helps to reduce toil a lot, yet it is typically done using proprietary software and tightly coupled to the cloud vendor. We believe Kubernetes finally allows us to [&]

https://www.percona.com/blog/2020/09/08/webinar-september-22-the-path-to-open-source-dbaas-with-kubernetes/

Please watch Percona’s Senior Software Engineer Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization webinar. PostgreSQL is one of the leading open-source databases. 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 [&]

https://www.percona.com/blog/2020/09/03/webinar-september-17-postgresql-high-performance-tuning-and-optimization/

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/08/31/rocksdb-variables-in-percona-server-for-mysql-updates-to-percona-server-for-mongodb-release-roundup-august-31-2020/

At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter [&]

https://www.percona.com/blog/2020/08/31/percona-monthly-bug-report-august-2020/

We sometimes receive challenging requests& this is a story about one of those times. The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a simple implementation. However, as we had 200 shards we had to implement [&]

https://www.percona.com/blog/2020/08/28/proxysql-binary-search-solution-for-rules/