Peter Zaitsev has decided to step down from the role of CEO at Percona and take on the Founder role. Ann Schlemmer takes over as Percona CEO. | Continue reading
For those new to PostgreSQL, the SELECT DISTINCT statement eliminates duplicate rows from the result by matching specified expressions. | Continue reading
We are currently working on making Percona XtraBackup compatible with Oracle's changes. Until then users are advised to not upgrade the MySQL server to 8.0.29. | Continue reading
Gaining additional insights and understanding your PostgreSQL workload is critical, and pg_stat_monitor can help you do both. | Continue reading
Bottom-up deletion is done during an index operation when a “version churn page split” is anticipated. Obsolete versions of logically unchanged index tuples are removed making space on the page for the newer version. | Continue reading
How and why Linux HugePages are important for PostgreSQL database servers. | Continue reading
This post is a technical dive into the internals of the MySQL multi-threaded replication implementation and its impacts on performance | Continue reading
Most people are aware of the problems with jumbo chunks; now we have seen how empty chunks in MongoDB can also be problematic in certain scenarios. | Continue reading
The pg_stat_monitor extension for PostgreSQL provides much-needed query performance insights in a single view. | Continue reading
In this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. The customer had noticed a linear high CPU usage in one of … | Continue reading
Support for MySQL 8 dual passwords can reduce overall DBA workload and streamline management processes, making it possible to perform user credential changes even with a large number of servers. | Continue reading
Record and Replay lets us record the execution of a MySQL program, allowing it to be replayed over and over to produce the same result. | Continue reading
Reviews of consumer SSDs are not reliable when it comes to assessing a disk's suitability for database use. Percona CEO Peter Zaitsev explains how the use of fsync for database transaction commits can impact IO performance of SSD drives. | Continue reading
Percona's Peter Zaitsev writes about why SSPL is bad for you and bad for the open source community. | Continue reading
With the second gen of Graviton2 instances announced, we decided to take a look at the price/performance from the standpoint of running PostgreSQL. | Continue reading
Are you thinking about deploying MongoDB? Is it the right choice for you? | Continue reading
Percona experts can optimize your database for high traffic events with open source database support, highly-rated training, managed services, and professional services. | Continue reading
At MayaData we like new tech. Tech that makes our databases perform better. Tech like lockless ring buffers, NVMe-oF, and Kubernetes. In this blog post we’re going to see those technologies at work to give us awesome block storage performance with flexibility and simple operation … | Continue reading
ChaosMesh, which I use to test Percona Kubernetes Operators, seeks to deploy chaos engineering experiments in Kubernetes deployments which allows it to test how deployment is resilient against different kinds of failures. | Continue reading
Peter Zaitsev share some of his considerations for designing Grafana Dashboards which will allow you to create better dashboards. | Continue reading
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights. | Continue reading
Covering multi-master replication solutions for PostgreSQL including BDR, xDB, PostgreSQL XL, Bucardo, and more. | Continue reading
Even though most posts warn people against the use of UUIDs, they are still very popular. Here I summarize what has been written and bring in new ideas. | Continue reading
There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark. | Continue reading
Grafana has a convenient extension mechanism - plugins that any front-end developer familiar with React or AngularJS can develop with minimal preparation. | Continue reading
PostgreQL security tips to protect your data, improve performance and system stability, and enhance the development life-cycle. | Continue reading
Since the release of Percona Server MongoDB 3.6.13, you have been able to use Vault to store the encryption keys for data at rest encryption. Here's how to set it up. | Continue reading
Basic and useful queries for PostgreSQL index maintenance and how to use the catalog tables to write the queries. | Continue reading
Percona has years of experience with fully remote teams, and Chief Experience Officer Matt Yonkovit has some tips for you if you're starting to work remote. | Continue reading
In databases (like PostgreSQL), NULL has some different concepts, so be careful when writing queries involving NULL. Here's what you need to know. | Continue reading
In this three part blog series, we discuss an overview of Vitess on Kubernetes for MySQL | Continue reading
Each cloud provider may have specific terms but security is broken into two components: security “of” the cloud and security “in” the cloud. | Continue reading
As DBMS engines have the Global Index, PostgreSQL should not lack this feature. | Continue reading
This blog post discusses how to configure HAProxy with PostgreSQL using pgsql-check, as well as the advantages and disadvantages of doing so. | Continue reading
EXT4 Disk Performance Issues are Slowing Down Databases on the Latest Linux Releases. | Continue reading
In this post, we discuss how to implement a PostgreSQL application connection failover using HAProxy with xinetd, one of the most traditional approaches. | Continue reading
Percona CEO Peter Zaitsev reviews MySQL Workbench, a free GUI for MySQL to run queries and provide basic help with administration. | Continue reading
Percona's Avinash Vallarapu talks about seamless application failover using libpq features in PostgreSQL, and how even with some slowness it still helps. | Continue reading
Percona's Avinash Vallarapu talks about how to set up streaming replication in PostgreSQL 12, as well as Percona Distribution for PostgreSQL. | Continue reading
@media (max-width: 768px) { .sm-hide { display: none!important; } .mobile-nomargin { margin-top: 3px!important; } } .hbspt-form .hs-form-field input[type="email"] | Continue reading
Percona is excited to announce the beta release of Percona Distribution for PostgreSQL 11 on August 19, 2019. | Continue reading
Discussing how simple/lightweight and faster a trigger function written in C for PostgreSQL is as compared to PlpgSQL. | Continue reading
An interesting project called plpgsql_check can be used similarly to plprofiler while also looking at code and pointing out compilation errors. | Continue reading
PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for paralle… | Continue reading
In my previous blog post, we have seen how the extension hypopg can be helpful in creating hypothetical indexes in PostgreSQL. If you have read it already, you know that it is very useful in verify… | Continue reading
In my previous blog post, we have seen how the extension hypopg can be helpful in creating hypothetical indexes in PostgreSQL. If you have read it already, you know that it is very useful in verify… | Continue reading
BRIN Index was introduced in PostgreSQL 9.5, but many users postponed the usage of it in their design and development just because it was “new”. But now we understand that it has stood the test-of-… | Continue reading