Tag: database

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 →
HammerDB: Avoiding bottlenecks in client.
By: Date: October 4, 2019 Categories: Databases,Testing & Benchmarking Tags: , , ,

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI. In my…

Read More →
Benchmarking with Postgres PT1
By: Date: June 28, 2019 Categories: Postgres Tags: , ,

In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine.  Assume a Linux virtual machine that has Postgres installed. Specifically using a Bitnami virtual appliance. Once the VM has been started, connect to the console Allow access to postgres port 5432 – which is the postgres…

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 →
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 →