Planning Guide

contents

Planning Guide

V3.0

Copyright © 2008-2013 VoltDB, Inc.

This document and the software it describes is licensed under the terms of the GNU Affero General Public License Version 3 as published by the Free Software Foundation.

VoltDB is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License (http://www.gnu.org/licenses/) for more details.

Abstract

This book provides recommendations for those considering the use of VoltDB.

Table of Contents

Preface
1. Organization of this Manual
2. Other Resources
1. The Planning Process
2. Proof of Concept
2.1. Effective Partitioning
2.2. Designing the Stored Procedures
3. Choosing Hardware
3.1. The Dimensions of Hardware Sizing
3.2. Sizing for Throughput
3.3. Sizing for Capacity
3.4. Sizing for Durability
4. Sizing Memory
4.1. Planning for Database Capacity
4.1.1. Sizing Database Tables
4.1.2. Sizing Database Indexes
4.1.3. An Example of Database Sizing
4.2. Planning for Server Distribution
4.2.1. Server Process Memory Usage
4.2.2. Memory Usage in Clusters
4.2.3. K-Safety
4.2.4. Special Buffers for Rejoin and Overflow
5. Benchmarking
5.1. Benchmarking for Performance
5.1.1. Designing Your Benchmark Application
5.1.2. How to Measure Throughput
5.1.3. How to Measure Latency
5.2. Determining Sites Per Host

List of Figures

5.1. Determining Optimal Throughput and Latency
5.2. Determining Optimal Sites Per Host

List of Tables

3.1. Quick Estimates for Memory Usage By Datatype
4.1. Memory Requirements For Tables By Datatype
contents