Category: Nutanix

How to measure database scaling & density on Nutanix HCI platform.
By: Date: March 27, 2020 Categories: Nutanix Tags: , , ,

How can database density be measured? How does database performance behave as more DBs are consolidated? What impact does running the CVM have on available host resources? tl;dr The cluster was able to achieve ~90% of the theoretical maximum. CVM overhead was 5% for this workload. Experiment setup The goal was to establish how database…

Read More →
How to run vdbench benchmark on any HCI with X-Ray
By: Date: March 23, 2020 Categories: X-Ray Tags: ,

Many storage performance testers are familiar with vdbench, and wish to use it to test Hyper-Converged (HCI) performance. To accurately performance test HCI you need to deploy workloads on all HCI nodes. However, deploying multiple VMs and coordinating vdbench can be tricky, so with X-ray we provide an easy way to run vdbench at scale….

Read More →
Impact of Data locality on DB workloads.
By: Date: July 23, 2019 Categories: Nutanix Tags: ,

In this video I migrate a Postgres DB running PGbench benchmark. The DB is running on a Host which is CPU constrained. Once the VM is migrated to a less busy host the transaction rate immediately increases from ~15,000 to ~20,000. As the DB continues to run on the new host – the Nutanix storage…

Read More →
Install a bitnami image to Nutanix AHV cluster.
By: Date: June 28, 2019 Categories: Nutanix Tags: , , , ,

One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by companies like Bitnami. We can use these same appliance images on Nutanix AHV to easily do a Postgres database benchmark Step 1. Get the bitnami image wget  https://bitnami.com/redirect/to/587231/bitnami-postgresql-11.3-0-r56-linux-debian-9-x86_64.zip Step 2. Unzip the file and convert…

Read More →
Database compression on Nutanix
By: Date: February 17, 2019 Categories: Nutanix

Compressability What space savings should you expect when running databases with default compression in a Nutanix cluster? When we ran the TPCx-HCI benchmark on our cluster we realized about 2:1 savings from compression alone. The TPCx-HCI benchmark mimics a database consolidation setup, meaning that there are many databases per host. The uncompressed data size was…

Read More →
Nutanix AES: Performance By Example PT2
By: Date: December 18, 2018 Categories: Nutanix Tags: , ,

How to improve large DB read performance by 2X Nutanix AOS 5.10 ships with a feature called Autonomous Extent Store (AES).  AES effectively provides Metadata Locality to complement the existing data locality that has always existed.  For large datasets (e.g. a 10TB database with 20% hot data) we observe a 2X improvement in throughput for random…

Read More →
Nutanix AES: Performance By Example.
By: Date: December 17, 2018 Categories: Nutanix Tags: , ,

How to reduce database restore time by 50% During .Next 2018 in London, Nutanix announced performance improvements in the core-datapath said to give up to 2X performance improvements.  Here’s a real-world example of that improvement in practice. I am using X-Ray to simulate a 1TB data restore into an existing database.  Specifically the IO sizes…

Read More →
How scalable is my Nutanix cluster really?
By: Date: November 20, 2018 Categories: Nutanix Tags: ,

In a previous post I showed a chart which plots concurrency [X-axis] against throughput (IOPS) on the Y-Axis.  Here is that plot again: Experienced performance chart ogglers will notice the familiar pattern of Littles Law, whereby throughput (X) rises quickly as concurrency (N) is increased.  As we follow the chart to the right, the slope flattens…

Read More →
Working with fio “distribution /pereto” parameter
By: Date: November 12, 2018 Categories: Nutanix,X-Ray Tags: ,

The fio Pareto parameter allows us to create a workload, which references a very large dataset, but specify a hotspot for the access pattern.  Here’s an example using the same setup as the ILM experiment, but using a Pareto value of 0:8.  My fio file looks like this.. [global] ioengine=libaio direct=1 time_based norandommap random_distribution=pareto:0.8 The…

Read More →
You are here. The art of HCI performance testing
By: Date: November 9, 2018 Categories: Nutanix

At some point potential Hyper-converged infrastructure (HCI) users want to know – “How fast does this thing go?”.  The real question is “how do we measure that?”. The simplest test is to run a single VM, with a single disk and issue a single IO at a time.  We see often see this sort of…

Read More →
X-Ray scenario to demonstrate Nutanix ILM behavior.
By: Date: October 25, 2018 Categories: X-Ray Tags: ,

Specifically a customer wanted to see how performance changes (and how quickly) as data moves from HDD to SSD automatically as data is accessed.  The access pattern is 100% random across the entire disk. In a hybrid Flash/HDD system – “cold” data (i.e. data that has not been accessed for a long time) is moved…

Read More →
HCI Performance testing made easy (Part 3)
By: Date: September 17, 2018 Categories: X-Ray Tags: , , , , ,

Creating a HCI benchmark to simulate multi-tennent workloads     HCI deployments are typically multi-tennant and often different nodes will support different types of workloads. It is very common to have large resource-hungry databases separated across nodes using anti-affinity rules.  As with traditional storage, applications are writing to a shared storage environment which is necessary to…

Read More →
Detecting and correcting hardware errors using Nutanix Filesystem.
By: Date: March 15, 2018 Categories: Nutanix Tags: ,

It’s good to detect corrupted data.  It’s even better to transparently repair that data and return the correct data to the user.  Here we will demonstrate how Nutanix filesystem detects and corrects corruption.  Not all systems are made equally in this regard.  The topic of corruption detection and remedy was the focus of this excellent…

Read More →