MySQL 8 for Big Data
  1. 266 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

About this book

Uncover the power of MySQL 8 for Big Data

Key Features

  • 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.

]]>

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access MySQL 8 for Big Data by Shabbir Challawala, Chintan Mehta, Kandarp Patel, Jaydip Lakhatariya in PDF and/or ePUB format, as well as other popular books in Ciencia de la computación & Modelado y diseño de datos. We have over one million books available in our catalogue for you to explore.

Table of contents

  1. Title Page
  2. Copyright
  3. Credits
  4. About the Authors
  5. About the Reviewers
  6. www.PacktPub.com
  7. Customer Feedback
  8. Preface
  9. Introduction to Big Data and MySQL 8
  10. Data Query Techniques in MySQL 8
  11. Indexing your data for High-Performing Queries
  12. Using Memcached with MySQL 8
  13. Partitioning High Volume Data
  14. Replication for building highly available solutions
  15. MySQL 8 Best Practices
  16. NoSQL API for Integrating with Big Data Solutions
  17. Case study: Part I - Apache Sqoop for exchanging data between MySQL and Hadoop
  18. Case study: Part II - Real time event processing using MySQL applier