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

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs).

Cloud 77

Cloud Open Source Strategy Best Practices 77

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. This file is located at /etc/ssl on your MongoDB server.

Servers 130

Servers Best Practices Government Network 130

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables. Suppose you have SELECT * queries in your application code. Let’s see how it works.

Best Practices 76

Best Practices Open Source Code Engineering 76

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

Dynatrace

MAY 17, 2023

We’ll also cover how to instrument the services using OpenTelemetry, and some best practices for how to define spans and traces manually. By *instrumenting* a system (for example, an application), you enhance its capabilities to be able to send the desired telemetry data. heapUsed); }); What to trace?

Transportation 192

Transportation Metrics Best Practices Code 192

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. As well, very few cases are in need to have a full system/solution to provide scalability with sharding. The POC Why this POC?

Traffic 121

Traffic Scalability Database Servers 121

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 57

Scalability Best Practices Servers Database 57

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on colo or cloud—matters. Why are PostgreSQL Backups Necessary?

Strategy 52

Strategy Database Storage Open Source 52

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 82

Availability Open Source Architecture Database 82

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. In addition, they are used for restoring or moving data to a new system.

Storage 67

Storage Strategy Network Efficiency 67

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

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

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. It also reports on mobile usability, security, and best practices such as HTTPS.

Performance 74

Performance Cache Traffic Metrics 74

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. Swift Papers felt like a well-scoped project to test how well AI handles a realistic yet manageable real-world programming task.

Programming 98

Programming Code Design Benchmarking 98