by Nickolay Ihalainen | Dec 20, 2023 | Cloud, Percona Software, PostgreSQL
Huge pages make PostgreSQL faster; can we implement it in Kubernetes? Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make... by Nickolay Ihalainen | May 24, 2022 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
While it is convenient to view the log of MySQL or MongoDB pods with kubectl logs, sometimes the log is purged when the pod is deleted, which makes searching historical logs a bit difficult. Grafana Loki, an aggregation logging tool from Grafana, can be installed in... by Nickolay Ihalainen | Jan 27, 2021 | Benchmarks, MariaDB, MongoDB, MySQL, PostgreSQL
I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By… Docker (or Podman)... by Nickolay Ihalainen | Apr 12, 2019 | PostgreSQL
When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using... by Nickolay Ihalainen | Apr 9, 2019 | Insight for DBAs, PostgreSQL
Native streaming replication in PostgreSQL works only between servers running the same major version. We discussed about logical replication in our previous blog post. In that post, we saw how logical replication could help us set up migration between two different... by Nickolay Ihalainen | Apr 4, 2019 | PostgreSQL
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a... by Nickolay Ihalainen | Mar 27, 2019 | PostgreSQL
In this blog post, we will explore pg_dump / pg_restore, one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which pg_dump and pg_restore utilities will be helpful.This post is the second... by Nickolay Ihalainen | Mar 18, 2019 | PostgreSQL
There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for... by Nickolay Ihalainen | Mar 4, 2019 | PostgreSQL
A date for your diary. On Wednesday, April 17 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4) Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen, will... by Nickolay Ihalainen | Feb 21, 2019 | Insight for DBAs, PostgreSQL
Modern CPU models have a huge number of cores. For many years, applications have been sending queries in parallel to databases. Where there are reporting queries that deal with many table rows, the ability for a query to use multiple CPUs helps us with a faster... by Nickolay Ihalainen | Nov 30, 2018 | Insight for DBAs, PostgreSQL
PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive... by Nickolay Ihalainen | Oct 30, 2018 | Insight for DBAs, PostgreSQL
PostgreSQL lightweight locks, or LWLocks, control memory access. PostgreSQL uses multi-process architecture and should allow only consistent reads and writes to shared memory structures. LWLocks have two levels of locking: shared and exclusive. It’s also... by Nickolay Ihalainen | Oct 24, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL locking visibility for application developers and DBAs is in most cases related to heavyweight locks. Complex database locking operations require full instrumentation using views from the system catalog. It should be clear which object is locked by a... by Nickolay Ihalainen | Oct 16, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
An understanding of PostgreSQL locking is important to build scalable applications and avoid downtime. Modern computers and servers have many CPU cores and it’s possible to execute multiple queries in parallel. Databases containing many consistent structures... by Nickolay Ihalainen | Apr 30, 2018 | Insight for DBAs, MySQL, Security
This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup.Almost every web application has a sensitive data: passwords, SNN, credit cards, emails, etc. Splitting the database to secure and “public”... by Nickolay Ihalainen | Feb 22, 2018 | Hardware and Storage, Insight for DBAs, Monitoring, MySQL
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense.Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with Percona... by Nickolay Ihalainen | Feb 9, 2018 | Monitoring, Percona Software, PostgreSQL
In this article, we’ll describe how to collect PostgreSQL metrics with Percona Monitoring and Management (PMM).We designed Percona Monitoring and Management (PMM) to be the best tool for MySQL and MongoDB performance investigation. At the same time,... by Nickolay Ihalainen | Sep 11, 2013 | Insight for DBAs, MySQL
This post focuses on the problem of the InnoDB log sequence number being in the future. Preface: What is an InnoDB log sequence number? The log sequence number (LSN) is an important database parameter used by InnoDB in many places. The most important use is for...