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

About the Authors

Shabbir Challawala has over 8 years of rich experience in providing solutions based on MySQL and PHP technologies. He is currently working with KNOWARTH Technologies. He has worked in various PHP-based e-commerce solutions and learning portals for enterprises. He has worked on different PHP-based frameworks, such as Magento E-commerce, Drupal CMS, and Laravel.

Shabbir has been involved in various enterprise solutions at different phases, such as architecture design, database optimization, and performance tuning. He has been carrying good exposure of Software Development Life Cycle process thoroughly. He has worked on integrating Big Data technologies such as MongoDB and Elasticsearch with a PHP-based framework.

I am sincerely thankful to Chintan Mehta for showing confidence in me writing this book. I would like to thank KNOWARTH Technologies for providing the opportunity and support to be part of this book. I also want to thank my co-authors and PacktPub team for providing wonderful support throughout. I would especially like to thank my mom, dad, wife Sakina, lovely son Mohammad, and family members for supporting me throughout the project.

Jaydip Lakhatariya has rich experience in portal and J2EE frameworks. He adapts quickly to any new technology and has a keen desire for constant improvement. Currently, Jaydip is associated with a leading open source enterprise development company, KNOWARTH Technologies (www.knowarth.com), where he is engaged in various enterprise projects.

Jaydip, a full-stack developer, has proven his versatility by adopting technologies such as Liferay, Java, Spring, Struts, Hadoop, MySQL, Elasticsearch, Cassandra, MongoDB, Jenkins, SCM, PostgreSQL, and many more.

He has been recognized with awards such as Merit, Commitment to Service, and also as a Star Performer. He loves mentoring people and has been delivering training for Portals and J2EE frameworks.

I am sincerely thankful to my splendid co-authors, and especially to Mr. Chintan Mehta, for providing such motivation and having faith in me. I would like to thank KNOWARTH for constantly providing new opportunities to help me enhance myself. I would also like to appreciate the entire team at Packt Publishing for providing wonderful support throughout the project. Finally, I am utterly grateful to my parents and my younger brother Keyur, for supporting me throughout the journey while authoring. Thank you my friends and colleagues for being around.

 

Chintan Mehta is the co-founder at KNOWARTH Technologies (www.knowarth.com) and heads Cloud/RIMS/DevOps. He has rich progressive experience in Systems and Server Administration of Linux, AWS Cloud, DevOps, RIMS, and Server Administration on Open Source Technologies. He is also an AWS Certified Solutions Architect-Associate.

Chintan's vital role during his career in Infrastructure and Operations has also included Requirement Analysis, Architecture design, Security design, High-availability and Disaster recovery planning, Automated monitoring, Automated deployment, Build processes to help customers, performance tuning, infrastructure setup and deployment, and application setup and deployment. He has also been responsible for setting up various offices at different locations, with fantastic sole ownership to achieve Operation Readiness for the organizations he had been associated with.

He headed Managed Cloud Services practices with his previous employer and received multiple awards in recognition of very valuable contributions made to the business of the group. He also led the ISO 27001:2005 implementation team as a joint management representative. Chintan has authored Hadoop Backup and Recovery Solutions and reviewed Liferay Portal Performance Best Practices and Building Serverless Web Applications.

He has a Diploma in Computer Hardware and Network from a reputed institute in India.

I have relied on many people, both directly and indirectly, in writing this book. First, I would like to thank my co-authors and the wonderful team at PacktPub for this effort. I would like to especially thank my wonderful wife, Mittal, and my sweet son, Devam, for putting up with the long days, nights, and weekends when I was camped out in front of my laptop. Many people have inspired and made contributions to this book and provided comments, edits, insights, and ideas, especially Krupal Khatri and Chintan Gajjar. There were several things that could have interfered with my book. I also want to thank all the reviewers of this book. Last, but not the least, I want to thank my mom and dad, friends, family, and colleagues for supporting me throughout the writing of this book.

 

 

Kandarp Patel leads PHP practices at KNOWARTH Technologies (www.knowarth.com). He has vast experience in providing end-to-end solutions in CMS, LMS, WCM, and e-commerce, along with various integrations for enterprise customers. He has over 9 years of rich experience in providing solutions in MySQL, MongoDB, and PHP-based frameworks. Kandarp is also a certified MongoDB and Magento developer.

Kandarp has experience in various Enterprise Application development phases of the Software Development Life Cycle and has played prominent role in requirement gathering, architecture design, database design, application development, performance tuning, and CD/CI.

Kandarp has a Bachelor of Engineering in Information Technology from a reputed university in India.

I would like to acknowledge Chintan Mehta for guiding me through the various stages of the roller-coaster ride while writing the book. I would like to thank KNOWARTH Technologies for providing me the opportunity to be a part of this book. I would also like to thank my splendid co-authors and PacktPublishing team for providing wonderful support throughout the journey. Last, but not the least, I want to thank my mom and dad, and my wife Jalpa, for continuously supporting and encouraging me throughout the writing of the book. I dedicate my first book to my lovely princesses, Jayna and Jaisvi.