forked from influxdata/influxdb-comparisons
-
Notifications
You must be signed in to change notification settings - Fork 2
/
cassandra_devops_common.go
129 lines (105 loc) · 4.5 KB
/
cassandra_devops_common.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
package main
import (
"fmt"
"math/rand"
"time"
)
// CassandraDevops produces Cassandra-specific queries for all the devops query types.
type CassandraDevops struct {
KeyspaceName string
AllInterval TimeInterval
}
// NewCassandraDevops makes an CassandraDevops object ready to generate Queries.
func newCassandraDevopsCommon(dbConfig DatabaseConfig, start, end time.Time) QueryGenerator {
if !start.Before(end) {
panic("bad time order")
}
return &CassandraDevops{
KeyspaceName: dbConfig["database-name"],
AllInterval: NewTimeInterval(start, end),
}
}
// Dispatch fulfills the QueryGenerator interface.
func (d *CassandraDevops) Dispatch(i, scaleVar int) Query {
q := NewCassandraQuery() // from pool
devopsDispatchAll(d, i, q, scaleVar)
return q
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteOneHost(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 1, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteTwoHosts(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 2, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteFourHosts(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 4, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteEightHosts(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 8, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteSixteenHosts(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 16, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageHourByMinuteThirtyTwoHosts(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 32, time.Hour)
}
func (d *CassandraDevops) MaxCPUUsage12HoursByMinuteOneHost(q Query, scaleVar int) {
d.maxCPUUsageHourByMinuteNHosts(q.(*CassandraQuery), scaleVar, 1, 12*time.Hour)
}
func (d *CassandraDevops) MaxCPUUsageDayByHour(q Query, scaleVar int) {
}
// MaxCPUUsageHourByMinuteThirtyTwoHosts populates a Query with a query that looks like:
// SELECT max(usage_user) from cpu where (hostname = '$HOSTNAME_1' or ... or hostname = '$HOSTNAME_N') and time >= '$HOUR_START' and time < '$HOUR_END' group by time(1m)
func (d *CassandraDevops) maxCPUUsageHourByMinuteNHosts(qi Query, scaleVar, nhosts int, timeRange time.Duration) {
interval := d.AllInterval.RandWindow(timeRange)
nn := rand.Perm(scaleVar)[:nhosts]
tagSets := [][]string{}
tagSet := []string{}
for _, n := range nn {
hostname := fmt.Sprintf("host_%d", n)
tag := fmt.Sprintf("hostname=%s", hostname)
tagSet = append(tagSet, tag)
}
tagSets = append(tagSets, tagSet)
humanLabel := fmt.Sprintf("Cassandra max cpu, rand %4d hosts, rand %s by 1m", nhosts, timeRange)
q := qi.(*CassandraQuery)
q.HumanLabel = []byte(humanLabel)
q.HumanDescription = []byte(fmt.Sprintf("%s: %s", humanLabel, interval.StartString()))
q.AggregationType = []byte("max")
q.MeasurementName = []byte("cpu")
q.FieldName = []byte("usage_user")
q.TimeStart = interval.Start
q.TimeEnd = interval.End
q.GroupByDuration = time.Minute
q.TagSets = tagSets
}
// MeanCPUUsageDayByHourAllHosts populates a Query with a query that looks like:
// SELECT mean(usage_user) from cpu where time >= '$DAY_START' and time < '$DAY_END' group by time(1h),hostname
func (d *CassandraDevops) MeanCPUUsageDayByHourAllHostsGroupbyHost(qi Query, _ int) {
interval := d.AllInterval.RandWindow(24*time.Hour)
humanLabel := "Cassandra mean cpu, all hosts, rand 1day by 1hour"
q := qi.(*CassandraQuery)
q.HumanLabel = []byte(humanLabel)
q.HumanDescription = []byte(fmt.Sprintf("%s: %s", humanLabel, interval.StartString()))
q.AggregationType = []byte("avg")
q.MeasurementName = []byte("cpu")
q.FieldName = []byte("usage_user")
q.TimeStart = interval.Start
q.TimeEnd = interval.End
q.GroupByDuration = time.Hour
}
//func (d *CassandraDevops) MeanCPUUsageDayByHourAllHostsGroupbyHost(qi Query, _ int) {
// interval := d.AllInterval.RandWindow(24*time.Hour)
//
// v := url.Values{}
// v.Set("db", d.KeyspaceName)
// v.Set("q", fmt.Sprintf("SELECT count(usage_user) from cpu where time >= '%s' and time < '%s' group by time(1h)", interval.StartString(), interval.EndString()))
//
// humanLabel := "Cassandra mean cpu, all hosts, rand 1day by 1hour"
// q := qi.(*CassandraQuery)
// q.HumanLabel = []byte(humanLabel)
// q.HumanDescription = []byte(fmt.Sprintf("%s: %s", humanLabel, interval.StartString()))
// q.Method = []byte("GET")
// q.Path = []byte(fmt.Sprintf("/query?%s", v.Encode()))
// q.Body = nil
//}