THE CHALLENGE
The client needed to improve customer visibility into usage, billing, and service performance on AWS cloud. They faced lengthy and time-consuming data queries. When processing customer logs, it took more than eight hours to produce one report using an unoptimized process. Limited resources caused frequent system crashes, and processing a large number of small files created system overhead that skyrocketed job execution times.
EveryIT HELPS LEVERAGE FULL AWS ANALYTICS PORTFOLIO
EveryIT’s data experts worked with the client to implement ConvergDB, a EveryIT open source software, to create a data structure that would better utilize cloud resources. This created an optimal file format to reduce query times without increasing bandwidth. The tool helped to create scripts that were used to build and manage the necessary resources in AWS cloud.
THE BENEFITS
- Increased query performance with analytics shared between business groups
- Full use of the AWS Analytics portfolio
- Enabled cost control and utilization of compute and storage resources
- Efficient access to data logs on application servers for increased transparency to customer