Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. ibd2sdi data/test/t1.ibd ibd > t1.sdi

Cache 87

Cache Benchmarking Servers Design 87

SQL Server According to Bob

NOVEMBER 8, 2016

Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Block storage is what you think of today as disk access.

Cache 40

Cache Servers Media Storage 40

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). What is MariaDB? In addition, MariaDB provides optimal scalability options, making it ideal for growing workloads.

Open Source 52

Open Source Servers Storage Scalability 52

All Things Distributed

AUGUST 22, 2011

Today AWS has launched Amazon ElastiCache , a new service that makes it easy to add distributed in-memory caching to any application. Amazon ElastiCache handles the complexity of creating, scaling and managing an in-memory cache to free up brainpower for more differentiating activities. blog comments powered by Disqus.

Cloud 117

Cloud Cache AWS Storage 117

The Netflix TechBlog

OCTOBER 15, 2019

caching (Memcached etc.), Thus, ensuring the atomicity of writes across different storage technologies remains a challenging problem for applications [3]. No need to acquire locks on tables, which is essential to ensure that the write traffic on the database is never blocked by our service.

Transportation 192

Transportation Architecture Processing Storage 192

Dynatrace

OCTOBER 15, 2021

The data is incredibly plentiful and difficult to store over long periods due to capacity limitations — a reason why private and public cloud storage services have been a boon to DevOps teams. This occurs once data is safely stored within a local cache. Monitoring begins here. Ready to get started? Start a Dynatrace free trial!

Open Source 216

Open Source Metrics Cloud Transportation 216

Dynatrace

SEPTEMBER 17, 2019

PostgreSQL & Elastic for data storage. REDIS for caching. Robert allowed me to take a couple of screenshots from their Dynatrace environment and with that, in this blog I try to explain how Dynatrace gives them MaaSS for Developers, Operators, DevOps as well as Business. NGINX as an API Gateway. 3 Log Analytics.

AWS 127

AWS Monitoring Ecommerce Lambda 127

Percona

MAY 6, 2024

Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some of the configuration parts, mainly discussing how to dynamically change certain settings and persist those inside the configuration file.Disk persistenceLet me start with a very important setting, which is “SAVE,” that helps in performing (..)

Performance 94

Performance Cache Hardware Storage 94

All Things Distributed

AUGUST 17, 2011

As some of you may remember I was pretty excited when Amazon Simple Storage Service (S3) released its website feature such that I could serve this weblog completely from S3. But I really want a setup that allows me to thinker with the blog where ever I am (e.g. at 30,000 feet). Jekyll also is a static website generator.

Servers 126

Servers Social Media AWS Website 126

Smashing Magazine

SEPTEMBER 20, 2021

Web scraping can be used to harvest marketing data, such as identifying good keywords for advertising campaigns, identifying trending topics for blog posts, or identifying influencers in important blogs and news sites. Search Engine And Web Archive Cached Results. Turning The Data Into Information. Large preview ).

Website 89

Website Analytics Google Cache 89

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. To know more about dead tuples and bloat, please read our previous blog post. autovacuum_vacuum_scale_factor = 0.2

Tuning 45

Tuning Cache Database Storage 45

All Things Distributed

DECEMBER 5, 2010

There are two main types of DNS servers: authoritative servers and caching resolvers. But the real robustness of the DNS system comes through the way lookups are handled, which is what caching resolvers do. Caching techniques ensure that the DNS system doesnt get overloaded with queries. blog comments powered by Disqus.

Cloud 117

Cloud Internet Internet AWS 117

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

SQL Server According to Bob

AUGUST 8, 2016

I was asked about these terms from a blog reader. As I thought about these terms and how to blog about them I became concerned that I might just be as clear as mud, but I will do my best. If you talk about database pages HOT is a good thing. If the database page is held in the SQL Server Buffer Pool, main ram it is called HOT.

Cache 40

Cache Energy Database Servers 40

Dynatrace

AUGUST 1, 2022

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). You also decide to run your database for storing user uploads – such as images or videos – directly in Kubernetes. However, you lack insights into your PVCs.

Storage 184

Storage Database Network Metrics 184

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. AWS offers four serverless offerings for storage.

Serverless 276

Serverless AWS Lambda Storage 276

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 127

Performance Hardware Tuning Storage 127

High Scalability

FEBRUARY 19, 2019

Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. At ScaleGrid, we recently added support for Redis Clusters on our platform through our fully managed Redis hosting plans.

Availability 204

Availability Open Source Cache Storage 204

Percona

APRIL 3, 2023

In this blog, we will upgrade PG10, which has tables with OID columns and some extensions to PG13, as an example, using the native pg_upgrade utility. Pg_dump and pg_restore: We can refer to PostgreSQL Upgrade Using pg_dump/pg_restore on dump/restore methods.

C++ 104

C++ Database Cache Storage 104

The Netflix TechBlog

MARCH 7, 2023

These media focused machine learning algorithms as well as other teams generate a lot of data from the media files, which we described in our previous blog , are stored as annotations in Marken. There are many naive solutions possible for this problem for example: Write different runs in different databases. Write algo runs into files.

Media 264

Media Latency Architecture Database 264

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints.

Hardware 90

Hardware C++ Storage Cache 90

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. HA is sometimes confused with “fault tolerance.”

Availability 110

Availability Database Open Source Hardware 110

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. An obvious metric here is CPU usage, but memory usage and other forms of data storage also play their part. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server.

Tuning 137

Tuning Cache Servers Benchmarking 137

Smashing Magazine

MAY 25, 2022

let map = new Map(); let smashing {name: "magazine"}; map.set(smashing, "blog"); // Overwrite the reference. WeakMap can be used in two areas of web development: caching and additional data storage. The result from a function can be cached so that whenever the function is called, the cached result can be reused.

Cache 116

Cache Programming Storage Code 116

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 77

Open Source Database Scalability Software 77

All Things Distributed

JUNE 21, 2018

A common question that I get is why do we offer so many database products? To do this, they need to be able to use multiple databases and data models within the same application. Seldom can one database fit the needs of multiple distinct use cases. Seldom can one database fit the needs of multiple distinct use cases.

Database 167

Database AWS Games Latency 167

Percona

JULY 5, 2023

Fragmentation is a common concern in some database systems. This blog post will discuss fragmentation and its impact on InnoDB. Not all types of fragmentation can happen on all the database technologies, and sometimes you can’t avoid a certain degree of fragmentation. What is fragmentation?

Open Source 127

Open Source Database Efficiency Testing 127

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Werner Vogels weblog on building scalable and robust distributed systems.

Scalability 167

Scalability Database Ecommerce Latency 167

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. Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database.

Best Practices 52

Best Practices Design Tuning Database 52

Particular Software

MAY 22, 2023

For example, you might need the data to be denormalized for performance, or the warehouse data might exist on a physically different system that can’t participate in a database join. From a technical perspective, attributes that change together should also be cached similarly. It gets worse.

Systems 98

Systems Cache Strategy Database 98

Percona

NOVEMBER 6, 2023

Percona Operators allow users to easily manage complex database systems in a Kubernetes environment. With Percona Operators , users can easily deploy, monitor, and manage databases orchestrated by Kubernetes, making it easier and more efficient to run databases at scale. These methods can be applied to any Custom Resources.

Metrics 71

Metrics Monitoring Database Cache 71

All Things Distributed

APRIL 27, 2011

Given that I have frequently written about many of these technologies on this blog I asked investor relations to be allowed to reprint it here. To do so, weve leaned heavily on the core principles from the distributed systems and database research communities and invented from there. blog comments powered by Disqus. Syndication.

Technology 151

Technology Technology AWS Storage 151

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. This blog should make it easier to understand for everyone. It may be because of several reasons, for example, storage is full. We started looking into the stats of the performance schema.

Performance 98

Performance C++ Monitoring Servers 98

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. An extension to Service Workers that enables browsers to present users with cached content when offline. A-series chips have run circles around other ARM parts for more than half a decade, largely through gobsmacking amounts of L2/L3 cache per core.

Media 145

Media Games Education Engineering 145

Percona

JANUARY 17, 2019

now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. AWS Aurora (based on MySQL 5.6)

Cache 47

Cache C++ AWS Airlines 47