Percona

AUGUST 1, 2023

This blog was originally published on August 10, 2020, and was updated on August 1, 2023. With an increasing number of databases in the cloud, the question is now not a matter of IF it will happen again, but when. As a result, typically, much more data is stored in MongoDB than in traditional SQL databases.

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). mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 72

Best Practices Traffic Database Servers 72

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 75

Database Best Practices Open Source C++ 75

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. Next is the table definition.

Best Practices 90

Best Practices Tuning Database Testing 90

Percona

JULY 19, 2023

In this blog post, we will explore how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD. 2023-07-07T10:11:22+03:00 pgv2.percona.com By leveraging automation and deployment best practices, teams can reduce the risk of human error, increase deployment velocity, and focus on delivering business value.

Servers 79

Servers Best Practices DevOps Open Source 79

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. This affects the type and range of characters that can be inserted into the column.

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. The size of the database and your database environment—if it is on colo or cloud—matters. As discussed in the introductory blog post , we highlight important aspects an enterprise should consider for its PostgreSQL environments.

Strategy 52

Strategy Database Storage Open Source 52

Official Blog - World Web Technology

NOVEMBER 27, 2023

It depends on the best practices of web design. To create a personal blog, you’ll need a drag-and-drop editor. It should have built-in auto-save and premade blogging themes. Top 5 Website Builders to Choose in 2023! It is written in PHP and uses a MySQL database for operations.

Website 59

Website Development Mobile Storage 59

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? Get started today with Percona Backup for MongoDB.

Storage 68

Storage Strategy Network Efficiency 68

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Check out this blog to learn how to avoid disaster!

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 84

Availability Open Source Architecture Database 84

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 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. What is a Trigger in MySQL?

Cache 61

Cache Database Games Healthcare 61

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