© Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala 2024
Y. V. Ravi Kumar et al.Mastering MySQL Administrationhttps://doi.org/10.1007/979-8-8688-0252-2_5

5. MySQL High Availability, Replication, and Scalability

Y V Ravi Kumar1  , Arun Kumar Samayam2 and Naresh Kumar Miryala3
(1)
Irving, TX, USA
(2)
Dallas, TX, USA
(3)
Tracy, CA, USA
 

Introduction

Replication is a technology to copy data from one MySQL database server to another asynchronously. Using MySQL replication options, you can replicate all databases, selected databases, or even selected tables, depending on your use case.

Some of the common use cases for replication are as follows:

  • Scale-out solutions

  • Data security

  • Analytics and reporting

  • Long-distance data distribution

MySQL 8.0 offers two methods ...

Get Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial