use case: apollo group at oracle open world
TRANSCRIPT
![Page 2: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/2.jpg)
2
• Company Overview
• The Problem
• Approaching MongoDB?
• Results
![Page 3: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/3.jpg)
3
Company Overview
![Page 4: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/4.jpg)
4
• Founded in 1973
• Leading provider of higher education for working adults
• Parent company of – University of Phoenix
– Apollo Global
– Carnegie Learning
– College of Financial Planning
– Institute for Professional Development
• Educate over 350 thousand students per year
![Page 5: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/5.jpg)
5
The Problem
![Page 6: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/6.jpg)
6
• Scalability. We were unable to scale our current system to support the anticipated number of users and volume of content, which would increase significantly as we would add applications to the platform.
• Technology Fit. Much of the data targeted for the platform was semi-structured and thus not a natural fit with relational databases.
• Experience. We have experience in traditional databases with developing, maintaining, and defined processes but we don’t know how many of these skills can transfer to MongoDB.
![Page 7: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/7.jpg)
7
Approaching MongoDB?
![Page 8: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/8.jpg)
8
Implementing a new repository solution introduces new areas of needs such as:
• Plan and deploy a solution
• Operational procedures
• Designing object models
• Determine MongoDB Client and Frameworks
• Measuring effectiveness
![Page 9: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/9.jpg)
9
Conference 10gen Training 10gen
Consulting
Lab
Env.
Run Book
(Deploy)X X X
Run Book
(Maintenance)X X X
Object Model X X X X
Measure
EffectivenessX
Java Client X
![Page 10: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/10.jpg)
10
The Results
![Page 11: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/11.jpg)
11
• MongoDB Farm Architecture
• Chef/Puppet Scripts to
– Deploy new farm
– Add replication sets
• Monitor Servers
• High Avail.
• Disaster Recoverability
![Page 12: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/12.jpg)
12
• Analyze our Data*
– Application API review
– Performance
– Call Type
– Query/Data Usage
• Small Scope
* One of the pearls discovered
![Page 13: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/13.jpg)
13
SQL ID Executions Percentage
15,572,099 46%
4,339,293 13%
3,232,297 10%
3,016,176 9%
2,541,686 8%
2,485,334 7%
2,384,839 7%
![Page 14: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/14.jpg)
14
Configuration Results
A: Clients on Same
Machine
Typical Response Time: 0-1.7 ms
Maximum Throughput: 9,000 queries/sec CPU-bound.
Typical CPU Utilization: 100%
B: Clients and
MongoDB on
Separate Amazon
Typical Response Time: 1.2-8.5 ms
Maximum Throughput: 12,000 queries/sec
Typical CPU Utilization: 80%
C: Clients and
MongoDB in
Separate
Availability Zones,
but within One
Amazon EC2
Region
Typical Response Time: 1.2-10.6 ms
Maximum Throughput: 12,200 queries/sec
Typical CPU Utilization: 85%
Approximately the same response time, throughput, and CPU
utilization as Configuration B.
D: Clients and
MongoDB in
Different Amazon
EC2 Regions
Typical Response Time: 85.6-87.3 ms.
Maximum Throughput: 1,600 queries/sec
Typical CPU Utilization: 2%. Very low; EC2 instance was
unstressed.
East coast-west coast network was bottleneck in this
configuration – EC2 instances were not stressed. Response
times were much higher than when instances were located
within a single Amazon EC2 region (configurations B & C).
![Page 15: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/15.jpg)
15
• Data driven Data Model
• Data driven deployment architecture
• Hybrid deployment are possible (Cloud, on premise)
• High latency between EC2 regions
• 85% CPU Mongo behavior changes
Primary
Secondary• Operations/Developer/DBA trained
• Roadmap Development/operations/
![Page 16: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/16.jpg)
16
Questions
![Page 17: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/17.jpg)
17
End
![Page 18: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/18.jpg)
18
Appendix
![Page 19: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/19.jpg)
19
Local Client
![Page 20: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/20.jpg)
20
Same Zone
![Page 21: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/21.jpg)
21
Same Region
![Page 22: Use Case: Apollo Group at Oracle Open World](https://reader033.vdocuments.us/reader033/viewer/2022042716/55a691e11a28ab5b4d8b4663/html5/thumbnails/22.jpg)
22
Two Regions