Skip to Main Content
Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency
book

Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

by Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala
May 2024
Intermediate to advanced content levelIntermediate to advanced
750 pages
12h 29m
English
Apress
Content preview from Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency
© 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
PostgreSQL 16 Administration Cookbook

PostgreSQL 16 Administration Cookbook

Gianni Ciolli, Boriss Mejías, Jimmy Angelakos, Vibhor Kumar, Simon Riggs

Publisher Resources

ISBN: 9798868802522Purchase LinkPublisher Website