# Elula & Overmind2 Investigation

**@Deployable**
Purpose of Elula (https://elula.mindvalley.com):
- Access Logic: https://github.com/mindvalley/academy2
- DB Schema Performance: http://45.79.216.162/elula (username=pghero;password=ForKarma)
- Potential mechanism: Have a look at Percona's SQL optimatization guide
- DataDog Dashboards:
- Web 1: https://app.datadoghq.com/dash/host/1053103600?from_ts=1571215925130&to_ts=1573807925130&live=true&tile_size=m
- PG Master: https://app.datadoghq.com/dash/host/1081784409?from_ts=1573203155346&to_ts=1573807955346&live=true&tile_size=m
- Redis: https://app.datadoghq.com/dash/host/1084708670?from_ts=1573635181642&to_ts=1573807981642&live=true&tile_size=m
- Relationship:
- 1 Academy has many courses that can be shared with many Acadamies.
- Potential mechanism: build out an on-the-fly schema diagram, profile query associated to the load
- Content Ownership: Product & Development
- Houses all our courses
- Potential mechanism: could be loaded into memory, find out the size of courses (p50, p75, p99)
- Active Instance Period:
- 6a.m. GMT+8
- Potential mechnasim: listen to TCP/UDP calls, dtrace to inspect network calls, sysdig process inspector -> events to HC

***Estimated Time to RCA***: 1 week