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

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.

Open Source 52

Open Source Servers Storage Scalability 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

Percona

SEPTEMBER 25, 2023

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. This issue tends to occur when your backup storage is located offsite, your database is quite large, and the backup process generates a lot of files.

Database 95

Database Open Source Storage Servers 95

Percona

SEPTEMBER 14, 2023

I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. In this blog post, I will show you how to replicate MySQL data in real-time to ClickHouse. The blog post contains the following topics. I am going to use the MaterializedMySQL engine for this purpose.

Engineering 88

Engineering Database Servers Analytics 88

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

SEPTEMBER 27, 2023

CURRENT_TIMESTAMP /(CURRENT_TIMESTAMP + ‘1 hour’::interval)::text) p_automatic_maintenance text The parameter determines whether maintenance is automatically managed when run_maintenance() is called without a table parameter or by a background worker process.

Storage 101

Storage Open Source Database Efficiency 101

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! In order to speed up the backup process along with the compression and encryption, we can use multiple threads.

Servers 81

Servers Processing Speed Open Source 81

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. 10-Linux.x86_64.ssl101.tar.gz ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 85

Programming Servers Database Hardware 85

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 68

Storage Strategy Network Efficiency 68

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

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 79

Best Practices Storage Strategy Database 79

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. In this blog, we will specifically discuss one of the important features of the pgBackRest called Multiple Repository (or, in short, Multi Repo). Let’s discuss a few scenarios one by one.

Servers 83

Servers Azure AWS Cloud 83

Percona

MARCH 21, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Schematically it looks like this: I will show the practical work with tenants/timelines in the following blog post, so subscribe for all updates. Join us at this event if you are interested! Interested in serverless PostgreSQL?

Serverless 124

Serverless Software Architecture Virtualization Database 124

Official Blog - World Web Technology

NOVEMBER 27, 2023

To create a personal blog, you’ll need a drag-and-drop editor. It should have built-in auto-save and premade blogging themes. Choice and Range of Themes Using the premade templates a website builder provides is the first step in the design process. A drag-and-drop interface, as previously noted, simplifies the process.

Website 59

Website Development Mobile Storage 59

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. In today’s blog, I’ll take a look at MySQL collation and charset settings to shed light on how they impact the performance of web applications and how to use them to effectively communicate with your users.

Performance 52

Performance Storage Social Media Database 52

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. In setting up our demonstration system, we use pg_basebackup and continuous archiving.

Strategy 52

Strategy Database Storage Open Source 52

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

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. What are the differences between Aurora and RDS? How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. They are a roadmap that speeds up the process of finding specific rows in a large table. The process of crafting indexes involves a trade-off between improved data retrieval speed and impact on data modification operations.

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40

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? In PostgreSQL, it is called shared buffers. dissecting it a few years ago.

Tuning 136

Tuning Cache Servers Benchmarking 136

Percona

JULY 7, 2023

This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. Backup and continuous archiving: PostgreSQL asynchronous replication relies on the write-ahead log (WAL) stream, and it’s vital to have centralized storage that all nodes can access.

Availability 84

Availability Open Source Architecture Database 84

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). You can now proceed with the sharding process in MongoDB.

Best Practices 72

Best Practices Traffic Database Servers 72

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. Create your own test cases using natural language processing techniques in simple English. In a world with a 7.5

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. Convenient Debugging : Debugging process is easy for the developers as single page application SPA offer developers tools. List of Top Web Development Trends to Track in 2022. 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

Testsigma

FEBRUARY 12, 2021

The implementation of emerging technologies has helped improve the process of software development, testing, design and deployment. With all of these processes in place, cost optimization is also a high concern for organizations worldwide. Many changes are rendered through automated testing. Hyperautomation. The most recent 2021 trend.

Artificial Intelligence 92

Artificial Intelligence Software Software IoT 92