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.

Scalability 58

Scalability Best Practices Servers Database 58

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since October 2, 2023.

Servers 73

Servers Monitoring Open Source Scalability 73

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 40

Best Practices Transportation Open Source Traffic 40

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity.

Code 76

Code Best Practices Open Source C++ 76

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. In a sharded cluster, each shard acts as an independent database responsible for storing and managing specific data.

Best Practices 70

Best Practices Traffic Database Servers 70

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 122

Traffic Scalability Database Servers 122

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 73

Database Best Practices Open Source C++ 73

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 87

Best Practices Tuning Database Testing 87

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app. This is not a “new” technique by any means, but it is certainly a component of modern performance practices.

Cache 73

Cache Strategy Best Practices Design 73

Percona

JULY 19, 2023

2023-07-07T10:11:22+03:00 pgv2.percona.com Conclusion GitOps, combined with Kubernetes and the Percona Operator for PostgreSQL , provides a powerful toolset for rapidly deploying and managing complex database infrastructures. Even when ArgoCD detects the change, it marks it as out of sync. Fill in the form at percona.com/k8s.

Servers 77

Servers Best Practices DevOps Open Source 77

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 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Where a high availability design once worked well, it can no longer keep up with more complex requirements. The same changes made in the primary database are made in the replicas.

Availability 82

Availability Open Source Architecture Database 82

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. So, What is MySQL Partitioning? Want to ensure a successful MySQL 5.7

Strategy 40

Strategy Storage Database Best Practices 40

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. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster.

Strategy 52

Strategy Database Storage Open Source 52

Official Blog - World Web Technology

NOVEMBER 27, 2023

You may have to put off learning web development and design. You can make a great website without coding or advanced web design skills. Anyone can use a good website builder, even if they don’t know web design. It depends on the best practices of web design. Top 5 Website Builders to Choose in 2023!

Website 59

Website Development Mobile Storage 59

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 59

Cache Database Games Healthcare 59

O'Reilly

JULY 25, 2023

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. I liked how ChatGPT helped me work through the tradeoffs of these initial design decisions before diving head-first into coding.

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Although landing pages are a common practice in online marketing, we were trying to make the most of it.

Performance 74

Performance Cache Traffic Metrics 74