Using Amazon ElasticSearch to Improve Performance when Querying Data in MySQL
Search tools have increasingly grown power and functionality over time and both users and companies have become more reliant on them to identify information and patterns quickly and efficiently. However, even the most robust search tool can experience issues when compiling information from large sets of data. This can be due to either complex relational database joins or the sheer volume of data a single query must parse through to identify the necessary information. Every industry experiences this at someRead more
Data Analytics Company Gains Performance and Reduces Cost by Switching from Microsoft SQL to AWS Redshift + Tableau.
Capturing data and utilizing it for business needs is a relatively easy thing to accomplish if done correctly. Analyzing the data to look for patterns and trends is an entirely different issue. When companies decide to implement deep analytics to drive decision making, often implementing the suite of reports can be a challenge. This was partially true for our client, a real-time data analytics company, who approached us to help them find a better way of performing big data analyticsRead more
Renewable Energy Company Migrates Entire Database from MySQL to Amazon Aurora – Gets Performance Boost for a Fraction of the Cost.
Companies have learned the value of Big Data and the need to capture as much information as they are able about their customer base. This often becomes a driving force in building out their database solution to house this growing amount of data. Although no one disagrees with the need to gather the data, how each organization chooses to house and grow the database tends to vary wildly from one company to the next. Navigating enterprise database solution providers isRead more
Amazon RDS is pretty cool!
I was playing around with Amazon RDS today. It’s a web service that makes it easy to set up, operate, and scale a relational database in the cloud. In other words, Amazon manages MySQL on the server level and you can connect to it via your application or a MySQL command line. You are also able to perform various database administration tasks via an Amazon API or using something like a RightScale management platform. Here are some of theRead more