Smashing Magazine

JUNE 18, 2020

In this article, we’re going to see some of those differences and how to overcome them. More specifically, we’re going to talk about storage and UI differences, which are the ones that most often cause confusion to developers when writing Flutter code that they want to be cross-platform. Example 1: Storage.

Storage 103

Storage Mobile Website Java 103

Percona

AUGUST 22, 2023

This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). Some of the most important elements include: No single point of failure (SPOF): You must eliminate any SPOF in the database environment, including any potential for an SPOF in physical or virtual hardware. What is fault tolerance?

Availability 98

Availability Hardware Open Source Database 98

Scalegrid

JANUARY 8, 2024

Discover key insights and strategic advice in our article, designed to steer you toward the best cloud solution that fits your company’s priorities. This article will focus on the technology behind ScaleGrid’s Database-as-a-Service (DBaaS) solutions and how they align with multi-cloud and hybrid cloud structures.

Cloud 147

Cloud Strategy Scalability Artificial Intelligence 147

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. I can recommend this article by Peter Morville and Jeffrey Callender for further reading. Taking into account the previous considerations, performance requirements were set as 1000 faceted navigation requests/second per typical hardware blade.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. There are also large differences in storage capacity and throughput between these extremes.

Azure 72

Azure Virtualization Servers Storage 72

Scalegrid

AUGUST 30, 2024

This article provides instructions on how to fortify your RabbitMQ setup. Storage Encryption for Persistent Messages Protecting sensitive data from unauthorized access is crucial, and encrypting messages at rest safeguards this information should the physical storage be breached. 509 certificates, and OAuth 2.0,

Transportation 130

Transportation Virtualization Strategy Storage 130

Scalegrid

JUNE 14, 2024

In this article, we will explore the process of how to connect MySQL to Power BI, a leading business intelligence tool. By employing techniques like indexing, query optimization, denormalization, and proper hardware configuration in MySQL, data retrieval operations can be significantly improved.

Database 130

Database Azure Efficiency Servers 130

Brendan Gregg

FEBRUARY 28, 2023

As I was determined to become great at my new occupation regardless of my location, I read every sysadmin book, article, and magazine I could find on the shelf. I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty). Or even on a plane.

Performance 103

Performance Latency Cache Virtualization 103

SQL Performance

APRIL 27, 2020

The basic tier provides up to 5 DTUs with standard storage. The standard tier supports from 10 up to 3000 DTUs with standard storage and the premium tier supports 125 up to 4000 DTUs with premium storage, which is orders of magnitude faster than standard storage. New Hardware Configuration for Provisioned Compute Tier.

Azure 55

Azure Database Serverless Hardware 55

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

Abhishek Tiwari

DECEMBER 27, 2017

faster access to external storage and data locality (I/O, bandwidth). Using default scheduler's node affinity feature you can ensure that certain pods only schedule on nodes with specialized hardware like GPU, memory-optimised, I/O optimised etc. Storage provisioning. But Kubernetes storage is evolving quite quickly.

Big Data 63

Big Data Storage Benchmarking Hardware 63

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. For deep technical details and undocumented options, see Dmitry Pilugin's excellent article on the subject. Please see my previous article if you need a refresher on the details. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This not only enhances performance but also enables you to make more efficient use of your hardware resources, potentially resulting in cost savings on infrastructure.

Tuning 52

Tuning Database Performance Hardware 52

Alex Russell

SEPTEMBER 20, 2020

Pre-publication gates were valuable when better answers weren't available, but commentators should update their priors to account for hardware and software progress of the past 13 years. Fast forward a decade, and both the software and hardware situations have changed dramatically. Don't like the consequences?

Hardware 71

Hardware Mobile Programming Java 71

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. It also supports auto-scaling of compute and storage resources, dynamically adjusting capacity based on chosen utilization thresholds to optimize performance and costs.

AWS 52

AWS Database Serverless Storage 52

Brendan Gregg

FEBRUARY 28, 2023

As I was determined to become great at my new occupation regardless of my location, I read every sysadmin book, article, and magazine I could find on the shelf. I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty). Or even on a plane.

Performance 52

Performance Latency Cache Virtualization 52

SQL Server According to Bob

JANUARY 11, 2020

Important When planning, deploying, and maintaining a Microsoft SQL Server installation, ensure that the I/O system supports all the factors outlined in this article. Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure.

Servers 40

Servers Cache Media Hardware 40

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

JANUARY 22, 2020

However, strongly-typed isn't really strictly "strongly-typed" as you would expect, as this article is going to demonstrate, and performance could be impacted as a result. 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

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

Percona

MAY 1, 2023

Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements. This not only results in cost savings by minimizing hardware requirements but also has the potential to decrease cloud expenses.

Tuning 52

Tuning Database Efficiency Performance 52

Alex Russell

OCTOBER 22, 2017

This, in turn, drives the single most important trend in setting the global web performance budget hardware baseline: the next billion users will largely come online when they can afford to. Previous versions of this article discussed slow-start, bdp, tcp window scaling, and the like. seconds: 400 Kbps = 50KB/s. 50KB/s * 3.4 = 170KB.

Performance 74

Performance Network Benchmarking Mobile 74

Brendan Gregg

SEPTEMBER 5, 2017

I wrote an ftrace toolkit, [perf-tools], and the article [Ftrace: the hidden light switch]. - **perf**: since 2009, this started as a PMC profiler but can do tracing now as well, usually in a dump-and-post-process style. It requires a subscription to read the latest articles, but if Linux is going to be a big part of your job, it's worth it.

Virtualization 75

Virtualization AWS Engineering Hardware 75

Percona

AUGUST 27, 2018

assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. If you ever wondered how much storage performance could be improved by using faster cloud volumes, you’re not alone. Currently, CPU affinity (i.e.,

Tuning 69

Tuning Virtualization Testing Servers 69

Percona

APRIL 17, 2023

The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture. For example: Read/Write tickets WiredTiger uses tickets to control the number of read / write operations simultaneously processed by the storage engine. The report focuses on MySQL, but it is valid for MongoDB as well.

Best Practices 52

Best Practices Design Tuning Database 52

Highly Scalable

SEPTEMBER 18, 2012

In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. In the rest of this article we study a number of distributed activities like replication of failure detection that could happen in a database. Data Placement. Consistency. Read-Write consistency.

Database 213

Database Latency C++ Scalability 213

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Any storage device that can survive a power outage. Starting with the Linux 4.18

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JANUARY 11, 2020

​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40

Servers Cache Database Media 40

CSS Wizardry

APRIL 2, 2018

That said, perhaps this article might provide some use to people looking to get a better handle on their digital setup: I know I would have certainly appreciated a post like this when I was setting out. If I sound like I don’t have a clue what I’m talking about, that’s probably because I don’t. Background. Technics OTTAVA™ f SC-C70 – £799.

Website 109

Website Media Hardware Monitoring 109

Alex Russell

MARCH 6, 2021

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. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version.

Performance 127

Performance Network Mobile Metrics 127

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. 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 78

Website Performance Website Energy Performance 78

Smashing Magazine

JANUARY 11, 2021

It’s worth noting that you will end up with better Core Web Vitals scores by following a general advice in this article.). On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing and execution times (we’ll talk about them in detail later). Largest Contentful Paint ( LCP ) < 2.5 considerations.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). From Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. To achieve the goals stated in the first paragraph, we have to consider the critical file size budget for JavaScript.

Performance 112

Performance Cache Servers Network 112

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). awesome-webpack is a curated list of useful Webpack resources, libraries and tools, including articles, videos, courses, books and examples for Angular, React and framework-agnostic projects.

Performance 111

Performance Cache Network Metrics 111

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