The latest 1.7.0 release of Percona Kubernetes Operator for Percona Server for MongoDB came out just recently and enables users to: Run multiple shards to scale MongoDB horizontally Deploy custom sidecar containers to extend operators and MongoDB capabilities in Kubernetes Automatically clean up Persistent Volume Claims (PVC) once a database cluster is removed Today we [&]
Lately, the number of questions about how to build Percona software has been increased. More and more people try to add their own patches, add some modifications, and build software by themselves. But this raises the question of how to do this in the same way as Percona does, as sometimes the compiler flag can [&]
Some time ago we at Percona were approached by ScaleFlux Inc to benchmark their latest hardware appliance, the CSD 2000 Drive, which is a next-generation SSD computational storage drive. It goes without saying that a truly relevant report requires us to be as honest and as forthright as possible. In other words, my mission was [&]
In November of 2020, we announced that in early 2021 Percona was slated to release a version of Percona Monitoring and Management (PMM) v2 that would include all of the critical functionality users of PMM v1 have come to know and love over the years. In our initial blog, we also addressed some of the [&]
Its release roundup time again 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 [&]
Yes, this post is about connection queueing, not just pooling. Because connection pooling pre-created connections as a pool is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of establishing a new connection to PostgreSQL& and how pre-created connections in the pool can save the world. But there is [&]
Join Rick Vasquez, Percona Technical Expert, as he discusses the pros and cons of moving your database to the cloud. Flexibility, performance, and cost management are three things that make cloud database environments an easy choice for many businesses. If you are thinking of moving your database to the cloud you need to know the [&]
MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “\show” and “\watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground and background threads as well. Overview “\show” and “\watch” are the [&]
Here 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 [&]
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, [&]
Great news! Percona’s Community-focused podcast, hosted by none other than the HOSS (Head of Open Source Software) himself (yeah, that is me), is now available on almost all podcast platforms. What? You didnt know we had a podcast? We do, and weve had some great episodes since we started in January. In fact, we just [&]
I have talked extensively about the DBAs evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers). Often, databases get blamed as the bottleneck for application slowdowns and issues, so DBAs have had to develop the skills needed to chase problems up and down [&]
MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes for this version. Following Perconas Release Lifecycle policies, the Percona Server for MySQL 5.6 series has reached End of Life (EOL) as well, and we will no longer provide public builds for bugs and security [&]
Понедельник, 15 Февраля 2021 г. 21:29
+ в цитатник
For MongoDB data directories only XFS is recommended. The ext4 filesystem isnt so bad but when there are a very, very high number of random accesses (which WiredTiger can reach) it can hit a bottleneck. To be fair most deployments will never hit this bottleneck, but it does remain an official production recommendation of MongoDB [&]
Понедельник, 15 Февраля 2021 г. 18:09
+ в цитатник
Its release roundup time again 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 [&]
Понедельник, 15 Февраля 2021 г. 16:40
+ в цитатник
MongoDB is one of the most admired and effortless NoSQL databases to set up. Developers want to spend time building the features for their application, and with MongoDB, developers can build the application quickly while utilizing well-supported infrastructure and high availability with automatic failover. In this blog post, we will discuss the top five things [&]
More and more companies are adopting Kubernetes, but after some time they see an unexpected growth around cloud costs. Engineering teams did their part in setting up auto-scalers, but the cloud bill is still growing. Today we are going to see how Percona Monitoring and Management (PMM) can help with monitoring Kubernetes and reducing the [&]
One piece of feedback I often hear from users of Percona Monitoring and Management (PMM) is that while the Query Analytics feature is great and provides a lot of insights into queries the server handled, it can’t help us to see which queries are running now. Problem Statement Real-time access to queries that are running [&]