Combine the powers of MySQL and Hadoop to build a solid Big Data solution for your organization
Integrate MySQL with different NoSQL APIs and Big Data tools such as Apache Sqoop
A comprehensive guide with practical examples on building a high performance Big Data pipeline with MySQL
Book Description
With organizations handling large amounts of data on a regular basis, MySQL has become a popular solution to handle this structured Big Data. In this book, you will see how DBAs can use MySQL 8 to handle billions of records, and load and retrieve data with performance comparable or superior to commercial DB solutions with higher costs.
Many organizations today depend on MySQL for their websites and a Big Data solution for their data archiving, storage, and analysis needs. However, integrating them can be challenging. This book will show you how to implement a successful Big Data strategy with Apache Hadoop and MySQL 8. It will cover real-time use case scenario to explain integration and achieve Big Data solutions using technologies such as Apache Hadoop, Apache Sqoop, and MySQL Applier. Also, the book includes case studies on Apache Sqoop and real-time event processing.
By the end of this book, you will know how to efficiently use MySQL 8 to manage data for your Big Data applications.
What you will learn
Explore the features of MySQL 8 and how they can be leveraged to handle Big Data
Unlock the new features of MySQL 8 for managing structured and unstructured Big Data
Integrate MySQL 8 and Hadoop for efficient data processing
Perform aggregation using MySQL 8 for optimum data utilization
Explore different kinds of join and union in MySQL 8 to process Big Data efficiently
Accelerate Big Data processing with Memcached
Integrate MySQL with the NoSQL API
Implement replication to build highly available solutions for Big Data
Who this book is for
This book is intended for MySQL database administrators and Big Data professionals looking to integrate MySQL 8 and Hadoop to implement a high performance Big Data solution. Some previous experience with MySQL will be helpful, although the book will highlight the newer features introduced in MySQL 8.
Table of Contents
Introduction to Big Data & MySQL 8
Data query techniques in MySQL8
Indexing your data for high performing query
Using Memcached with MySQL8
Partitioning High Volume Data
Using Replication for building highly available solution
MySQL 8 Best Practices
NoSQL API for Integrating with Big Data Solutions
Apache Sqoop for Exchanging Data between Mysql and Hadoop