Book Image

MySQL 8 for Big Data

By : Shabbir Challawala, Chintan Mehta, Kandarp Patel, Jaydip Lakhatariya
Book Image

MySQL 8 for Big Data

By: Shabbir Challawala, Chintan Mehta, Kandarp Patel, Jaydip Lakhatariya

Overview of this book

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.
Table of Contents (17 chapters)
Title Page
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

Chapter 8. NoSQL API for Integrating with Big Data Solutions

In the previous chapter, we looked at best practices for MySQL 8 that we should follow in various aspects such as performance, implementation, security, and so on. Best practices always align the product with the industry standard and also give a good output. We have seen different best practices for different phases like Benchmark and Configuration, which detail configuration parameters to provide better benchmark results. Best practices for queries helps in designing complex queries and providing better performance. Best practices for Memcached need to be maintained while implementing caching mechanisms. The valid replication configuration will always result in better scalability and can provide better performance with low latency.

This chapter talks about integrating MySQL 8 to work like NoSQL with the different APIs available. We will see how MySQL, an RDBMS, will work as NoSQL to handle big data. MySQL provides various APIs...