Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. I created a test account (replica set) and loaded sample data with one click in Atlas: Create an account in Atlas. Atlas atlas-mhnnqy-shard-0 [primary] test> show dbs sample_airbnb 52.69 Create a cluster. MiB admin 336.00

Database 89

Database Open Source Testing Servers 89

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 94

Scalability Database Open Source Systems 94

Percona

JUNE 26, 2023

If we have a table-level logical backup, then we can restore the “test” table backup, and our database will be in good shape. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together.

Hardware 77

Hardware C++ Database Open Source 77

Dynatrace

MARCH 3, 2020

By 2023, over 500 million digital apps and services will be developed and deployed using cloud-native approaches. One way to apply improvements is transforming the way application performance engineering and testing is done. Read more details about PayPal in this blog who is an early practitioner for performance as a self-service. #2

Performance 239

Performance Education Innovation Software Architecture 239

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 80

Open Source Database Servers Programming 80

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.

Database 97

Database Open Source Storage Servers 97

Percona

DECEMBER 12, 2023

This blog gives you some ideas on using pt-table-sync for replica tables with triggers. In my lab, we have two test nodes with replication setup, and both servers will have Debian 11 and Percona Server for MySQL 8.0.33 (with Percona Toolkit) installed. Let’s fill in some test data We do an insert as a root user.

Servers 93

Servers Database Testing Open Source 93

Tech News Gather

APRIL 18, 2023

An MVP will allow you to: Collect valuable feedback from early users Approve your idea with actual users Analyse audience needs and demands Pitch investors for funding to develop a fully functional business app It’s best to start with an app with 2-3 important features and test the app in the market before investing more money to make a mobile app.

Mobile 52

Mobile Small Business Open Source Entertainment 52

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. Examples I believe real-case examples are best if you wish to test something similar, so here they are.

AWS 122

AWS Storage Database Open Source 122

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. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together.

Servers 79

Servers Open Source Database Systems 79

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. The following is a sample PMM dashboard that shows the multiple buffer pool resize operations during my tests. This is available only for the log_error_verbosity=3.

Monitoring 90

Monitoring Code Open Source Cache 90

Percona

NOVEMBER 30, 2023

This blog describes how to encrypt the pgBackRest repository. HINT: backup.info cannot be opened and is required to perform a backup. Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. HINT: has a stanza-create been performed?

Open Source 81

Open Source Database Processing Performance 81

Dynatrace

FEBRUARY 23, 2022

According to a Gartner report, “By 2023, 60% of organizations will use infrastructure automation tools as part of their DevOps toolchains, improving application deployment efficiency by 25%.”. Enshrining infrastructure in code provides a foundation for automation and testing—both of which are crucial for DevSecOps.

Serverless 261

Serverless Infrastructure Innovation DevOps 261

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++ 107

C++ Servers Storage Speed 107

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. Quality improvements Perl tools in Percona Toolkit come with a regression test suite that uses its own module that fires up MySQL sandbox ( lib / Sandbox. pm ) and extended Perl module Test :: More ( lib / PerconaTest.

Open Source 102

Open Source Code Testing Systems 102

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 102

Database Testing Servers Open Source 102

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0

Open Source 67

Open Source Database Storage Engineering 67

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 90

Engineering Database Servers Analytics 90

Percona

MARCH 27, 2023

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

Games 96

Games Database Open Source C++ 96

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. Backup testing. er tail: cannot open ‘/data/mysql/prod3306.er’

Programming 86

Programming Servers Database Hardware 86

Percona

JULY 6, 2023

then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice.

Best Practices 92

Best Practices Tuning Database Testing 92

Testsigma

APRIL 28, 2021

Selenium is a tremendously popular automated testing tool for desktop, web applications. Testing on mobile devices is a major requirement that has grown exponentially in recent years. Why has the mobile testing requirement grown so much? Thus, mobile application testing will play a crucial part here. Test Management.

Mobile 69

Mobile Testing Open Source Java 69

Percona

AUGUST 29, 2023

There are two parts to this POC; Part A: Setup Part B: Redundancy demonstration Part A: POC setup Step one: Getting and installing Citus Referring to this earlier blog , you’ll see how to get and install Citus into your environment.

C++ 81

C++ Database Storage Testing 81

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 83

Latency Tuning Open Source Network 83

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 84

Servers Azure AWS Cloud 84

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. I will provide a more detailed usage of pg_partman in upcoming blog posts.

Storage 102

Storage Open Source Database Efficiency 102

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Mar 15 19:02:59 ps promtail[2318]: level=info ts=2023-03-15T19:02:59.437567482Z caller=filetargetmanager.go:352

Monitoring 87

Monitoring Servers Metrics Database 87

Percona

JUNE 7, 2023

In this blog post, we will explore using triggers on DDL events in PostgreSQL to implement custom logic and automate database management tasks. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together.

Database 77

Database Best Practices Open Source C++ 77

Percona

DECEMBER 19, 2023

In this blog post, we will talk about the steps to configure alerts for some well-known communication platforms like Telegram , Slack , and WebHook. TOKEN: xoxb-5840606778679-6229228252662-teofbDQUiFCnrp3cZT08epyL ## Bot Api Token Recipient: test ###channel name On successful testing we should see some test alerts.

Monitoring 92

Monitoring Database Open Source Java 92

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 Here is an example of the function definition to test the function-level settings. And there could be conflicts. 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place?

Hardware 90

Hardware C++ Storage Cache 90

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 71

Database Open Source Scalability Virtualization 71

Percona

DECEMBER 1, 2023

The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community. Please read the previous blog post for the installation of pg_partman before continuing with this blog. For more details on pg_partman and its latest updates, check out [link].

Open Source 79

Open Source Storage Performance Design 79

Percona

JULY 19, 2023

In this blog post, we will explore how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD. sync-wave: "5" name: argo-test The bigger the number in wave, the later the resource will be created. 2023-07-07T10:11:22+03:00 pgv2.percona.com sync-wave: "1" name: perconapgclusters.pgv2.percona.com Interested?

Servers 80

Servers Best Practices DevOps Open Source 80

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. Interested?

Storage 97

Storage Database Media Open Source 97

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 85

Availability Open Source Architecture Database 85

Percona

APRIL 17, 2023

In this blog post, I’ll show you a simple example of collecting all rich data about databases using PMM and a way to send some of it to Datadog for general dashboards with main metrics to monitor. So the federated URL for exposing “*_up” metrics will be [link] I can test in on my PMM while being logged into it.

Monitoring 72

Monitoring Metrics Database Open Source 72