There is a utility to test database workloads when running either on physical or virtual infrastructure. It is an open-source and freely available utility called DVD Store at https://github.com/dvdstore/ds3/. In this post we'll go through some details about the latest version, v. 3.5 of the utility.
Basically, the solution works like this: You create a synthetic workload dataset with the utility. Then you'll load it into the instance via a new test database (DS3), and then run an included load testing tool to simulate orders of DVDs off of a web store.
The latest version, the 3.5 one, now supports multiple stores when creating the database. Additionally, with that, you are leveraging multiple tables in each store. As each store has its own set of tables, it means that let's say you have 3 stores, you'll have 3 different customer tables, three order tables, three product tables, etc. t's created as you create those testing environments.
As such, you can create several instances, via a script that handles the creation of those stores and the tables.
Oracle, MySQL, SQL Server, and now PostgreSQL
New Features in v 3.5
- Multiple Stores – the tool now supports the creation of multiple DVD stores working as a cluster
- Parallel data loading – the data in all tables is loaded at the same time. The previous release has had the data loaded into tables one-by-one. Once one table was loaded with date, then go to the next etc….
Performance is primarily measured with the metric orders per minute (OPM). Each order consists of the entire process of a user logging in, searching for products, seeing product recommendations based on previous purchases, browsing and providing product reviews, and finally purchasing products.
The Github page has all the source files as well as the complete documentation.
DVD Store 3 (DS3) is an open source test / benchmark tool that simultaes an online store that sells DVDs. Customers can login, browse DVDs, browse reviews of DVDs, create new reviews, rate reviews, become premium members, and purchase DVDs. Everything needed to create, load, and stress this online store is included in the DVD Store project. DVD Store 3 is based on the previous DVD Store 2. The new features in DVD Store 3 revolve around the addition of customer reviews and premium membership.
VMware has a detailed post on it here.
Source: VMware Blog
More posts from ESX Virtualization:
- VMware vCenter Converter Discontinued – what’s your options?
- How to upgrade VMware VCSA 7 Offline via patch ISO
- vSphere 7.0 U3C Released
- vSphere 7.0 Page [All details about vSphere and related products here]
- VMware vSphere 7.0 Announced – vCenter Server Details
- VMware vSphere 7.0 DRS Improvements – What's New
- How to Patch vCenter Server Appliance (VCSA) – [Guide]
- What is The Difference between VMware vSphere, ESXi and vCenter
- How to Configure VMware High Availability (HA) Cluster