Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. Redis isn’t alone in utilizing sharding strategies — it’s a common concept found throughout database technologies to distribute workload efficiently.

Scalability 130

Scalability Efficiency Java Database 130

Percona

SEPTEMBER 1, 2023

The good news is that for someone familiar with MySQL, they have the basics of databases covered and can explore some of the treasures to be discovered in the new PostgreSQL environment. MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. Download Percona Distribution for PostgreSQL Today!

Open Source 104

Open Source Code Testing Database 104

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. So, given a table_id, how do you get the table schema/definition? Old design (until Percona XtraBackup 8.0.33-27):

Cache 86

Cache Benchmarking Servers Design 86

The Netflix TechBlog

JANUARY 25, 2023

Annotations Sometimes people describe annotations as tags but that is a limited definition. A data model in Marken can be described using schema — just like how we create schemas for database tables etc. The databases we pick should be able to scale horizontally. Besides applications we will have ML algorithm data stored.

Scalability 283

Scalability Latency Media Architecture 283

High Scalability

JULY 18, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 4, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 10, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! has hours of system design content. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 104

Database Servers Open Source Tuning 104

High Scalability

FEBRUARY 1, 2022

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

DECEMBER 9, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

AUGUST 24, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 61

Cache Database Games Healthcare 61

High Scalability

SEPTEMBER 29, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. MySQL, as well as other RDBMS, are designed to work respecting the model and cannot scale in any way by fragmenting and distributing a schema, so what can be done to scale?

Traffic 124

Traffic Scalability Database Servers 124

Percona

JULY 19, 2023

I have two: bundle.yaml – deploys Custom Resource Definitions, Service Account, and the Deployment of the Operator argo-test.yaml – deploys the PostgreSQL Custom Resource manifest that Operator will process There are some changes that you would need to make to ensure that ArgoCD works with Percona Operator.

Servers 79

Servers Best Practices DevOps Open Source 79

High Scalability

JULY 15, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 29, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 8, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Scalability 100

SQL Performance

JUNE 9, 2021

That is, ones that are created as an object in the database, and stay there permanently unless dropped. With the first article on views, I want to start light, focusing on what a view is, using correct terminology, and compare design considerations of views with those of the previously discussed derived tables and CTEs. What is a view?

Database 140

Database Code Design Development 140

High Scalability

MARCH 18, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

MARCH 18, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Scalability Infrastructure 100

The Morning Paper

SEPTEMBER 1, 2019

IPA: invariant-preserving applications for weakly consistent replicated databases Balegas et al., For bonus points, revisit your application design so that more parts of it can be coordination free. It’s definitely worth checking out the full paper here if this work interests you. VLDB’19. IPA for developers, happy days!

Database 42

Database Latency Games Design 42

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition.

Metrics 103

Metrics C++ Storage Database 103

High Scalability

MAY 18, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Scalability Infrastructure 100

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 76

Database Best Practices Open Source C++ 76

High Scalability

APRIL 7, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Scalability Infrastructure 100

O'Reilly

FEBRUARY 15, 2022

We can start with a simple operational definition: Reading comprehension is what is measured by a reading comprehension test. That definition may only be satisfactory to the people who design these tests and school administrators, but it’s also the basis for Deep Mind’s claim. That definition itself is ambiguous.

Artificial Intelligence 117

Artificial Intelligence Testing Engineering Programming 117

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects. pg_partman_bgw.dbname : Required.

Storage 101

Storage Open Source Database Efficiency 101

The Netflix TechBlog

SEPTEMBER 3, 2021

How can we achieve a similar functionality when designing our gRPC APIs? By default, gRPC uses protobuf as its IDL (interface definition language) and data serialization protocol. Our protobuf message definition (.proto The solution we use within the Netflix Studio Engineering is protobuf FieldMask.

Design 245

Design Java Efficiency Code 245

High Scalability

MARCH 18, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps AWS Scalability 100

Alex Podelko

SEPTEMBER 8, 2020

While Federico definitely has good points there, there is some truth in these myths too. The open source load testing tools definitely advanced a lot in both maturity and functionality – but there are many areas where they are behind best commercial tools (and if it matters for a specific user is another subject – for some it may not).

Open Source 223

Open Source Performance Testing Testing Performance 223

SQL Performance

JULY 14, 2021

Specifically, I started the coverage of logical aspects of views, and compared their design with that of derived tables and CTEs. The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. sql_modules.

Code 117

Code Database Servers Availability 117

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. And if the query processes 100 million rows, that’s definitely not trivial!

Database 93

Database Analytics Storage Processing 93

Dynatrace

SEPTEMBER 8, 2020

Moreover, chaos engineering experiments should be designed to reveal weaknesses in systems in a planned way with the aim to make systems more robust. Fortunately, chaos engineering is definitely not only useful in cloud native environments – it can also be used for monolithic services on virtual machines. Controlled Chaos.

Engineering 140

Engineering Cloud Monitoring Testing 140