
- 266 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
MySQL 8 for Big Data
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
- 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.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Title Page
- Copyright
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Customer Feedback
- Preface
- Introduction to Big Data and MySQL 8
- Data Query Techniques in MySQL 8
- Indexing your data for High-Performing Queries
- Using Memcached with MySQL 8
- Partitioning High Volume Data
- Replication for building highly available solutions
- MySQL 8 Best Practices
- NoSQL API for Integrating with Big Data Solutions
- Case study: Part I - Apache Sqoop for exchanging data between MySQL and Hadoop
- Case study: Part II - Real time event processing using MySQL applier