Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Ensuring compliance with regulatory standards and best practices also poses a significant obstacle for workload management in the realm of cloud computing platforms.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. DigitalOcean Droplets. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 98

AWS Benchmarking Performance Traffic 98

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. This can dramatically decrease network latency and its effect on the end-user experience. Best practices for a successful cloud migration. Migrate databases intelligently.

Cloud 165

Cloud Traffic Best Practices Strategy 165

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. Such clusters may have different configurations of thread pools to read and write data from database, logging levels and connection configuration with external dependencies.

Media 237

Media Traffic Processing Design 237

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02 order by c. 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . maximum transition latency: Cannot determine or is not supported. Latency: 0.

Best Practices 40

Best Practices Scalability Performance Hardware 40

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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 105

Performance Monitoring Traffic Database 105

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. Management of stateful applications Although stateless applications are frequently associated with Kubernetes, this flexible platform can also effectively handle stateful workloads, such as database management.

Efficiency 104

Efficiency Cloud Healthcare Open Source 104

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. hardware limits: 1000 MHz - 4.00 GHz available cpufreq governors: performance powersave current policy: frequency should be within 1000 MHz and 4.00 hardware limits: 1000 MHz - 4.00

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 124

Traffic Scalability Database Servers 124

High Scalability

DECEMBER 3, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables?

Best Practices 21

Best Practices Performance Systems Processing 21

Smashing Magazine

AUGUST 3, 2023

Layout Shifts From Dynamic And Static Content We have been using dynamic content serving, where each request reaches our back-end server and triggers processes like database retrievals and page renderings. It also reports on mobile usability, security, and best practices such as HTTPS. Time to First Byte over time.

Performance 74

Performance Cache Traffic Metrics 74

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official recommendation (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 52

Speed Java AWS Virtualization 52

VoltDB

JULY 10, 2018

But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer. Problem solved, right?

Architecture 40

Architecture Scalability Ecommerce Latency 40

VoltDB

JULY 10, 2018

But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer. Problem solved, right?

Architecture 40

Architecture Scalability Ecommerce Latency 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 40

Speed Java AWS Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 7, 2019

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 104

Performance Cache Metrics Network 104

All Things Distributed

JUNE 21, 2017

As we said at the time, DynamoDB was a result of 15 years of learning in the area of large scale non-relational databases and cloud services. Based on this experience and learning, we built DynamoDB to be a fast, highly scalable NoSQL database to meet the needs of Internet-scale applications. Fully managed cache for DynamoDB.

Speed 121

Speed Cache Latency AWS 121

Smashing Magazine

JANUARY 6, 2020

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Network Metrics 145