Percona

JULY 17, 2023

In this blog, we’ll examine the reasons why people would seek an alternative to MongoDB Enterprise, and we’ll identify some of the most popular NoSQL alternatives. First, some stage-setting for this blog article. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). It ranks No.

Open Source 77

Open Source Database Scalability Software 77

Percona

JUNE 29, 2023

When all data-bearing replica set members are available, and the index is created with default commitQuorum , below are the details from the Primary and the Secondary nodes. Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function members.forEach(function (d) {print(d.name) + " " + print(d.stateStr)}); 127.0.0.1:27017

Servers 82

Servers C++ Storage Best Practices 82

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. But often, we use additional services and solutions within our environment for backups, storage, networking, and more.

Metrics 175

Metrics Engineering Energy Tuning 175

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 102

Storage Open Source Database Efficiency 102

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

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

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 67

Open Source Database Storage Engineering 67

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 97

Storage Database Media Open Source 97

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

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. And I agree that in the modern age of cloud and huge flash storage, the vast majority of companies will never need to consider doing this in prod, but there is always a chance of its need. er tail: cannot open ‘/data/mysql/prod3306.er’

Programming 86

Programming Servers Database Hardware 86

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.

Open Source 79

Open Source Storage Performance Design 79

Percona

AUGUST 29, 2023

Among its many capabilities, a Citus cluster can: Create distributed tables that are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage, and I/O capacity. Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables.

C++ 81

C++ Database Storage Testing 81

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 140

Performance Latency Hardware Storage 140

Percona

JUNE 23, 2023

It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe! ibd.qp.xbcrypt 2023-04-21T00:27:14.875316-00:00 24 [Note] [MY-011825] [Xtrabackup] Compressing and encrypting. dbxxxx/tb1.ibd

Servers 82

Servers Processing Speed Open Source 82

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

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

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. In this blog post, we will explore the realm of backups and conduct a comparative analysis of three backup types: Full, incremental, and differential backups. Looking for a MongoDB backup solution? What is an incremental backup?

Storage 69

Storage Strategy Network Efficiency 69

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. In this blog, we will review all of the potential MySQL backup and restore strategies, the cornerstones of any application. Encryption Backups have sensitive data, so it’s highly recommended to encrypt, especially for offsite storage.

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. As discussed in the introductory blog post , we highlight important aspects an enterprise should consider for its PostgreSQL environments. WALs in PostgreSQL are similar to transaction log files in the InnoDB storage engine for MySQL.

Strategy 52

Strategy Database Storage Open Source 52

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 52

Performance Latency Hardware Storage 52

Percona

JULY 3, 2023

Further details will be explained in upcoming blogs.

Storage 84

Storage Database Performance Open Source 84

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. What are the two different types of MongoDB database backups?

Best Practices 52

Best Practices Database Storage Servers 52

Percona

APRIL 7, 2023

In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. If you want to learn more about it, Jay Janssen wrote a nice blog post ( innodb_buffer_pool_size – Is 80% of RAM the right amount? Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Tuning 137

Tuning Cache Servers Benchmarking 137

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS. Amazon Aurora is a relational, proprietary, closed-source database engine with all that that implies.

AWS 52

AWS Database Serverless Storage 52

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

Testsigma

JUNE 5, 2021

billion people are projected (by 2023) to keep this small device in their pockets and use it daily. There are two main reasons why people keep mobile browsers installed in their system even after storage issues. It can be done via open source or via commercial tools. appeared first on Testsigma Blog.

Mobile 52

Mobile Testing Website Testing Tools 52

Enprowess

JANUARY 12, 2022

To make it easier for you, in this blog, we will discuss the latest web development trends that will evolve in 2022. Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Image Source. Single Page Applications (SPAs).

Blockchain 59

Blockchain IoT Development Serverless 59

O'Reilly

JULY 25, 2023

So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation.

Programming 98

Programming Code Design Benchmarking 98