Percona

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. Does PostgreSQL Need TDE (Transparent Data Encryption)? It does not require encryption capabilities on the storage level to provide data security.

Database 124

Database Storage Government Open Source 124

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. It opens doors to support more exciting use-cases.

Storage 288

Storage Cache Metrics Database 288

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Storage Servers 184

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

Percona

AUGUST 30, 2023

These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. Any organization that uses personal and other sensitive data must have a firm, proven plan for business continuity in the event of a disaster or cyberattack.

Database 86

Database Hardware Open Source Strategy 86

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. Our Operators provide built-in backup and restore capabilities, but some users are still looking for old-fashioned ways, like storage-level snapshots (i.e., Both your storage and Container Storage Interface (CSI) must support snapshots. AWS EBS Snapshots).

Database 66

Database Storage Open Source AWS 66

Dynatrace

AUGUST 1, 2022

Kubernetes was initially designed with a strong focus on stateless workloads, meaning these workloads do not need to store any persistent data. Interestingly, our partner RedHat reported in 2021 that around 80% of deployed workloads are databases or data caches, storing data in persistent volume claims (PVCs).

Storage 177

Storage Database Network Metrics 177

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. In this blog post, we will explore two distinct and effective methods to calculate the percentage progress of the MySQL restore process. rw-r--r--. 1 root root 2.3G What is Pipe Viewer Utility?

Database 81

Database Monitoring C++ Speed 81

Percona

NOVEMBER 3, 2023

When it comes to Citus, successfully building out and scaling a PostgreSQL cluster across multiple nodes and even across data centers can feel, at times, to be an art form because there are so many ways of building it out.

Database 102

Database Benchmarking Latency C++ 102

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. More in the following sub-section.)

Availability 105

Availability Database Open Source Hardware 105

Percona

DECEMBER 19, 2023

PG_TDE (PostgreSQL Transparent Data Encryption) is an experimental transparent data encryption access method for PostgreSQL 16, available on GitHub as an extension for vanilla PostgreSQL. Today, we’d like to share more details about the extension, including information about its internal architecture.

Open Source 81

Open Source Storage Database C++ 81

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. Data Store. Reliability.

Serverless 269

Serverless AWS Lambda Storage 269

The Netflix TechBlog

OCTOBER 15, 2019

Part I: Overview Andreas Andreakis , Falguni Jhaveri , Ioannis Papapanagiotou , Mark Cho , Poorna Reddy , Tongliang Liu Overview It is a commonly observed pattern for applications to utilize multiple datastores where each is used to serve a specific need such as storing the canonical form of data (MySQL etc.), caching (Memcached etc.),

Transportation 192

Transportation Architecture Processing Storage 192

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. If you have not already gone through it, I encourage you to read it to understand data corruption. Introduction. B-tree index structure.

Database 116

Database Hardware Storage Performance 116

Percona

APRIL 20, 2023

Data-at-rest encryption is essential for compliance with regulations that require the protection of sensitive data. It is also critical for securing sensitive data and avoiding data breaches. PostgreSQL does not natively support Transparent Data Encryption (TDE). apiVersion: storage.k8s.io/v1

Storage 119

Storage AWS Cloud Database 119

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. In today’s data-driven world, losing critical data can be catastrophic for any organization. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

JULY 29, 2022

Log analytics is the process of viewing, interpreting, and querying log data so developers and IT teams can quickly detect and resolve application and system issues. At the same time, log analytics can present challenges as data volumes explode, particularly in traditional environments that lack end-to-end observability solutions.

Analytics 203

Analytics Storage Retail Monitoring 203

Percona

MARCH 21, 2023

In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). PRIVILEGE CHECKS USER is helpful in multi-source replication to carefully gather data from various sources.

Storage 85

Storage Open Source Database Engineering 85

Dynatrace

JULY 29, 2022

Log analytics is the process of viewing, interpreting, and querying log data so developers and IT teams can quickly detect and resolve application and system issues. At the same time, log analytics can present challenges as data volumes explode, particularly in traditional environments that lack end-to-end observability solutions.

Analytics 171

Analytics Storage Retail Monitoring 171

Percona

MARCH 1, 2023

In this blog post, we will see how running databases on Kubernetes with Percona Operators can reduce your cloud bill when compared to using AWS RDS. We will not consider data transfer or backup costs in this article. EBS gp2 storage is $0.10 Storage – $2,880 EKS control plane – $876 Total: $92,056.80

Cloud 130

Cloud Storage AWS Database 130

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 94

AWS Benchmarking Performance Traffic 94

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 has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. Note: ScaleGrid implements follower clusters using storage snapshots.

Analytics 185

Analytics Storage Database Systems 185

Percona

AUGUST 29, 2023

Among its many capabilities, a Citus cluster can: Create distributed tables that are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage, and I/O capacity. Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables.

C++ 79

C++ Database Storage Testing 79

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Storage reduction alone results in significant cost savings, and we can save more data in the same space. In this blog, we will discuss both data and network-level compression offered in MongoDB.

Storage 105

Storage Network Open Source Latency 105

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. In this blog post, we’ll guide you through understanding the PostgreSQL hostname, setting it up correctly, and utilizing it effectively in SQL queries. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections.

Database 130

Database Servers Storage Network 130

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 124

Performance Hardware Tuning Storage 124

Dynatrace

DECEMBER 18, 2023

This challenge has given rise to the discipline of observability engineering, which concentrates on the details of telemetry data to fine-tune observability use cases. To get a more granular look into telemetry data, many analysts rely on custom metrics using Prometheus. What is Prometheus?

Metrics 169

Metrics Engineering Energy Tuning 169

Percona

OCTOBER 13, 2023

A common practice among DBAs and developers is to copy table data and.frm files from the data dictionary. In the case of InnoDB tablespaces, this information is incorporated into the tablespace itself, creating a fusion of metadata and data primarily to enhance performance. In MySQL 8.0, ibd files), general tablespace files (.ibd

Storage 91

Storage Database Engineering Open Source 91

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Unfortunately, my excitement was short lived for a couple of reasons.

Azure 96

Azure Database Tuning Network 96

Percona

MARCH 7, 2023

The goal is to simplify the provisioning and management of database capacity. One approach is to separate compute and storage to allow for independent scaling. By separating storage and compute, Neon replaces the PostgreSQL storage layer with data nodes, and compute nodes are distributed across a cluster of nodes.

Serverless 107

Serverless Storage Open Source Architecture 107

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

Highly Scalable

MARCH 1, 2012

NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. Many techniques that are described below are perfectly applicable to this model.

Database 279

Database Ecommerce Efficiency Engineering 279

Dynatrace

OCTOBER 22, 2021

On the service details page, we have improved how the initial analysis timeframe is selected to make sure it always contains data. Use this function to get keys of user action and user session properties according to the property data type defined in the argument. Analyze log data – Log viewer. for improved resilience.

Metrics 202

Metrics Monitoring Storage Database 202