We invite you to join members of the Percona Solution Engineering Team as they walk through the task of migrating a MongoDB database to Percona Server for MongoDB (PSMDB). By the end of this hands-on workshop you should feel comfortable with: Uninstalling MongoDB Installing Percona Server for MongoDB Converting a stand-alone MongoDB server to Percona [&]

https://www.percona.com/blog/2020/11/05/webinar-november-19-converting-mongodb-to-percona-server-for-mongodb/

Kata containers are containers that use hardware virtualization technologies for workload isolation almost without performance penalties. Top use cases are untrusted workloads and tenant isolation (for example in a shared Kubernetes cluster). This blog post describes how to run Percona Kubernetes Operator for Percona XtraDB Cluster (PXC Operator) using Kata containers. Prepare Your Kubernetes Cluster Setting [&]

https://www.percona.com/blog/2020/11/04/running-percona-kubernetes-operator-for-percona-xtradb-cluster-with-kata-containers/

In this year’s Open Source Data Management Software survey, we asked organizations “What issues have you experienced in the last 12 months?” The main issue, flagged by three-quarters of respondents, was performance. Given the adverse impact that data slowdown has on business performance – especially during high traffic events – effectively managing them is essential [&]

https://www.percona.com/blog/2020/11/03/fixing-data-slowdowns-without-breaking-the-bank/

So youve just added some more memory to your MySQL server; now what? If youve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Lets have a look at a few parameters you would want to adjust. InnoDB Parameters innodb_buffer_pool_size The [&]

https://www.percona.com/blog/2020/11/03/adjusting-mysql-8-0-memory-parameters/

There are many potential benefits to moving to the cloud such as increasing resources on the fly, multi-region infrastructure, and hardware maintenance, to mention only a few. On the other hand, there are critical points such as security (the latest was MEOW attack), vendor lock-in, and performance issues such as latency and downtime that is [&]

https://www.percona.com/blog/2020/11/03/webinar-november-17-moving-mongodb-to-the-cloud-strategies-and-points-to-consider/

Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL history, understanding memory usage details was hard and included a lot [&]

https://www.percona.com/blog/2020/11/02/understanding-mysql-memory-usage-with-performance-schema/

Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been working with the vendor since early September on this issue and has made releases available to address the problem. Applicability A malicious party with access to the WSREP service port (4567/TCP) as well as prerequisite [&]

https://www.percona.com/blog/2020/10/30/cve-2020-15180-affects-percona-xtradb-cluster/

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/10/30/percona-monthly-bug-report-october-2020/

At our recent Percona Live ONLINE we announced the release of the 2020 Open Source Data Management Software Survey results.  This year, we wanted to build upon the data we collected in 2019 and continue to monitor the open source industry’s pulse. The 2020 survey was perhaps reflective of the wider world environment, as companies [&]

https://www.percona.com/blog/2020/10/29/2020-percona-survey-results-reveal-the-latest-open-source-database-trends/

In a perfect world, we expect all software to run flawlessly and never have problems such as bugs and crashes. We also know that this perfect world doesnt exist and we better be as prepared as possible to troubleshoot those types of situations. Historically, generating core dumps has been a task delegated to the kernel. [&]

https://www.percona.com/blog/2020/10/28/say-hello-to-libcoredumper-a-new-way-to-generate-core-dumps-and-other-improvements/

This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not persistent and are reset upon restart. These variables can be changed at [&]

https://www.percona.com/blog/2020/10/27/using-mysql-8-persisted-system-variables/

If you often deploy services in the cloud, you certainly, at least once, forgot to stop a test instance. I am like you and I forgot my share of these. Another mistake I do once in a while is to provision a bigger instance than needed, just in case, and forget to downsize it. While [&]

https://www.percona.com/blog/2020/10/27/a-first-glance-at-amazon-aurora-serverless-rds/

MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, you can configure your async replica to choose the new source in case the existing source connection (IO thread) fails. In this blog, I am going to explain the entire process involved in this configuration [&]

https://www.percona.com/blog/2020/10/26/mysql-8-0-22-asynchronous-replication-automatic-connection-io-thread-failover/

Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more welcoming for community members to contribute to our documentation. Percona Monitoring and Management (PMM) is a free, open-source database monitoring tool. It ‘mind-melds’ with your MySQL, MongoDB, or PostgreSQL servers and tells you what’s going [&]

https://www.percona.com/blog/2020/10/26/community-contributors-invited-to-update-percona-monitoring-and-management-documentation/

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/26/percona-distribution-for-postgresql-13-updates-to-percona-distribution-for-mysql-release-roundup-october-26-2020/

Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0: MySQL 5.7.32 While our QA team was performing an extensive test on it,  we found out this version introduced a new compression [&]

https://www.percona.com/blog/2020/10/23/mysql-new-releases-and-percona-xtrabackup-incompatibilities/

CVE-2020-26542 When using the SimpleLDAP authentication in conjunction with Microsoft’s Active Directory, Percona has discovered a flaw that would allow authentication to complete when passing a blank value for the account password, leading to access against the service integrated with which Active Directory is deployed at the level granted to the authenticating account. Applicability Percona [&]

https://www.percona.com/blog/2020/10/23/cve-2020-26542-simpleldap-authentication-percona-server-percona-server-mongodb/

One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This feature also brings Kubernetes deployments close to cloud providers, which [&]

https://www.percona.com/blog/2020/10/22/using-volume-snapshot-clone-in-kubernetes/

Google Cloud Platform (GCP), with its CloudSQL offering, has become a leading platform for database-as-a-service workload deployments for many organizations. Scale and High Availability have surfaced as primary goals for many of these deployments. Unfortunately, the attainment of these objectives has been challenging. Often, the answer has been to simply add more CloudSQL databases. Many, [&]

https://www.percona.com/blog/2020/10/22/webinar-november-10-google-cloud-platform-mysql-at-scale-with-reliable-ha/

About the Author  This blog was written as a collaboration with my colleague Jiri Ctvrtka.  Jiri is a senior software developer from Brno, Czech Republic, and has been partnering with Percona for almost a year working on various components of our Percona Platform. He’s been programming in Go since 2015 and Jiri’s got a [&]

https://www.percona.com/blog/2020/10/22/annotations-provide-context-to-timelines-in-percona-monitoring-and-management/