Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. AWS AppSync: AppSync offers a fully managed approach to developing APIs with GraphQL — connecting to AWS DynamoLB or Lambda along with adding caches and client-side data. AWS serverless offerings.

Serverless 325

Serverless AWS Lambda Storage 325

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Scalability Best Practices Blockchain 130

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Missing Cache Settings – Make sure you cache resources that don’t change often on the browser or use a CDN. That included web servers, app services, microservices, queues, databases, mainframe and external services.

Cache 214

Cache Database Architecture Government 214

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 162

Scalability Database Ecommerce Latency 162

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

All Things Distributed

JULY 14, 2015

I am excited to share with you that today we are expanding DynamoDB with streams, cross-region replication, and database triggers. Streams provide you with the underlying infrastructure to create new applications, such as continuously updated free-text search indexes, caches, or other creative extensions requiring up-to-date table changes.

Database 158

Database Lambda AWS IoT 158

The Netflix TechBlog

MAY 19, 2023

Netflix is always looking for security, ergonomic, or efficiency improvements, and this extends to authorization tools. A cleanup process to prune stale relationships from the database. SpiceDB is then responsible for figuring out which relations map back to the autoscaling group, e.g. name, environment, region, etc.

Cache 255

Cache Google Open Source Systems 255

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

The Netflix TechBlog

MARCH 6, 2019

This is just one of many use cases that MezzFS supports, but all the use cases share a similar theme: stream the right bits of a remote object efficiently and expose those bits as a file on the filesystem. Disk Caching? — ? MezzFS can be configured to cache objects on the local disk. Regional caching? —?Netflix

Media 218

Media Storage Processing Cache 218

The Netflix TechBlog

OCTOBER 8, 2024

Building on these foundational abstractions, we developed the TimeSeries Abstraction  — a versatile and scalable solution designed to efficiently store and query large volumes of temporal event data with low millisecond latencies, all in a cost-effective manner across various use cases. Let’s dive into the various aspects of this abstraction.

Latency 239

Latency Storage Traffic Tuning 239

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 132

Availability Database Open Source Hardware 132

Scalegrid

MARCH 28, 2024

Key Takeaways Redis offers complex data structures and additional features for versatile data handling, while Memcached excels in simplicity with a fast, multi-threaded architecture for basic caching needs. Redis is better suited for complex data models, and Memcached is better suited for high-throughput, string-based caching scenarios.

Cache 130

Cache Storage Scalability Architecture 130

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

All Things Distributed

SEPTEMBER 3, 2013

Today, we added two important choices for customers running high performance apps in the cloud: support for Redis in Amazon ElastiCache and a new high memory database instance (db.cr1.8xlarge) for Amazon RDS. No single database architecture or solution can meet all of Amazon.com’s or our customers’ needs.

Cache 99

Cache Cloud Performance Retail 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. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

Performance 136

Performance Monitoring Traffic Database 136

The Netflix TechBlog

MARCH 5, 2019

the order of the rows on your Netflix home page, issuing content licenses when you click play, finding the Open Connect cache closest to you with the content you requested, and many more). In the Efficiency space, our data teams focus on transparency and optimization.

Infrastructure 185

Infrastructure Cloud Scalability AWS 185

Percona

AUGUST 31, 2018

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. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 79

Tuning Database Performance Benchmarking 79

SQL Performance

OCTOBER 13, 2021

I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. In my examples I’ll use a sample database called TSQLV5. iTVFs vs. The main plus is it enables query simplifications that can sometimes result in more efficient plans.

Cache 144

Cache Strategy C++ Code 144

Percona

APRIL 24, 2023

This post is about PostgreSQL, but most of the problems also apply to other database systems. The more indexes, the more the requirement of memory for effective caching. Indexes need more cache than tables Due to random writes and reads, indexes need more pages to be in the cache.

Tuning 139

Tuning Cache Storage Database 139

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 221

Database Traffic Transportation Open Source 221

Dynatrace

NOVEMBER 13, 2020

With Dynatrace, you get end-to-end visibility into each user action, from the user interaction triggered on the mobile device, through the maze of cloud and on-premises services, down to the database statement. To circumvent the resource-efficient collection approach that sends data only every 2 minutes, put the app into background mode.

Code 244

Code Mobile Monitoring Infrastructure 244

Dynatrace

APRIL 21, 2022

Performance efficiency. Performance Efficiency. With the Performance Efficiency pillar of the Azure Well-Architected Framework, organizations must ensure the workloads they modernize and migrate to the cloud are able to scale to meet changes in demand and usage over time. Too much data requested from a database.

Azure 246

Azure Monitoring Virtualization Metrics 246

Percona

MAY 1, 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. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Database Efficiency Performance 52

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 206

Database Traffic Transportation Open Source 206

Scalegrid

JANUARY 21, 2025

Redis Monitoring Essentials Ensuring the performance, reliability, and safety of a Redis database requires active monitoring. With these essential support systems in place, you can effectively monitor your databases with up-to-date data about their health and functioning status at all times.

Strategy 130

Strategy Monitoring Latency DevOps 130

Scalegrid

JUNE 14, 2024

Benefits of Power BI The advantages of Power BI are manifold, from its intuitive interface to its ability to handle large datasets efficiently. Why connect Power BI to a MySQL Database? Connecting Power BI to a MySQL database unlocks many benefits, enabling businesses to harness the full potential of their MySQL data.

Database 130

Database Azure Efficiency Servers 130

Scalegrid

MAY 11, 2024

WiredTiger excels with operational databases and transactional workloads as it offers b-tree-based storage and well-ordered data structures. It uses a filesystem cache and write-ahead log for crash recovery. A database level lock is held during the compaction operation. Compaction operation defragments data files & indexes.

Storage 130

Storage Engineering Cache Database 130

Percona

FEBRUARY 15, 2023

Bloom filters are an essential component of an LSM-based database engine like MyRocks. A bloom filter is a space-efficient way of storing information about a list of keys. For good performance, the filter blocks are cached in the RocksDB block cache and normally stay there since they are accessed frequently.

Storage 138

Storage Tuning Cache Engineering 138

Scalegrid

DECEMBER 21, 2023

Redis® Monitoring Essentials Ensuring the performance, reliability, and safety of a Redis® database requires active monitoring. With these essential support systems in place, you can effectively monitor your databases with up-to-date data about their health and functioning status at all times.

Strategy 130

Strategy Monitoring Latency DevOps 130

Percona

APRIL 30, 2024

We needed to scale fast but also very efficiently, and caching became one of the core technologies to achieve […] Back in the early 2000s, “Web 2.0” ” was being built following the aftermath of the dot-com crash. The open source LAMP (Linux-Apache-MySQL-PHP/Perl/Python) stack was all the rage.

Open Source 124

Open Source Cache Efficiency Technology 124

Percona

MARCH 20, 2023

When deciding what to pick, there are many things to consider, like where the proxy needs to be, if it “just” needs to redirect the connections, or if more features need to be in, like caching and filtering, or if it needs to be integrated with some MySQL embedded automation. Given that, there never was a single straight answer.

Games 141

Games Latency Traffic Cache 141

Percona

JULY 5, 2023

Fragmentation is a common concern in some database systems. In databases, we can experiment with different types of fragmentation: Segment Fragmentation : segments are fragmented; they are stored not following the order of data, or there are empty pages gaps between the data pages. What is fragmentation?

Open Source 137

Open Source Database Efficiency Testing 137

Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global caches like the InnoDB buffer pool and MyISAM key cache and session-level caches like the sort buffer, join buffer, random read buffer, etc. Do these queries use more caches?

Traffic 98

Traffic Cache Monitoring Database 98

Percona

SEPTEMBER 1, 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. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 75

Cache Database Games Healthcare 75

The Morning Paper

FEBRUARY 6, 2020

Last week we looked at a function shipping solution to the problem; Cloudburst uses the more common data shipping to bring data to caches next to function runtimes (though you could also make a case that the scheduling algorithm placing function execution in locations where the data is cached a flavour of function-shipping too).

Serverless 98

Serverless Lambda Cache Latency 98

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

All Things Distributed

OCTOBER 12, 2016

Fast Data is an emerging industry term for information that is arriving at high volume and incredible rates, faster than traditional databases can manage. While caching continues to be a dominant use of ElastiCache for Redis, we see customers increasingly use it as an in-memory NoSQL database.

Scalability 102

Scalability Cache Analytics AWS 102