PASIG 2019 Preservation Storage Cost Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Notes
Values in blue can be edited to adjust the model.
2
3
Preserved Data Size (TB)10001300169021972856371348276275
<-- INPUT #1. How much data will you be storing in the cluster at the end of the year?
4
YoY Growth %30.00%30.00%30.00%30.00%30.00%30.00%30.00%
This is derived from projected data size above.
5
10.00%
Cluster over-provisioning ratio
Adjust this reflect how quickly you feel you can provision new nodes. Lower % = faster provisioning.
6
Cluster provisioning target11001430185924173142408453096902
The minimum amount of cluster capacity that must be provisioned to avoid performance and out-of-space issues.
7
8
Cluster year end capacity11521497.61900.824173315425753676989
This value should be close to the provisioning target. Green is good! Red is bad.
9
Cluster capacity expiring0001152345.6403.21843.21296
4 year trailing value.
10
Cluster new capacity requirement115227836151672577010521535
Net capacity that must be added over the year to meet growth needs.
11
Cluster replacement capacity requirement
0001152518.45761900.81382.4
Assuming a 4 year node lifespan. This is the least amount of capacity we can add to replace expiring capacity.
12
Total cluster capacity add needed115227836116681243134629532918
Minimum amount of net disk that must be added in a year to meet growth + replacement needs.
13
Nodes required for cap add822855109
Total number of cluster nodes (at that year's build config) that will meet the capacity needs above.
14
New cluster capacity added1152345.6403.21843.21296144031683110.4
Total amount of net capacity this year's new nodes are bringing to the cluster.
15
8nodes per rack
Adjust nodes per rack based on power and server size
16
Total cluster nodes in service810121215182024
Number of active nodes at the end of the year.
17
racks required12222333
18
$ per rack per year$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000
Try to include all per rack power, port & space charges here.
19
20
SDS node price$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000
The price paid for a node at that year's configuration.
21
SDS node disk count2424242424242424
22
SDS node disk size (TB)1012141618202224
23
SDS node raw capacity240288336384432480528576
24
SDS node load factor0.60.60.60.60.60.60.60.6
TB to TiBi conversion & erasure coding ratios all rolled into 1 value. .55 to .7 is reasonable. If you want x3 replication instead, try 0.3 or 0.29.
25
SDS node net add (TB)144172.8201.6230.4259.2288316.8345.6
26
27
Non-node capex$15,000$15,000$10,000$10,000$10,000$10,000$10,000$10,000
If you need to account for switches, monitoring nodes, etc. Capex, not services! Service charges go into per rack value, above.
28
29
Capex - Hardware purchases$215,000$65,000$60,000$210,000$135,000$135,000$260,000$235,000
30
Opex - Datacenter services$10,000$20,000$20,000$20,000$20,000$30,000$30,000$30,000
31
Total Hardware & DC$225,000$85,000$80,000$230,000$155,000$165,000$290,000$265,000
32
$/TB/yr$225$65$47$105$54$44$60$42
33
"Cloud Style" $/GB/mo$0.01875$0.00545$0.00394$0.00872$0.00452$0.00370$0.00501$0.00352
Compare to S3 Standard or Infrequent Access pricing.
34
35
Software / Licensing
Edit or replace this section as necessary to reflect quotes from vendors.
36
$75.00
per TB licensing, usage based, capped at $250K.
37
$37,500.00$86,250.00$112,125.00$145,762.50$189,491.25$246,338.63$320,240.21$416,312.28
Assumes we start the year at the prior year's capacity level and grow linearly throughout year.
38
Canonical Storage Advantage$37,500.00$86,250.00$112,125.00$145,762.50$189,491.25$246,338.63$250,000.00$250,000.00
Based on published pricing, license caps at $250K/yr.
39
40
$/TB/yr$37.50$66.35$66.35$66.35$66.35$66.35$51.79$39.84
41
"Cloud Style" $/GB/mo$0.00313$0.00553$0.00553$0.00553$0.00553$0.00553$0.00432$0.00332
42
43
44
Combined Hardware & Support$262,500$171,250$192,125$375,763$344,491$411,339$540,000$515,000
This is the total cost of the local storage component of the preservation system.
45
$/TB/yr$263$132$114$171$121$111$112$82
46
"Cloud Style" $/GB/mo$0.02188$0.01098$0.00947$0.01425$0.01005$0.00923$0.00932$0.00684
Compare to S3 Standard or Infrequent Access pricing.
47
$/GB/yr$0.26250$0.13173$0.11368$0.17103$0.12062$0.11079$0.11188$0.08207
48
49
50
CLOUD
51
$/GB/Mo - AWS Glacier0.00400.00400.00400.00400.00400.00400.00400.0040
We are assuming the use of cold, archival tier products.e.g. Glacier.
52
$/GB/Mo - IBM COS Archive0.00200.00200.00200.00200.00200.00200.00200.0020
53
$/GB/Mo - Oracle Storage Archive0.00260.00260.00260.00260.00260.00260.00260.0026
54
$/GB/Mo - Provider #400000000
55
Combined $/GB/Mo rate0.00860.00860.00860.00860.00860.00860.00860.0086
56
57
$/GB recovery - Provider #10.1000.1000.1000.1000.1000.1000.1000.100
This is a combination of retrieval and bandwidth costs. See 'S3-compatible Cloud Providers' sheet for more.
58
$/GB recovery - Provider #20.1100.1100.1100.1100.1100.1100.1100.110
59
$/GB recovery - Provider #30.0850.0850.0850.0850.0850.0850.0850.085
60
$/GB recovery - Provider #40.0000.0000.0000.0000.0000.0000.0000.000
61
1%
percentage of total archive to recall from each vendor each year. Set to 0% if you want to exclude recall costs.
Assuming we retrieve this % of total archived content from each cloud provider, each year.
62
Combined retrieval rate0.300.300.300.300.300.300.300.30
63
Retrieval costs$2,950.00$3,835.00$4,985.50$6,481.15$8,425.50$10,953.14$14,239.09$18,510.81
A very conservative figure for the inputs, as it does not take into account price tiers.
64
65
Annualized cloud costs$54,550$122,515$159,270$207,050$269,165$349,915$454,890$591,357
For years 2 thru 8, assume we start with prior year's stored content and ramp linearly to current year's projected data size.
66
$/TB/yr$55$94$94$94$94$94$94$94
67
68
Total Preservation Cost
$317,050$293,765$351,395$582,813$613,657$761,254$994,890$1,106,357
69
TB preserved:10001300169021972856371348276275
To remind us what we're actually getting for the price.
70
$/TB preserved per year$317$226$208$265$215$205$206$176
71
$/TB preserved, 3 yr trailing average.
$317$272$250$233$229$228$209$196
averaged cost over 3 years, starting w/i year 2.
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...