by Nickolay Ihalainen | Jan 27, 2021 | Benchmarks, MariaDB, MongoDB, MySQL, PostgreSQL
I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By… Docker (or Podman)...
by Jobin Augustine | Jan 22, 2021 | Benchmarks, Cloud, Insight for DBAs, PostgreSQL
The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, and we were curious to see how it performs with PostgreSQL. The general availability of ARM-based servers for testing and evaluation was a major obstacle....
by Carlos Tutte | Jan 21, 2021 | Insight for DBAs, Insight for Developers, MySQL
Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable you need to modify under most circumstances. But from time to time we get some performance tickets related to this. What...
by Robert Bernier | Jan 19, 2021 | Insight for DBAs, Percona Software, PostgreSQL
Enter pg_stat_monitor: this extension, created here at Percona, has been developed as an advanced replacement of pg_stat_statement, providing new capabilities in addition to the standard fare. As you may recall, PostgreSQL’s pg_stat_statements extension provides a...
by Sri Sakthivel | Jan 15, 2021 | Insight for DBAs, Insight for Developers, MySQL
The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and...
by Corrado Pandiani | Jan 14, 2021 | Insight for DBAs, MongoDB, Open Source, Percona Software
Are you thinking about deploying MongoDB? Is it the right choice for you? Choosing a database is an important step when designing an application. A wrong choice can have a negative impact on your organization in terms of development and maintenance. Also, the wrong...
by Robert Bernier | Jan 11, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements. Of the many new features and enhancements that have...
by Fernando Mattera | Jan 8, 2021 | Insight for DBAs, MySQL, Percona Software
Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility. What is the difference with many others existing on the web? Not many, but they are interesting in terms of performance and availability....
by Michael Patrick | Jan 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Open Source
It has been some time since I have posted updates to my plugins. After the initial version, I decided to split the plugins into categories of metrics. This will allow users to choose whether they want to install all of the plugins or only select ones they care...
by Brian Sumpter | Jan 7, 2021 | Database Trends, MySQL, Percona Services, Security
In previous TAM Enterprise Experiences posts, we have outlined typical aspects of utilizing MySQL in an Enterprise environment. One thing we have not yet covered is the topic of database encryption, both from the standpoint of business requirements as well as some of...
by Stephen Thorn | Jan 6, 2021 | Cloud, Insight for DBAs, MySQL, Webinars
Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options’ pros and cons. This webinar was recorded and can...
by Brian Sumpter | Jan 5, 2021 | Database Trends, Insight for DBAs, Open Source, Percona Services
One of the great things about being a Technical Account Manager (TAM, for short) at Percona is having the opportunity to see a wide variety of issues across many clients, and having the space to identify the common threads that seem to bind many of these issues. While...
by Lalit Choudhary | Jan 4, 2021 | Insight for DBAs, Insight for Developers, Percona Software
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...
by Marcelo Altmann | Dec 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
A lot of elements take part in a good backup strategy. Two of them are: Where to store your backups – Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended...
by Ivan Groenewold | Dec 21, 2020 | Cloud, Insight for DBAs, MySQL, Percona Services
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined...
by Brandon Fleisher | Dec 18, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
As strange as it sounds, there are types of software applications that are designed for users to NOT spend each minute of every day within the application (where the goal of so many software applications is to attract as many “eyeballs” for as long as possible to...
by Matt Yonkovit | Dec 17, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
Hello everyone! I wanted to outline a new program we are trying out. We are calling it, Percona Open Source Expert Missions. So, you might be asking… What the heck is that? An Expert Mission is a challenge or a contest of skill. Here at Percona, we are always looking...
by Sri Sakthivel | Dec 16, 2020 | Insight for DBAs, MySQL, Open Source
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be...
by Peter Zaitsev | Dec 15, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
If you’re building custom dashboards for Percona Monitoring and Management (PMM), chances are you would like to use Prometheus recording rules for better performance. In the nutshell, recording rules act somewhat as materialized views in relational databases,...
by Evgeniy Patlan | Dec 15, 2020 | Insight for DBAs, Open Source, Percona Software
How do you install an application? Nowadays a lot of companies want to use the latest technology and more and more of them are moving infrastructure to clouds. And in order to simplify maintenance, they are using Kubernetes. But still, the vast majority use the bare...
