Case study overview
MySQL is a proven solution to store transactional data that is used to maintain ACID properties during write operations. Starting from MySQL 5.6, it also includes the new NoSQL Memcached
API for InnoDB, which improves performance for high volume data ingestion. Hadoop is used to store a huge amount of data (in petabytes) and processing it for many scenarios such as storing archived data or various historical data. Analytical processing of data was handled offline and was not an integrated part of the data processing. However, the technology has evolved and nowadays, Hadoop is an active part of data flows for many use cases where we require real-time data processing and provisioning of data to the user.
We can use MySQL to store the transnational data and Hadoop to store huge amount of data which can easily process the data using a map-reduce algorithm. We can take advantages of both technology to unlock the Big Data analysis. There are various use cases where we need to...