by Arunjith Aravindan | Sep 15, 2022 | Cloud, MySQL, Percona Software
This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as well as what is new in the setup compared to Percona XtraDB Cluster 5.7. What is Percona XtraDB Cluster an ideal fit for? Percona XtraDB...
by David Stokes | Sep 13, 2022 | Insight for DBAs, MySQL, PostgreSQL
First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found here. PostgreSQL has several popular index types including B-tree, Hash,...
by Peter Zaitsev | Sep 8, 2022 | Insight for DBAs, Monitoring, MySQL, Percona Software
In my previous blog post, ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database, I wrote about the ProcFS UDF MySQL plugin, which allows you to get operating systems stats, through the MySQL database, without having shell access...
by Kedar Vaijanapurkar | Sep 7, 2022 | Insight for DBAs, MySQL
A large table is a pain for many reasons as long as it is in a system. And as if that’s not enough, it is also a difficult task to get rid of it. In this post, we will understand why it is a pain to do this operation and what we can do about it. It will be like...
by Sergey Pronin | Sep 6, 2022 | Cloud, MongoDB, MySQL, Percona Software
Percona Monitoring and Management (PMM) comes with Database as a Service (DBaaS) functionality that allows you to deploy highly-available databases through a simple user interface and API. PMM DBaaS is sort of unique for various reasons: It is fully open source and...
by David Stokes | Sep 1, 2022 | Insight for DBAs, MySQL, Percona Software
You may have read MyRocks Use Case: Big Dataset and been intrigued enough to want to evaluate RocksDB with InnoDB. It has several advantages including requiring less storage space. So how do you start? On a fresh install of Percona Server for MySQL, install RocksDB...
by Peter Zaitsev | Sep 1, 2022 | Insight for DBAs, MySQL, Percona Software
When you look at database performance, it does not only depend on internal database operations but also on things going on in the operating system, network, storage system, hardware, etc. With that, if you’re building software to help analyze and optimize database...
by Yves Trudeau | Aug 30, 2022 | Insight for DBAs, MySQL
Recently I have been working with a few customers with multiple terabytes of transactional data on their MySQL clusters. These very large datasets are not really needed for their daily operations but they are very convenient because they allow them to query historical...
by David Stokes | Aug 29, 2022 | Insight for DBAs, MySQL, PostgreSQL
Those new to the realm of PostgreSQL from other databases will find little gems sprinkled liberally through the software. One of those gems is the watch command. It can be used to repeatedly run a query over and over again. Pretend you are watching the progress of...
by Arunjith Aravindan | Aug 29, 2022 | Insight for DBAs, MySQL, Percona Software
by Peter Zaitsev | Aug 25, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see...
by Sergey Pronin | Aug 22, 2022 | Cloud, MongoDB, MySQL, Percona Software
We at Percona are committed to delivering software that enables users to run databases anywhere. Our Operators for databases and Percona Monitoring and Management (PMM) Database as a Service (DBaaS) confirm our commitment to Kubernetes. Kubernetes is not only the most...
by David Stokes | Aug 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Thank you for the many kind responses to this series. There are many out there who have MySQL experience and are seeking to expand into PostgreSQL for reasons ranging from simple curiosity to fortifying their professional skills. Now that we have covered the...
by David Ducos | Aug 17, 2022 | Insight for DBAs, MySQL
The title is not entirely true, but ‘FTWRL on MyDumper is not needed anymore for consistent backups’ was a long title. One more time, I wanted to share a new feature in MyDumper. This is related to an important piece: the locking mechanism that mydumper uses to sync...
by Vadim Tkachenko | Aug 17, 2022 | Insight for DBAs, MySQL, Storage Engine
One of the questions I am often asked is in what cases I would prefer MyRocks over InnoDB. We have covered MyRocks in our blog previously: MyRocks Performance – Percona Database Performance Blog Saving With MyRocks in The Cloud – Percona Database...
by Evgeniy Patlan | Aug 11, 2022 | MySQL, Percona Software
Percona XtraDB Cluster (PXC) is a database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment. Lately, the number of questions about how to build Percona software has...
by Corrado Pandiani | Aug 11, 2022 | Insight for Developers, MySQL, Open Source, Percona Software
I have recently written an article for this blog presenting Window Functions for MongoDB 5.0. I used some public Italian COVID-19 data for a few real examples. Please have a look at it if you like. Then I thought I should provide the same even for a relational...
by Yura Sorokin | Aug 10, 2022 | Insight for DBAs, MySQL, Percona Software, Storage Engine
In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well. A word of...
by Vinicius Grippa | Aug 10, 2022 | Insight for DBAs, MySQL
This blog post will discuss the newest feature available in MySQL 8.0.30: dynamic redo log sizing. After the InnoDB buffer pool size, we can say that having a proper size for the redo logs is crucial for MySQL performance. There are numerous blog posts about how to...
by Chetan Shivashankar | Aug 3, 2022 | Cloud, MySQL, Percona Software
In part one and part two of this series, we introduced the different ways to manage MySQL configurations and precedence when using the Percona XtraDB Cluster (PXC) object and ConfigMap. In this post, we will see the precedence when secrets are used for MySQL...
