Benchmark- MySQL RDS (cloud and onpremise) and ElasticSearch
Customers
American Airlines, General Electric
Description
A number of enhancements of Germain when using ElasticSearch as its datastore, enhancements mostly around:
Aggregation
Performance (Filtering, Search and Drillthrough significantly faster with ElasticSearch compared with relational db)
Ops Dashboard - 7 days (300 Million metrics /day) | MySQL RDS AWS cloud | Mysql RDS on-Premise | Elastic AWS Cloud |
Applications Tab | 40s | 28.19s | 21.7s |
App Comp Tab | 9s | 20.82s | 25.08s |
Database Tab | 16.5s | 16.04s | <1s |
Environments Tab | 8s | 15.48s | 20.16s |
Hosts Tab | 8.8s | 16.0s | 22.21s |
Services Tab | <1s | 2.98s | <1s |
BP Tab | <1s | <1s | <1s |
Users Tab | 7.14s | 13.27s | 12.54s |
Drillthrough 7 days | |||
User Click, no filter | <1s | <1s | 1-2s |
User Click, sort by duration | >5min | <1min | 1-2s |
User Click, filter by username | 15s | <10s | <1s |
Siebel SQL Queries, no filter | 1s | <1s | <3s |
Siebel SQL Queries, sort by duration | >5min | 1-2s | 1-2s |
Siebel SQL Queries, filter by query ID | >5min | >3min | <1s |