Dynatrace

NOVEMBER 9, 2023

Kubernetes is a widely used open source system for container orchestration. However, they can also be used to monitor optimization processes effectively. By recognizing the insights provided, you can optimize processes and improve overall efficiency. What’s next?

Efficiency 270

Efficiency Monitoring Best Practices Open Source 270

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. PR-720 simplifies the build process for the Percona Toolkit. 2023-12-21T15:29:22 Creating triggers. 2023-12-21T15:29:22 Created triggers OK. 2023-12-21T15:29:22 Copying approximately 1 rows. Percona Toolkit 3.5.6

Operating System 97

Operating System Programming Open Source Testing 97

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. In this blog post, we’ll explore a technique to help your backup strategy: running pgBackRest’s expire and backup processes in parallel while utilizing custom lock-file paths. Percona and PostgreSQL work better together.

Database 95

Database Open Source Storage Servers 95

Adrian Cockcroft

JUNE 2, 2023

What I learned at GlueCon 2023 — Tipping Points and Generative AI The final slide of my GlueCon keynote featuring a sunset over a pool in Maui — picture by Adrian I’ve presented at GlueCon many times over the last decade or so. Final thoughts… this blog post took me a week to finish writing, and it’s already out of date.

Social Media 98

Social Media Innovation Open Source Entertainment 98

Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. Once you have installed MongoShake, you need to configure it for the migration process. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/

Database 87

Database Open Source Testing Servers 87

Percona

OCTOBER 20, 2023

This blog post is part two of a multi-post series about using the Citus extension with Percona Distribution for PostgreSQL. Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters.

Scalability 93

Scalability Database Open Source Systems 93

Percona

NOVEMBER 30, 2023

Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. This blog describes how to encrypt the pgBackRest repository. The repository is where pgBackRest stores backups and archives WAL segments.

Open Source 79

Open Source Database Processing Performance 79

Percona

OCTOBER 3, 2023

In this blog, we are going to highlight some of the main features, installation, and some use cases of pg_timetable. pg_timetable --dbname=postgres --clientname=worker001 --user=scheduler --password= ** 2023-09-09 11:59:20.929 [INFO] [sid:697146069] Starting new session. For reference, below is the catalog structure.

Open Source 78

Open Source Database Servers Programming 78

Percona

DECEMBER 14, 2023

In this blog post, we will look into the steps of transforming an existing PostgreSQL streaming replication node into a logical replication node. In the below log file, the LSN is 0/7000640. s, system: 0.01 s, elapsed: 1638.50 In the below log file, the LSN is 0/7000640. s, system: 0.01 s, elapsed: 1638.50 s, system: 0.01 s, elapsed: 1638.50

Servers 77

Servers Open Source Database Systems 77

Tech News Gather

APRIL 18, 2023

Choose open-source frameworks: Creating an app from the beginning is extremely expensive and time-consuming. So to reduce costs, build a mobile app using an open-source framework that already has some basic functionalities of an app. It results in increased ROI on development and reduces the time on app marketing.

Mobile 52

Mobile Small Business Open Source Entertainment 52

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 105

C++ Servers Storage Speed 105

Percona

DECEMBER 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool. This is available only for the log_error_verbosity=3.

Monitoring 88

Monitoring Code Open Source Cache 88

Dynatrace

FEBRUARY 23, 2022

DevSecOps teams can address this unsettling tradeoff by automating processes throughout the SDLC, centralizing application configuration with a shared set of tools, and using observability platforms to gain visibility into code-quality lapses, security gaps, and other software development issues.

Serverless 261

Serverless Infrastructure Innovation DevOps 261

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. which is scheduled for EOL by the end of October 2023. Open-sourcing of the data We believe in open source at Percona. 26-1, telemetry will be enabled by default.

Open Source 90

Open Source Database Operating System Programming 90

Dynatrace

MARCH 3, 2020

By 2023, over 500 million digital apps and services will be developed and deployed using cloud-native approaches. Read more details about PayPal in this blog who is an early practitioner for performance as a self-service. #2 Industry apps explosion. 2 New roles and responsibilities at Panera Bread . Try it today using Keptn .

Performance 239

Performance Education Innovation Software Architecture 239

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

Official Blog - World Web Technology

APRIL 12, 2023

Earlier, it was used to simply create online blogs, but WordPress has evolved since then. Also, WordPress development is simple like the blogs you used to create on it. When you click on Publish, you will see a webpage and not a blog. The post What Skills Are Required For WordPress Developer In 2023?

Development 52

Development Website Ecommerce Programming 52

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. er tail: cannot open ‘/data/mysql/prod3306.er’ err 2023-07-10T05:26:42.521994Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.19-10) er tail: cannot open ‘/data/mysql/prod3306.er’

Programming 84

Programming Servers Database Hardware 84

Percona

JUNE 23, 2023

In order to speed up the backup process along with the compression and encryption, we can use multiple threads. ibd.qp.xbcrypt 2023-04-21T00:27:14.875316-00:00 24 [Note] [MY-011825] [Xtrabackup] Compressing and encrypting. Percona XtraBackup supports both compression and encryption of the backups. dbxxxx/tb1.ibd

Servers 80

Servers Processing Speed Open Source 80

Percona

APRIL 17, 2023

reaches end of life in October 2023. As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7 As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7

Open Source 73

Open Source Servers Scalability Database 73

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. The blog post contains the following topics.

Engineering 89

Engineering Database Servers Analytics 89

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. This covers the infrastructure, processes, and the application stack, including tracing, profiling, and logs. What is Prometheus?

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. We plan to make regression tests part of the release process starting from the next version. They include more vulnerabilities than Open Source tools that we use, can find, and help us improve the quality of Go-based tools.

Open Source 101

Open Source Code Testing Systems 101

Percona

MARCH 3, 2023

And this is how this blog originates so that if you find yourself in the same situation, proceed similarly or at least consider some of the practices used to meet the objective. “Don’t worry, we’ll take a look at the issue, and accordingly, we’ll proceed to suggest an execution plan,” we replied.

Database 100

Database Testing Servers Open Source 100

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. One of the common issues that can be encountered in PostgreSQL is replication lag.

Latency 81

Latency Tuning Open Source Network 81

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Let’s discuss a few scenarios one by one.

Servers 82

Servers Azure AWS Cloud 82

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

Open Source 66

Open Source Database Storage Engineering 66

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. pg_partman creates and manages both time-based and serial-based table partition sets.

Storage 101

Storage Open Source Database Efficiency 101

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Journal It’s a process where every write operation gets written (appended) from Memory to a Journal file, AKA transaction log that exists on disk at a specific interval configured using “ journalCommitIntervalMs.”

Hardware 88

Hardware C++ Storage Cache 88

Percona

JULY 6, 2023

Bitmap Index Scan The planner chooses this index scan method when the query asks for a large enough amount of data that can leverage the benefits of the bulk read, like the sequential scan, but not that large that actually requires processing ALL the table.

Best Practices 90

Best Practices Tuning Database Testing 90

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 A change to such parameters requires the postmaster — the main process of the PostgreSQL — to restart. And there could be conflicts.

Database 103

Database Servers Open Source Tuning 103

Percona

AUGUST 29, 2023

In this blog post, we will explore the immense value of provisioning PostgreSQL clusters with Percona Operator by using bootstrap capabilities: Start the cluster with init SQL script Bootstrap the cluster from the existing cluster or backup Getting started You need to have the Percona Operator for PostgreSQL deployed.

Storage 95

Storage Database Media Open Source 95

Percona

JULY 19, 2023

In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications and reducing the risk of human error in the deployment process.

Servers 78

Servers Best Practices DevOps Open Source 78

Percona

NOVEMBER 2, 2023

This blog was originally published in Sept 2021 and was updated in November 2023. Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.

Database 70

Database Open Source Scalability Virtualization 70

Percona

DECEMBER 5, 2023

Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot , exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. 2023-11-08 05:31:06.030 UTC [108718] LOG: listening on IPv4 address "0.0.0.0", port 5433.

Database 77

Database Traffic C++ Servers 77

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 83

Availability Open Source Architecture Database 83

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52