by David Quilty | Jun 11, 2020 | MySQL, Percona Software, Webinars
In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to. Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML...
by Carlos Salguero | Jun 10, 2020 | Monitoring, MySQL, Percona Software
Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries. For example, suppose you want to have information about cached indexes...
by Rachel Pescador | Jun 9, 2020 | Database Trends, MySQL, Percona Services, Percona Software
Our latest Solution Brief uses our relationship with Patreon to detail the ways that Percona services work together to provide customers with a complete database infrastructure solution. Last year Patreon enlisted Percona’s help with their MySQL databases. Utilizing...
by David Quilty | Jun 9, 2020 | MongoDB, Percona Software, Webinars
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 *...
by David Quilty | Jun 8, 2020 | Percona Services, Percona Software
It’s 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...
by Vadim Tkachenko | Jun 8, 2020 | Cloud, MongoDB, Percona Software
Unless you are using Amazon Aurora or RDS, setting up clustering software still can be complicated and that’s why we want to offer options to simplify database cluster management in Amazon AWS. This time I will be looking at Percona Kubernetes Operators, for both...
by Sveta Smirnova | Jun 4, 2020 | MySQL, Percona Software, Webinars
First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide...
by Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug. Online query formatting...
by Roman Misyurin | Jun 2, 2020 | Insight for Developers, Monitoring, Open Source, Percona Software
The frontend part of Percona Monitoring and Management (PMM) is a set of extensions for Grafana, and the Grafana documentation provides a basic understanding of how things work. But after I studied it, it was still difficult to understand how to approach development...
by Barrett Chambers | May 28, 2020 | Insight for DBAs, MongoDB, Open Source, Percona Software
A Spotlight on the Security of Your MongoDB Database When Percona first published this blog in 2016, it was a refreshing comparison for important features of an enterprise-grade MongoDB deployment. But, comparing MongoDB Enterprise to Percona Server for MongoDB...
by Matthew Boehm | May 27, 2020 | MySQL, Percona Services, Percona Software
Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups....
by Akira Kurogane | May 27, 2020 | MongoDB, Percona Software
Percona Backup for MongoDB v1.2 is out! In a nutshell it offers (much) faster compression choices, backup cancellation, and assorted convenience features such as a universal backup deletion command and progress logging. And, for the DBAs out there in the field,...
by Matt Yonkovit | May 26, 2020 | Database Trends, MongoDB, Open Source, Percona Software
Billy Duberstein’s article, If You Invested $1000 in MongoDB’s IPO, This Is How Much Money You’d Have Now, illustrated how much money you would have made if you had invested in the MongoDB IPO — over five times what you bought in at! Although that’s...
by David Quilty | May 26, 2020 | Percona Services, Percona Software
It’s 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...
by Stephen Thorn | May 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Database backups are a fundamental requirement in almost every implementation, no matter the size of the company or the nature of the application. Taking a backup should be a simple task that can be automated to ensure it’s done consistently and on schedule....
by Rick Golba | May 19, 2020 | MongoDB, Percona Software
Percona is pleased to announce the release of Percona Distribution for MongoDB. This release combines two existing Percona products, Percona Server for MongoDB and Percona Backup for MongoDB, into one simple to install package. The distribution is an open-source...
by Rick Golba | May 19, 2020 | Percona Software, PostgreSQL
Percona is pleased to announce the release of an updated version of Percona Distribution for PostgreSQL. Following on our initial PostgreSQL Distribution, released in September 2019, this update incorporates the new features of PostgreSQL 12.2 Core Distribution...
by Roma Novikov | May 19, 2020 | Insight for DBAs, Monitoring, Percona Software
As we have just released the new Security Threat Tool (STT) as part of Percona Monitoring and Management (PMM) 2.6, I wanted to give you a basic overview of this new feature. Its goal is to advise PMM users on common security-related database problems they might have...
by Terri Schlosser | May 19, 2020 | Monitoring, Percona Software
If database security is a top concern and you are looking for ways to quickly find and remediate common data security risks, you should try the newly announced Percona Monitoring and Management 2.6. This includes a new Security Threat Tool which allows you to run...
by Marco Tusa | May 18, 2020 | MySQL, Percona Software
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what. In PXC there are two different kinds of traffic: client-server exchange (ie:...
