Key FeaturesCombine the powers of MySQL and Hadoop to build a solid Big Data solution for your organizationIntegrate MySQL with different NoSQL APIs and Big Data tools such as Apache SqoopA comprehensive guide with practical examples on building a high performance Big Data pipeline with MySQLBook DescriptionWith 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 learnExplore the features of MySQL 8 and how they can be leveraged to handle Big DataUnlock the new features of MySQL 8 for managing structured and unstructured Big DataIntegrate MySQL 8 and Hadoop for efficient data processingPerform aggregation using MySQL 8 for optimum data utilizationExplore different kinds of join and union in MySQL 8 to process Big Data efficientlyAccelerate Big Data processing with MemcachedIntegrate MySQL with the NoSQL APIImplement replication to build highly available solutions for Big DataAbout the AuthorShabbir 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.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, 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.Chintan Mehta is the co-founder at KNOWARTH Technologies 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.Chintans 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.Kandarp Patel leads PHP practices at KNOWARTH Technologies. 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.Table of ContentsIntroduction to Big Data & MySQL 8Data query techniques in MySQL8Indexing your data for high performing queryUsing Memcached with MySQL8Partitioning High Volume DataUsing Replication for building highly available solutionMySQL 8 Best PracticesNoSQL API for Integrating with Big Data SolutionsApache Sqoop for Exchanging Data between Mysql and HadoopRealtime event processing using MySQL applier