Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Consider alternative tools, systems, and services: Many cloud providers offer long-term storage, serverless options, or component options for specific needs, with vastly different pricing models.

Database 79

Database Serverless Tuning Cloud 79

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. year For ten instances, it will be $168,192 per year Default gp2 storage is $0.115 per GB-month, for 200 GB, it is $22.50/month EBS gp2 storage is $0.10 db.r5.4xlarge – $1.92/hour

Cloud 129

Cloud Storage AWS Database 129

Dynatrace

JULY 29, 2022

Log analytics can determine whether the same service or function is consistently causing an application to not meet SLOs during peak season — for example, when a retailer offers an end-of-season sale, or a financial application is critical for closing out the year. Traditional databases help users and machines find data with a quick search.

Analytics 214

Analytics Storage Retail DevOps 214

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. In terms of storage, internal pages are no different than the root page; they also store pointers to other internal pages. Introduction.

Database 116

Database Hardware Storage Programming 116

Percona

SEPTEMBER 1, 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. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

n0derunner

JUNE 28, 2019

In this example from prior post. Since the DB is small (50% the size of the Linux RAM) – the database is mostly cached on the read side – so we only see writes going to the DB files. Despite the database flushes ocurring in bursts with a decent amount of concurrency the Nutanix CVM give an average of 1.5ms write response.

Benchmarking 75

Benchmarking Storage Cache Database 75

n0derunner

DECEMBER 17, 2018

How to reduce database restore time by 50%. Here’s a real-world example of that improvement in practice. I am using X-Ray to simulate a 1TB data restore into an existing database. The post Nutanix AES: Performance By Example. Unfortunately I only have 10Gbit networking in my lab! appeared first on n0derunner.

Performance 64

Performance Benchmarking Storage Network 64

Dynatrace

JULY 29, 2022

Log analytics can determine whether the same service or function is consistently causing an application to not meet SLOs during peak season — for example, when a retailer offers an end-of-season sale, or a financial application is critical for closing out the year. Traditional databases help users and machines find data with a quick search.

Analytics 181

Analytics Storage Retail DevOps 181

Percona

APRIL 20, 2023

TDE is a database encryption technique that encrypts data at the column or table level, as opposed to full-disk encryption (FDE), which encrypts the entire database. To enable the encryption of the storage in Kubernetes, you need to modify the StorageClass resource. apiVersion: storage.k8s.io/v1

Storage 118

Storage AWS Cloud Database 118

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. With multiverse databases, each user sees a consistent “parallel universe” database containing only the data that user is allowed to see.

Database 90

Database Cache Benchmarking Efficiency 90

Percona

FEBRUARY 15, 2023

Bloom filters are an essential component of an LSM-based database engine like MyRocks. This post will illustrate through a simple example how bloom filters work in MyRocks. In the above example, if you add all the first names of the people at Percona you’ll end up with only “1” That would be obviously useless.

Storage 125

Storage Tuning Cache Engineering 125

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. ALTER EVENT SESSION [ ADS_Standard_Azure ] ON DATABASE. DROP EVENT sqlserver.

Azure 96

Azure Database Tuning Network 96

Dynatrace

DECEMBER 18, 2023

An essential observability engineering tool Prometheus is an open-source telemetry database service that records and stores custom software metrics and provides a standardized interface to pull (in Prometheus terms, “scrape”) data using HTTP requests. To set the stage, let’s have a quick recap of what Prometheus is and what it does.

Metrics 177

Metrics Engineering Energy Tuning 177

Scalegrid

JANUARY 9, 2024

Defining Enterprise Cloud Security In today’s business landscape, the reliance on cloud services for data storage and processing has made enterprise cloud security a crucial factor. They seamlessly integrate with popular databases including MongoDB, Redis, MySQL, and PostgreSQL while utilizing their respective built-in security frameworks.

Strategy 130

Strategy Cloud Best Practices Government 130

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. Understanding distributed storage is imperative as data volumes and the need for robust storage solutions rise.

Storage 130

Storage Systems Big Data Azure 130

The Netflix TechBlog

JUNE 12, 2023

Relatively few authorization plugins are broadly used within the Mac admin community, but one popular example is the Crypt agent. The agent also enables rotation of recovery keys after use, local storage and validation of recovery keys, and other features. We call this new tool Escrow Buddy.

Open Source 194

Open Source Database Servers Storage 194

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. 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

The Polyglot Developer

APRIL 6, 2017

When building a mobile application, there are often scenarios where you need to storage files remotely and when I say files, I don’t mean database data. For example, maybe you want to develop an image manager or photo storage solution like what Facebook and Instagram offer?

Storage 59

Storage Cloud Open Source Mobile 59

Dynatrace

FEBRUARY 2, 2023

For example, to monitor non-compute resources in Azure, many solutions require special components configured separately or even hosted by the customer. This includes Azure services such as App Services & Functions, Azure Databases, Azure Load Balancers, Azure Storage, and many more (see the complete list of services ).

Azure 224

Azure Cloud Monitoring Metrics 224

Percona

DECEMBER 28, 2023

You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on). Compress the audit log files to reduce the storage space occupied with log files. The plugin contains built-in functions for its own configuration.

Open Source 102

Open Source Database Servers Storage 102

Percona

OCTOBER 13, 2023

You should download and install the debug info package based on the MySQL version, for example, version 8.0.34. storage/innobase/./././mysql-8.0.34/storage/innobase/row/row0sel.cc': storage/innobase/row/row0sel.cc': 'SourceRequest' not supported. storage/innobase/./././mysql-8.0.34/": storage/innobase/./././mysql-8.0.34/":

Code 99

Code C++ Storage Programming 99

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. Let’s dive in and learn how (and what) to effectively monitor MySQL performance, along with examples from PMM, by understanding the critical KPIs to watch for.

Performance 103

Performance Monitoring Traffic Database 103

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. with MySQL 8, and provide practical examples to demonstrate the differences. With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7,

Servers 109

Servers Storage Database Open Source 109

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. Configuring storage in Kubernetes is more complex than using a file system on your host. The Kubernetes experience.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Dynatrace

AUGUST 9, 2023

As a result, not only can you understand, for example, that someone accessed a database, but also from where they came, exactly what they accessed, and to where they exported the data–to the level that we know the exact database query statement.

Analytics 218

Analytics Metrics Database Storage 218

n0derunner

DECEMBER 18, 2018

a 10TB database with 20% hot data) we observe a 2X improvement in throughput for random access across the 2TB hot dataset. This is true for all storage, so speeding up metadata resolution can make a dramatic improvement to overall throughput as we demonstrate. Nutanix AOS 5.10 ships with a feature called Autonomous Extent Store (AES).

Performance 40

Performance Cache Hardware Storage 40

Percona

AUGUST 7, 2023

Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of database systems. In this blog post, we will delve into the differences between the InnoDB undo log and redo log, exploring their significance and providing code examples to illustrate their usage.

Database 94

Database Tuning Storage Open Source 94

All Things Distributed

AUGUST 20, 2012

Managing Cold Storage with Amazon Glacier. With the introduction of Amazon Glacier , IT organizations now have a solution that removes the headaches of digital archiving and provides extremely low cost storage. Amazon Glacier integrates seamlessly with other AWS services such as Amazon S3 and the different AWS Database services.

Storage 122

Storage Cloud AWS Media 122

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

OCTOBER 7, 2020

Seamlessly report and be alerted on non-topology-related custom metrics, using Dynatrace as a metric database. Topology metrics are related to specific entities in your Smartscape topology (for example, the number of successful and failed batch jobs processed by a host). Topology and non-topology metrics—what’s the difference?

Metrics 245

Metrics Analytics Storage Monitoring 245

Percona

MAY 29, 2023

pgBackrest on the Main site streams backups and Write Ahead Logs (WALs) to the object storage. Once installed, configure the Custom Resource manifest so that pgBackrest starts using the Object Storage of your choice. In each cluster, there are the following components: Percona Operator PostgreSQL cluster pgBackrest pgBouncer 3.

Storage 118

Storage Cloud Network Traffic 118

Dynatrace

JUNE 7, 2023

Kubernetes also gives developers freedom of choice when selecting operating systems, container runtimes, storage engines, and other key elements for their Kubernetes environments. Without having to worry about underlying infrastructure concerns, such as storage, security, and lifecycle management, developers can focus on writing code.

Open Source 206

Open Source Social Media Infrastructure Operating System 206

Scalegrid

JANUARY 19, 2024

Data-bearing members face a higher risk of encountering issues caused by rollbacks, compared to others who utilize different storage methods. For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines.

Database 130

Database Network Servers Monitoring 130

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 97

Monitoring Scalability Cache Database 97

The Netflix TechBlog

OCTOBER 19, 2020

a Netflix member via Twitter This is an example of a question our on-call engineers need to answer to help resolve a member issue?—?which Our distributed tracing infrastructure is grouped into three sections: tracer library instrumentation, stream processing, and storage. Storage: don’t break the bank!

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Dynatrace

AUGUST 26, 2020

Say, for example, that you have some unused high memory instances (1 TB RAM / 128 vCPU cores or higher). Optimal metric storage management strategy. Dynatrace Managed metric storage management is reliable and delivers high performance. Support for high memory instances. Wasted resources simply aren’t an option.

Performance 150

Performance Hardware Java Storage 150

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1.

Open Source 86

Open Source Storage Database Big Data 86