Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 90

Database Hardware Open Source Strategy 90

Scalegrid

DECEMBER 21, 2023

Buckle up as we delve into the world of Redis® monitoring, exploring the most important Redis® metrics, discussing essential tools, and even peering into the future of Redis® performance management. Identifying key Redis® metrics such as latency, CPU usage, and memory metrics is crucial for effective Redis monitoring.

Strategy 130

Strategy Monitoring Latency DevOps 130

HammerDB

DECEMBER 5, 2020

For example HammerDB has not used tpmC terminology to report TPC-C based metrics instead using TPM and NOPM nomenclature. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. Why would this be the case?

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

FEBRUARY 24, 2023

Identifying which resources you can trim to reduce your monthly bill can be difficult, but looking at the right metrics will help you understand the application’s actual requirements. Configuration of the CPU metrics can be changed in the dashboard. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 121

Cloud Serverless AWS Storage 121

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

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.

AWS 52

AWS Database Serverless Storage 52

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. The key metric for measuring the sustainability of a digital product is its energy usage. Many efforts are afoot to improve the situation on the web.

Website Performance 73

Website Performance Website Energy Performance 73

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time. Interoperability with Hadoop.

Big Data 154

Big Data Processing Lambda Database 154

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency.

Database 213

Database Latency C++ Scalability 213

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. Why Do MySQL Backups Matter? What is the Recovery Time Objective?

Best Practices 79

Best Practices Storage Strategy Database 79

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

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. Columnar storage. OLTP vs OLAP. Let’s get back to basics. References tables.

Database 92

Database Analytics Storage Processing 92

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Dotcom-Montior

MAY 12, 2020

Websites are now more than just the storage and retrieval of information to present content to users. There are certain metrics to be considered for a user to have a hassle-free experience. Database connectivity. Hardware resources. Database Connectivity. Present-day applications make more much use of the database.

Monitoring 63

Monitoring Entertainment Hardware Latency 63

The Netflix TechBlog

FEBRUARY 13, 2020

There is a potential benefit in reusing the hardware in place for video compression/decompression. Image decoding in hardware may not be a primary motivator, given the peculiarities of OS dependent UI composition, and architectural implications of moving uncompressed image pixels around.

Code 212

Code Metrics Efficiency Open Source 212

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Dynatrace

AUGUST 5, 2019

Database & functional migration. Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. Step 4: Smart Database Migration. Which applications and services are depending on a database that might be impacted by a migration?

Cloud 31

Cloud Traffic Database Network 31

Alex Russell

APRIL 29, 2021

Another window into this question is provided by the Web Confluence Metrics project. Chrome has missed several APIs for 3+ years: Storage Access API. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware. Converging Views.

Media 145

Media Games Education Engineering 145

Alex Russell

MARCH 6, 2021

The scale of the effect can be deeply situational or hard to suss out without solid metrics. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Hardware Past As Performance Prologue. The Moto G4 , for example. Mind The Gap.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

JANUARY 22, 2020

By their very definition, table-valued parameters are strongly-typed to a user-defined table type that must exist within the database where the call is being made. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55

Servers Azure Hardware Network 55

Adrian Cockcroft

NOVEMBER 11, 2019

This discussion focuses on hardware, software and operational failure modes. Collecting some critical metrics at one second intervals, with a total observability latency of ten seconds or less matches the human attention span much better. Try to measure your mean time to respond (MTTR) for incidents.

Latency 52

Latency Engineering Systems Hardware 52

Adrian Cockcroft

NOVEMBER 11, 2019

This discussion focuses on hardware, software and operational failure modes. Collecting some critical metrics at one second intervals, with a total observability latency of ten seconds or less matches the human attention span much better. Try to measure your mean time to respond (MTTR) for incidents.

Latency 53

Latency Engineering Systems Hardware 53

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 107

Database Benchmarking Latency C++ 107

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 6, 2020

Getting Ready: Planning And Metrics. Getting Ready: Planning And Metrics. You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Table Of Contents. Quick Wins.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

Getting Ready: Planning And Metrics. Getting Ready: Planning And Metrics. You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Table Of Contents. Setting Realistic Goals. Defining The Environment.

Performance 103

Performance Cache Metrics Network 103