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...
by Chetan Shivashankar | Aug 1, 2022 | Cloud, MySQL, Percona Software
In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator. Percona Distribution for MySQL...
by Sveta Smirnova | Jul 29, 2022 | Benchmarks, Insight for DBAs, MySQL, Percona Software
In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include: sysbench – https://github.com/akopytov/sysbench BMK-kit –...
by David Stokes | Jul 28, 2022 | Insight for DBAs, MySQL, PostgreSQL
Episode 8 in the PostgreSQL for MySQL DBAs series covers materialized views. MySQL has had views for many years and they are very useful, but it has never had materialized views. Those who use materialized views appreciate their utility and here we will cover how they...
by David Stokes | Jul 27, 2022 | Insight for DBAs, MySQL
MySQL 8.0 is now over four years old and Oracle released the latest quarterly offering today with MySQL 8.0.30, which comes with lots of bug fixes and some interesting additions. This is my take on the release notes for those who do not have the time to wade through...
