Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake.

Database 86

Database Open Source Testing Servers 86

Official Blog - World Web Technology

JUNE 13, 2023

It is the most popular CMS that was earlier used to create personal blogs. However, dedicated WordPress theme developers have made the platform so advanced that businesses look up to WordPress when they want to develop a wide range of web applications such as ecommerce websites, business websites, personal blogs, web applications, etc.

Development 52

Development Website Ecommerce Code 52

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. Main features of pg_timetable Fully database-driven configuration Cron-style scheduling at the PostgreSQL server time zone Built-in tasks such as sending emails, etc. psql psql (12.16) Type "help" for help.

Open Source 77

Open Source Database Servers Programming 77

Percona

JUNE 26, 2023

To restore, we can follow either of below approaches: If the standby server is there and the issue does not persist on that, then we can fix the issue by taking logical backup from the standby server, dropping the table on primary, and recreating it using the backup taken. Download Percona Distribution for PostgreSQL Today!

Hardware 75

Hardware C++ Database Open Source 75

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 has many advantages, one of which is the “Sharding Technique” and this is what we are going to explore in this blog post. Let's download the deb.sh

Scalability 92

Scalability Database Open Source Systems 92

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. Why do you need multiple instances on the same server? 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. AFAIK Facebook does this.

Programming 84

Programming Servers Database Hardware 84

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

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

MAY 16, 2023

The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts. The idea behind using a connection control plugin is to configure a MySQL server so that the server will delay its response.

Servers 118

Servers Database Monitoring Testing 118

Dynatrace

JULY 24, 2023

In this blog, we will dive into the transformative power of answer-driven automation. Answer-driven DevOps automation goes beyond creating tickets and extends to executing workflows designed to extract ownership information and then route the ticket to the responsible teams. Download the free 2023 CIO Report. Download now!

DevOps 213

DevOps Traffic Efficiency Servers 213

Dynatrace

SEPTEMBER 8, 2023

In part 1 of this blog series , we explored the concept of business observability, its significance, and how real-time visibility aids in making informed decisions. SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. This is used for identification purposes.

Database 263

Database Artificial Intelligence Metrics Monitoring 263

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 75

Open Source Database Scalability Software 75

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

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 20150623 (Red Hat 4.8.5-44),

Database 102

Database Servers Open Source Tuning 102

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 140

Performance Latency Hardware Storage 140

Percona

JULY 19, 2023

In this blog post, we will explore how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD. I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Server Side sync Percona relies on OpenAPI v3.0 ArgoCD supports Server-Side apply.

Servers 78

Servers Best Practices DevOps Open Source 78

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 76

Database Traffic C++ Servers 76

Percona

APRIL 13, 2023

In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. Sometimes the server recycles old WAL segments before the backup can finish and cannot find the WAL segment from the primary. One of the common issues that can be encountered in PostgreSQL is replication lag.

Latency 81

Latency Tuning Open Source Network 81

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 94

Storage Database Media Open Source 94

Smashing Magazine

AUGUST 10, 2023

Measuring Running A Page Speed Test: Monitoring vs. Measuring Geoff Graham 2023-08-10T08:00:00+00:00 2023-08-10T12:35:05+00:00 This article is sponsored by DebugBear There is no shortage of ways to measure the speed of a webpage. Certain tools are designed for certain metrics with certain assumptions that produce certain results.

Speed 81

Speed Monitoring Testing Network 81

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. When the primary server fails, a standby server takes over as the new primary.

Availability 83

Availability Open Source Architecture Database 83

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). enables the development of server-side and networked applications and has become widely popular for building scalable and real-time web applications. for server-side development, it’s not limited to that role.

Development 52

Development Virtualization Open Source Architecture 52

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

ACM Sigarch

MAY 31, 2023

using Compute Express Link or CXL), organizing memory components for optimal performance, adapting system software traditionally designed for homogeneous memory systems, and developing memory abstractions and programming constructs for HCM management. Therefore, software-hardware co-design is an essential component.

Latency 52

Latency Hardware Cache Architecture 52

ACM Sigarch

JULY 17, 2023

We then discuss defects observed, the role of test and design to address this problem, and identify research opportunities. The Emergence of Defect Driven Faults A key focus of RAS design has been to cope with particle-induced transient faults (aka “soft errors”). AVF modeling was developed for such faults. core lock-stepping).

Energy 52

Energy Hardware Best Practices Architecture 52

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. Back-end servers. 2023, 2024: Frame Pointers in Fedora and Ubuntu! I should do a blog post just on SFrames.

Java 145

Java Cache Google Hardware 145

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 1, 2023

This blog was originally published on August 10, 2020, and was updated on August 1, 2023. Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. Percona Server for MongoDB has offered at rest encryption for the MongoDB Community Edition.

Best Practices 41

Best Practices Transportation Open Source Traffic 41

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). Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 71

Best Practices Traffic Database Servers 71

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 58

Scalability Best Practices Servers Database 58

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers.

Performance 52

Performance Latency Hardware Storage 52

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 ). MariaDB Server, on the other hand, is a fork of MySQL 5.5.

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

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. As such, index design must strike a balance between improved query speed and efficient data modification. As such, index design should consider the size of indexed columns and the potential benefits they offer. Check out this blog here !

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

JULY 3, 2023

However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. Further details will be explained in upcoming blogs. The exact point at which a table will benefit from partitioning depends on the application.

Storage 82

Storage Database Performance Open Source 82

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. Continuous archiving of WALs to a remote backup server that is redundant and avoids a single point of failure.

Strategy 52

Strategy Database Storage Open Source 52

Smashing Magazine

OCTOBER 16, 2023

Gatsby Headaches: Working With Media (Part 2) Gatsby Headaches: Working With Media (Part 2) Juan Diego Rodríguez 2023-10-16T13:00:00+00:00 2023-10-16T16:23:46+00:00 Gatsby is a true Jamstack framework. Solving Markdown Headaches In Gatsby In Gatsby, Markdown files are commonly used to programmatically create pages, such as blog posts.

Media 87

Media Website Availability Design 87