Checksums in Storage Systems and Why the Enterprise Should Care

DZone

It’s really scary knowing that such corruptions are happening in the memory of our computers and servers – that is before they even reach the network and storage portions of the stack. That data must then be safely transported over a network to the storage system where it is written to disk. Well, if you’re using one of the storage protocols that lack end-to-end checksums (e.g. performance storage database checksum data corruption data safety

Using Diskspd to test SQL Server Storage Subsystems

SQL Shack

In this article, we will learn how to test our storage subsystems performance using Diskspd. The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Improving Spark Memory Resource With Off-Heap In-Memory Storage

DZone

performance storage spark caching in-memory spark caching spark memoryImprove your Spark memory. In the previous tutorial , we demonstrated how to get started with Spark and Alluxio. To share more thoughts and experiments on how Alluxio enhances Spark workloads, this article focuses on how Alluxio helps to optimize the memory utilization of Spark applications.

An Efficient Object Storage for JUnit Tests

DZone

To resolve the problem it was suggested to find more suitable data storage. One day I faced the problem with downloading a relatively large binary data file from PostgreSQL. There are several limitations to store and fetch such data (all restrictions could be found in official documentation ). For some internal reasons well known Amazon S3 bucket was chosen for this purpose. The choice affected the project's unit test base.

Advancing Application Performance with NVMe Storage, Part 3

DZone

NVMe Storage Use Cases. NVMe storage's strong performance, combined with the capacity and data availability benefits of shared NVMe storage over local SSD, makes it a strong solution for AI/ML infrastructures of any size. big data ai data storage ml nvme peperformanceThere are several AI/ML focused use cases to highlight.

Advancing Application Performance With NVMe Storage, Part 2

DZone

For example, one well-respected vendor's standard solution is limited to 7.5TB of internal storage, and it can only scale to 30TB. In contrast, there are generally available NVMe solutions that can scale from 100TB to 1PB of shared NVMe storage at the performance of local NVMe SSDs, providing the opportunity to significantly increase the depth of the training for neural networks. big data performance data storage ssd nvme gpu ai ml

Building an elastic query engine on disaggregated storage

The Morning Paper

Building an elastic query engine on disaggregated storage , Vuppalapati, NSDI’20. Analysed from the perspective of cloud-native design this presents a number of issues: CPU, memory, storage, and bandwidth resources are all aggregated at each node, and can’t be scaled independently, making it hard to fit a workload efficiently across multiple dimensions. But the ephemeral storage service for intermediate data is not based on S3.

Partitioned Hive Table Across Storage Systems Using Alluxio

DZone

However, Hive cannot access a single table directly using a single query with the data of this Hive table across different mediums of storage and different clusters. This becomes a need when the data volume grows too large to fit a single medium of storage or cluster, and also when the users need to take into account the following considerations: Storage cost, where some partitions are less important than others and can be stored on cheaper storage tiers.

Microsoft diskspd. Part 2, Accurately testing storage devices.

n0derunner

Often, when doing storage performance testing, we are interested in stressing the underlying storage devices, not the OS filesystem. Summary tl;dr There are two ways to ensure that IO goes directly to the backend storage (direct attach disk, SAN or HCI datastore) Use a “raw” or “physical” device (#<diskID) Open files on the filesystem with … The post Microsoft diskspd. Part 2, Accurately testing storage devices.

View from Nutanix storage during Postgres DB benchmark

n0derunner

The post View from Nutanix storage during Postgres DB benchmark appeared first on n0derunner. A quick look at how the workload is seen from the Nutanix CVM. In this example from prior post. The Linux VM running postgres has two virtual disks – one taking transaction log writes. The other is doing reads and writes from the main datafiles.

Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups

SQL Shack

This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups. Prerequisites In this series of articles, we will configure the SQL Server always on availability groups from end to end for your learning purpose. We covered the following topics in the previous articles. A […]. AlwaysOn Availability Groups Clustering High Availability

Advancing Application Performance with NVMe Storage, Part 1

DZone

With big data on the rise and data algorithms advancing, the ways in which technology has been applied to real-world challenges have grown more automated and autonomous. This has given rise to a completely new set of computing workloads for Machine Learning which drives Artificial Intelligence applications. AI/ML can be applied across a broad spectrum of applications and industries.

Narrowing the gap between serverless and its state with storage functions

The Morning Paper

Narrowing the gap between serverless and its state with storage functions , Zhang et al., Shredder is " a low-latency multi-tenant cloud store that allows small units of computation to be performed directly within storage nodes. " From an operator perspective it makes it harder to follow the classic cloud-native design in which a global storage layer is separate to compute. In from of them is a networking layer, and the in-memory storage layer holds the actual data.

Intro to Redis Cluster Sharding – Advantages, Limitations, Deploying & Client Connections

High Scalability

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.

The AWS Storage Gateway - All Things Distributed

All Things Distributed

Expanding the Cloud - The AWS Storage Gateway. Today Amazon Web Services has launched the AWS Storage Gateway, making the power of secure and reliable cloud storage accessible from customersâ?? With the launch of the AWS Storage Gateway our customers can now integrate their on-premises IT environment with AWSâ??s s storage infrastructure. The AWS Storage Gateway is a service connecting an on-premises software appliance with cloud-based storage.

Byte Down: Making Netflix’s Data Infrastructure Cost-Effective

The Netflix TechBlog

cloud-storage data data-infrastructure aws netflixBy Torio Risianto, Bhargavi Reddy, Tanvi Sahni, Andrew Park Continue reading on Netflix TechBlog ».

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

High performance, query optimization, open source and polymorphic data storage are the major Greenplum advantages. Greenplum also introduced many features which are unavailable within PostgreSQL, such as parallel data loading, resource management, storage enhancements and advanced query optimization, making it an attractive offering when you are comparing the two. Polymorphic Data Storage.

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

High Scalability

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines. So what makes PostgreSQL so special, and how is it being used today?

Expanding the Cloud - Amazon S3 Reduced Redundancy Storage.

All Things Distributed

Expanding the Cloud - Amazon S3 Reduced Redundancy Storage. Today a new storage option for Amazon S3 has been launched: Amazon S3 Reduced Redundancy Storage (RRS). This new storage option enables customers to reduce their costs by storing non-critical, reproducible data at lower levels of redundancy. This has been an option that customers have been asking us about for some time so we are really pleased to be able to offer this alternative storage option now.

MezzFS?—?Mounting object storage in Netflix’s media processing platform

The Netflix TechBlog

Mounting object storage in Netflix’s media processing platform By Barak Alon (on behalf of Netflix’s Media Cloud Engineering team) MezzFS (short for “Mezzanine File System”) is a tool we’ve developed at Netflix that mounts cloud objects as local files via FUSE. That file is stored in our object storage service, which splits and encrypts the file into separate chunks, storing the chunks in Amazon S3. Our object storage service splits objects into many parts and stores them in S3.

Media 185

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB storage results in a larger storage footprint. JSONB storage does not deduplicate the key names in the JSON. This can result in considerably larger storage footprint compared to MongoDB BSON on WiredTiger or traditional column storage. If that doesn’t work, the data is moved to out-of-line storage.

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

Scalegrid

Note: ScaleGrid implements follower clusters using storage snapshots. And since the entire import is performed using storage snapshots, rather than a logical dump, the process is nearly instantaneous. Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data.

Azure Storage Persistence now faster in NServiceBus 6

Particular Software

If you're using Azure Storage Persistence and haven't upgraded to NServiceBus 6 yet, get ready for a tremendous performance boost for your application when you do especially if you make use of sagas. In the previous version of Azure Storage Persistence, looking up a saga by a correlation property was not as fast as looking it up by SagaId. Azure Table Storage, where saga data is stored, is limited to indexing on two columns: the Partition Key and the Row Key.

Back-to-Basics Weekend Reading - A Decomposition Storage Model

All Things Distributed

Not everybody agreed that the "N-ary Storage Model" (NSM) was the best approach for all workloads but it stayed dominant until hardware constraints, especially on caches, forced the community to revisit some of the alternatives. Combined with the rise of data warehouse workloads, where there is often significant redundancy in the values stored in columns, and database models based on column oriented storage took off. A Decomposition Storage Model , George P.

Expanding the Cloud ? Managing Cold Storage with Amazon Glacier

All Things Distributed

Managing Cold Storage with Amazon Glacier. With the introduction of Amazon Glacier , IT organizations now have a solution that removes the headaches of digital archiving and provides extremely low cost storage. Building and managing archive storage that needs to remain operational for decades if not centuries is a major challenge for most organizations. A Complete Storage Solution. storage that is directly accessible. All Things Distributed.

Making it Easier to Manage a Production PostgreSQL Database

Scalegrid

Note: The community has already started work on the zheap storage engine that overcomes this limitation. The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. Feature-wise, it is up there with the best, if not the best. There are many things I love about it – PL/ PG SQL, smart defaults, replication (that actually works out of the box), and an active and vibrant open source community.

Driving Storage Costs Down for AWS Customers - All Things.

All Things Distributed

Driving Storage Costs Down for AWS Customers. As we showed last week one of the services that is growing rapidly is the Amazon Simple Storage Service (S3). AWS today announced a substantial price drop per February 1, 2012 for Amazon S3 standard storage to help customers drive their storage cost down. Other storage tiers may see even greater cost savings. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems.

Back-to-Basics Weekend Reading - RAID: High-Performance, Reliable Secondary Storage

All Things Distributed

RAID: High-Performance, Reliable Secondary Storage Peter Chen, Edward Lee, Garth Gibson, Randy Katz and David Patterson, ACM Computing Surveys, Vol 26, No. Disk arrays, which organize multiple, independent disks into a large, high-performance logical disk, were a natural solution to dealing with constraints on performance and reliability of single disk drives. The term "RAID" was invented by David Patterson, Garth A. Gibson, and Randy Katz at the University of California, Berkeley in 1987.

MySQL High Availability Framework Explained – Part III: Failover Scenarios

High Scalability

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. MySQL Failover Scenarios. Scenario 1 – Master MySQL Goes Down. The Corosync and Pacemaker framework detects that the master MySQL is no longer available.

How to identify SSD types and measure performance.

n0derunner

storage fio samsung ssdStart by identifying the exact SSD type by using lsscsi. lsscsi [1:0:0:0] cd/dvd QEMU QEMU DVD-ROM 2.5+ /dev/sr0 [2:0:0:0] disk ATA SAMSUNG MZ7LM1T9 404Q /dev/sda [2:0:1:0] disk ATA SAMSUNG MZ7LM1T9 404Q /dev/sdb [2:0:2:0] disk ATA SAMSUNG MZ7LM1T9 404Q /dev/sdc [2:0:3:0] disk ATA SAMSUNG MZ7LM1T9 404Q /dev/. Device Specs. The spec sheet for this ssd claims the following performance characteristics.

Identifying Optane drives in Linux

n0derunner

Storage Hardware and Devices nvme optaneThe easiest way to identify NVME drives backed by either NAND flash or Optane is to use $ lspci -v The output will look like this for NVME/NAND 00:0d.0 Non-Volatile memory controller: Intel Corporation NVMe Datacenter SSD [3DNAND, Beta Rock Controller] (prog-if 02 [NVM Express]) Subsystem: Intel Corporation NVMe Datacenter SSD [3DNAND] SE 2.5" The post Identifying Optane drives in Linux appeared first on n0derunner.

Uber Infrastructure in 2019: Improving Reliability, Driving Customer Satisfaction

Uber Engineering

Architecture General Engineering CPU Infrastructure Observability Productivity Reliability Search Infrastructure Storage Uber Eats Velocity

Microsoft diskspd. Part 1 Preparing to test.

n0derunner

diskspd benchmarking storage windowsInstalling Disk-Speed (diskspd). Get diskpd binary from Microsft : [link] Manual is here: [link] Agree to License Extract Zip file (DocumentsDiskspd-2.0.21a) open Terminal/Command Prompt cd to the Extracted directory cd to AMD64 Overview diskspd operates on windows filesystems, and will read / write to one or more files concurrently. The NULL byte problem By default, … The post Microsoft diskspd. Part 1 Preparing to test.

Speed 40

Microsoft diskpd. Part 1 Preparing to test.

n0derunner

diskspd benchmarking storage windowsInstalling Disk-Speed (diskspd). Get diskpd binary from Microsft : [link] Manual is here: [link] Agree to License Extract Zip file open Terminal/Command Prompt cd to the Extracted directory cd to AMD64 Overview diskspd operates on windows filesystems, and will read / write to one or more files concurrently. The NULL byte problem By default, when … The post Microsoft diskpd. Part 1 Preparing to test. appeared first on n0derunner.

Speed 40

Best Practices for Efficient Log Management and Monitoring

DZone

performance monitoring apm log management log efficient log management and monitoring log management best practices log storageWhen managing cloud-native applications, it's essential to have end-to-end visibility into what's happening at any given time. This is especially true because of the distributed and dynamic nature of cloud-native apps, which are often deployed using ephemeral technologies like containers and serverless functions.

Why does my SSD not issue 1MB IO’s?

n0derunner

To achieve the maximum throughput on a storage device, we will usually use a large IO size to maximize the amount of data is transferred per IO request. For historical reasons, many storage testers will use a 1MB IO size for sequential testing. SSD Performance benchmarking kernel linux ssd storageFirst things First. CDC 9762 SMD disk drive from 1974. Why do we tend to use 1MB IO sizes for throughput benchmarking?

Uber’s Big Data Platform: 100+ Petabytes with Minute Latency

Uber Engineering

Architecture Uber Data Apache Apache Hadoop Apache Parquet Apache Spark Big Data Data Modeling Data Warehouse Docker Engineering Hadoop Hoodie Hudi JSON Latency MySQL PostgresSQL Storage Uber EngUber is committed to delivering safer and more reliable transportation across our global markets.

Databook: Turning Big Data into Knowledge with Metadata at Uber

Uber Engineering

Architecture Uber Data Cassandra Data Management Data Storage Data Warehouse Databook Dropwizard Gradle HDFS HIVE Infrastructure Kafka Metadata MySQL Postgres Quartz Queryparser RESTful API Uber Uber Data Knowledge Uber Engineering VerticaFrom driver and rider locations and destinations, to restaurant orders and payment transactions, every interaction on Uber’s transportation platform is driven by data.

Dynatrace Managed release notes version 1.204

Dynatrace

To free disk space, log files related to metric and configuration storage, in addition to Elasticsearch log files, are now automatically deleted after two months. The Cluster nodes overview page now displays Dynatrace version and transaction storage size details for each node. Previous metric storage and configuration data backups are now removed once the new backups are completed. Dynatrace news. New features and enhancements. General.

Building Netflix’s Distributed Tracing Infrastructure

The Netflix TechBlog

Our distributed tracing infrastructure is grouped into three sections: tracer library instrumentation, stream processing, and storage. A second job taps the data feed from the first job, does tail sampling of data and writes traces to the storage system. Storage: don’t break the bank!

SQL Server troubleshooting: Disk I/O problems

SQL Shack

The storage subsystem is one of the significant performance factors for the databases. In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting.

Back-to-Basics Weekend Reading - The 5 Minute Rule - All Things.

All Things Distributed

The AWS team launched this week Amazon Glacier , a cold storage archive service at the very low price point of $0.01 The Five-Minute Rule Ten Years Later, and Other Computer Storage Rules of Thumb , Jim Gray and Goetz Graefe, ACM SIGMOD Record 26 (4): 63â??68, In 2007 Goetz revisited the results, this time also including SSD storage into the mix, which not surprisingly did change everything. All Things Distributed.

My Best Christmas Present ? Root Domain Support for Amazon S3.

All Things Distributed

S3 is not only a highly reliable and available storage service but also one of the most powerful web serving engines that exists today. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. My Best Christmas Present â?? Root Domain Support for Amazon S3 Website Hosting. By Werner Vogels on 27 December 2012 12:00 PM. Permalink. Comments ().