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 80

Open Source Storage Database C++ 80

Dynatrace

FEBRUARY 2, 2022

Security: Data is stored securely in the Dynatrace cloud (powered by Azure). Dynatrace captures all your data, including host and application metrics, basic-network metrics, real-user metrics, mobile metrics, cloud-infrastructure metrics, log metrics, and much more.

Azure 315

Azure Availability Hardware Innovation 315

The Netflix TechBlog

MAY 4, 2023

This blog series will examine the tools, techniques, and strategies we have utilized to achieve this goal. It can happen on an edge API system servicing customer devices, between the edge and mid-tier services, or from mid-tiers to data stores. We will examine these alternatives in the upcoming sections.

Traffic 339

Traffic Latency Tuning Systems 339

Dynatrace

JUNE 25, 2020

With Dynatrace actively managing business-critical applications, some of our globally distributed enterprise customers require Dynatrace Managed to continue operating even when an entire data center goes down. Near-zero RPO and RTO—monitoring continues seamlessly and without data loss in failover scenarios.

Availability 237

Availability Hardware Latency Traffic 237

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

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

Percona

MARCH 13, 2023

There is a section in our Documentation ( Introduction to Serverless PostgreSQL ) and a short overview of the primary components: Page Server The storage server with the primary goal of storing all data pages and WAL records Safe Keeper A component to store WAL records in memory (to reduce latency).

Serverless 117

Serverless C++ Storage Latency 117

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 84

Storage Open Source Database Engineering 84

Scalegrid

NOVEMBER 29, 2023

The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. Data Center Dynamics highlights a significant uptick in DBaaS adoption, growing from 40% to 45% between 2019 and 2020. Your data will always be intact.

Healthcare 130

Healthcare Hardware Database Scalability 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

OCTOBER 1, 2020

Applications and services are often slowed down by under-performing DNS communications or misconfigured DNS servers, which can result in frustrated customers uninstalling your application. Identify under-performing DNS servers. Slower response times can be a sign of a stressed DNS server or network communication issues.

Traffic 264

Traffic Network Infrastructure Artificial Intelligence 264

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

Percona

JANUARY 5, 2023

Space constraint has been an endless and painstaking process for many of us, especially in systems that have a high number of transactions and data growth exceeding hundreds of GBs in a matter of days. If we are using binlog_format as ROW, a huge number of bin logs would be created which could choke I/O of servers and require extra cleanup.

Traffic 59

Traffic Engineering Speed Storage 59

Scalegrid

NOVEMBER 23, 2023

In this blog post, we’ll guide you through understanding the PostgreSQL hostname, setting it up correctly, and utilizing it effectively in SQL queries. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

Dynatrace

FEBRUARY 14, 2022

Building on its advanced analytics capabilities for Prometheus data , Dynatrace now enables you to create extensions based on Prometheus metrics. Without any coding, these extensions make it easy to ingest data from these technologies and provide tailor-made analysis views and zero-config alerting. Customizable dashboard.

Technology 206

Technology Technology Metrics Infrastructure 206

SQL Performance

JULY 19, 2022

Each log record has a fixed overhead so, sometimes, the Storage Engine breaks this rule by combining multiple changes into a single log record to reduce the total number of log records written to the log. There are between 70 and 100 log record types, depending on the version of SQL Server (there’s no documented list).

Servers 94

Servers Database Storage Engineering 94

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. Red Hat recommends lower ratios of 10 and 3 for high-performance/large-memory servers. )

Best Practices 52

Best Practices Design Tuning Database 52

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe. Dynatrace news.

Internet 256

Internet Internet Games Java 256

Dynatrace

JULY 29, 2021

The complexity of such deployments has accelerated with the adoption of emerging, open-source technologies that generate telemetry data, which is exploding in terms of volume, speed, and cardinality. All this data is then consumed by Dynatrace Davis® AI for more precise answers, thereby driving AIOps for cloud-native environments.

Analytics 245

Analytics Open Source Serverless Architecture 245

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Without reliable backups, the consequences of data loss can be severe.

Best Practices 77

Best Practices Storage Strategy Database 77

Dynatrace

SEPTEMBER 29, 2021

It offers a flexible multidimensional data model that’s based on key-value pairs and a potent query language (PromQL). Prometheus components include client libraries for application code instrumentation, special-purpose exporters for popular services, and the optional Prometheus server for orchestrating service discovery and data storage.

Technology 199

Technology Technology Monitoring AWS 199

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

All Things Distributed

JANUARY 23, 2012

Expanding the Cloud - The AWS Storage Gateway. Today Amazon Web Services has launched the AWS Storage Gateway, making the power of secure and reliable cloud storage accessible from customersâ?? With the launch of the AWS Storage Gateway our customers can now integrate their on-premises IT environment with AWSâ??s

Storage 115

Storage AWS Virtualization Cloud 115

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 189

Infrastructure Monitoring Virtualization Serverless 189

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. This blog post lists the important database metrics to monitor. This is because it stores the data in main memory rather than on disk, making it quickly accessible for multiple Redis instances.

Metrics 130

Metrics Monitoring Latency Cache 130

The Netflix TechBlog

JUNE 13, 2023

Our previous blog post presented replay traffic testing — a crucial instrument in our toolkit that allows us to implement these transformations with precision and reliability. This blog post will delve into the techniques leveraged at Netflix to introduce these changes to production.

Traffic 279

Traffic Metrics Systems Strategy 279

Dynatrace

SEPTEMBER 8, 2023

In part 1 of this blog series , we explored the concept of business observability, its significance, and how real-time visibility aids in making informed decisions. Dynatrace users typically use extensions to pull technical monitoring data, such as device metrics, into Dynatrace. Don’t rename the file. Upload the ZIP file.

Database 259

Database Artificial Intelligence Metrics Monitoring 259

Scalegrid

JANUARY 20, 2020

Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. In this blog post, we will cover the top three scenarios to leverage follower clusters for your application. In this blog post, we will cover the top three scenarios to leverage follower clusters for your application.

Analytics 185

Analytics Storage Database Systems 185

Percona

OCTOBER 18, 2023

In this blog post, we will look into some of the most interesting features. release , we added support for physical backups and restores to significantly reduce Recovery Time Objective ( RTO ), especially for big data sets. Under the hood, we store logical oplogs along with physical backups into the object storage.

Best Practices 90

Best Practices Storage AWS Big Data 90

Scalegrid

NOVEMBER 12, 2019

In this blog post, we will detail some of these operational challenges with PostgreSQL. In order to work around this, administrators have to deploy a proxy layer on the server-side. In the case where a proxy is introduced in the data path, there is also a considerable performance impact. are used to handle this scenario.

Database 184

Database Open Source Storage Servers 184

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Configuration of the CPU metrics can be changed in the dashboard.

Cloud 116

Cloud Serverless AWS Storage 116

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. Make sure your website doesn’t go down with a server or datacenter crash by configuring a master-slave setup for high availability.

Database 166

Database Cloud Website Azure 166

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

Dynatrace

DECEMBER 15, 2022

In this blog, we share three log ingestion strategies from the field that demonstrate how building up efficient log collection can be environment-agnostic by using our generic log ingestion application programming interface (API). Typically, these are streamed to a central syslog server. What is Fluentd? What is Cribl?

Strategy 171

Strategy AWS Open Source Transportation 171

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. This counter value is stored in memory and is not persistent across server restarts. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 108

Servers Storage Database Open Source 108

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 102

Performance Monitoring Traffic Database 102

Scalegrid

JULY 8, 2019

The advantage of using a quorum is that it’s a lower cost alternative, but the downside is that you only have 2 data-bearing nodes as the other acts as a quorum node to determine the best failover course. Azure makes this easy to setup through the use of a Virtual Network (VNET) which can be configured for your MySQL servers.

Azure 219

Azure Cloud Virtualization Database 219