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

Memcached replication configuration


In a simple word, replication is the copying of data from one server to one or more servers. Replication enables the spreading of the load to multiple servers, which improves the performance and decreases the chances of data corruption, as the data is distributed among various servers. MySQL 8 supports different replication methods but the traditional method is to replicate through binary logs of the master server. A binary log is a file that collects all the statements that attempt to change the table data. These statements will be executed on the slave servers to replicate the master data.

The daemon_memcached plugin has the capability to manage the binary log on the master server, and the same can be used for replication on slave servers. All Memcached commands are supported by binary logging.

Follow these steps to enable the binary log replication in MySQL 8:

  1. During the startup of the server, add the --innodb_api_enable_binlog=1 and --log-bin system variables...