Database Reference
In-Depth Information
on the average CPU utilization of allocated virtual machines for the database server
as follows: scale out the database tier (add one more replica) when the average CPU
utilization of the virtual machines exceeds of 75% for ( R1 ) and 85% for ( R2 ) over a
continuous period of 5 minutes. Two other rules are defined based on the percentage
of the SLA satisfaction of the workload transactions (the SLA values of the differ-
ent transactions are defined as specified in the Cloudstone benchmark) as follows:
scale out the database tier when the percentage of SLA satisfaction is less than 97%
for ( R3 ) and 90% for ( R4 ) over a continuous period of 5 minutes. Our evaluation
metrics are the overall percentage of SLA satisfaction and the number of provisioned
database replicas during the experimental time.
Figure 11.11 illustrates the results of running our experiments over a period of one
hour for the 80/20 workload (Figure 11.11a) and the 50/50 workload (FigureĀ 11.11b).
100
R1
R2
R3
R4
95
90
85
80
75
70
00:05 00:05 00:10 00:15 00:20 00:25 00:30 00:35 00:40 00:45 00:50 00:55 01:00
Time
(a)
100
R1
R2
R3
R4
95
90
85
80
75
70
00:05 00:05 00:10 00:15 00:20 00:25 00:30 00:35 00:40 00:45 00:50 00:55 01:00
Time
(b)
FIGURE 11.11 Comparison of SLA-based vs. resource-based database provisioning rules.
(a) Workload: 80/20 (r/w). (b) Workload: 50/50 (r/w).
Search WWH ::




Custom Search