by Matthew Boehm | Sep 27, 2022 | Insight for DBAs, MySQL
Geo locations are a cornerstone of modern applications. Whether you’re a food delivery business or a family photographer, knowing the closest “something” to you or your clients can be a great feature. In our ‘Scaling and Optimization’...
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 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 Edwin Wang | Sep 6, 2022 | Insight for DBAs, MySQL
We often see an int column of a table that needs to be changed to unsigned-int and then unsigned-bigint due to the value being out of range. Sometimes, there may even be blockers that prevent us from directly altering the table or applying pt-online-schema-change on...
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 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 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...
