by Daniel Guzmán Burgos | Sep 26, 2022 | Cloud, MySQL, Percona Software
The microservice architecture is not a new pattern but has become very popular lately for mainly two reasons: cloud computing and containers. That combo helped increase adoption by tackling the two main concerns on every infrastructure: Cost reduction and...
by Vadim Tkachenko | Sep 23, 2022 | Insight for DBAs, Insight for Developers, MySQL
When you develop an application you expect success, and often success comes with growth problems. These problems especially show themselves in the area of data storage, where being stateful is not as easy to scale as the stateless parts of the application. There are...
by Vadim Tkachenko | Sep 20, 2022 | Cloud, MySQL, Percona Software
We are looking to provide simplified ways to deploy Percona software in cloud environments, especially for more advanced scenarios like replication and multi-node cluster (in the case of Percona XtraDB Cluster). For this I propose trying out our new Terraform...
by Mike Benshoof | Sep 20, 2022 | Insight for DBAs, MySQL, Percona Software, Security
In a post written earlier this year – Percona Server for MySQL Encryption Options and Choices – I discussed some of the options around encryption in MySQL. Being such a complex topic, that post was meant to clarify and highlight various aspects of “encryption” at...
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...