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. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 120

AWS Storage Database Open Source 120

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. citus_columnar | 11.1-1 1 citus | 11.1-1 1 = NODE: citus2 = extname | extversion -+ plpgsql | 1.0

C++ 79

C++ Database Storage Testing 79

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Database 96

Database Performance C++ Engineering 96

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 94

Games Database Open Source C++ 94

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. wt list -c WiredTigerCheckpoint.33: 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 88

Hardware C++ Storage Cache 88

Percona

JUNE 28, 2023

This blog post is a warning tale, an invitation to try yourself and break stuff (not in production, right?). C It fails, as it should. First error to notice: 2023-06-22T08:00:48.322148Z 0 [ERROR] [MY-000000] [Galera] It may not be safe to bootstrap the cluster from this node. C It fails? Why did it fail?

C++ 77

C++ Open Source Servers Monitoring 77

Adrian Cockcroft

FEBRUARY 9, 2023

Picture by Adrian — Ka’anapali sunset 2023 There’s been a lot of discussion about platforms recently, I talked about why I think it’s a current hot meme on the WTF Podcast with Charles Humble recently, and Sam Newman just wrote a blog post “ Don’t call it a platform ”.

Engineering 137

Engineering Serverless Lambda AWS 137

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

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 8, 2023

The main objective of this blog post is to point out the new administrative connections allowed on MySQL 8, as these connections can save us from restarting the instance in case this happens. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Type 'help;' or 'h' for help.

C++ 94

C++ Database Servers Open Source 94

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 76

Database Best Practices Open Source C++ 76

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 psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) And there could be conflicts. 20150623 (Red Hat 4.8.5-44),

Database 103

Database Servers Open Source Tuning 103

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

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. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. 1 Complete! openmetrics.d/conf.yaml

Monitoring 70

Monitoring Metrics Database Open Source 70

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 ). Here are some potential drawbacks of using it: Compared to MySQL, MariaDB has a smaller open source user and developer community.

Open Source 52

Open Source Servers Storage Scalability 52

Testsigma

APRIL 28, 2021

Below are few statistics that will give you an idea: Mobile applications are expected to generate over $935 billion in revenue by 2023 The Apple App Store has 1.96 million apps available for download on the Google Play Store 21% of Millennials open an app 50+ times per day. It is open-source, hence free to use.

Mobile 69

Mobile Testing Open Source Java 69

Percona

AUGUST 17, 2023

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 Node ( 127.0.0.1:3311

C++ 76

C++ Availability Processing Database 76

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. 3311", "receiverStatus": "ON", "receiverThreadState": "Waiting for source to send event", "source": "127.0.0.1:3308" MySQL 127.0.0.1:3308 3308": { "address": "127.0.0.1:3308", 3309": { "address": "127.0.0.1:3309",

Traffic 76

Traffic Database C++ Servers 76

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. In this blog, we will be discussing different MongoDB database backup strategies and their use cases, along with pros and cons and a few other useful tips. We will be discussing more about Percona Backup for MongoDB in an upcoming blog post.

Best Practices 52

Best Practices Database Storage Servers 52