Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 4. MariaDB Replication

MariaDB replication is a mechanism that permits us to replicate data to another instance on another host. Replication is generally used for the following reasons:

  • Scale out reads: Replication permits scaling between several read databases to grow the read capacity

  • Providing high availability: With multiple slaves, you have no read Single Point Of Failure (SPOF)

  • Data analysis: Replication can be useful to have a replicated environment to allow querying without impacting the production environment

  • Disaster recovery: You can have a distant copy of a master if a major issue occurs on your primary site

  • Security: Replication can be used to add a read-only database on a DMZ for example

Replication works in an asynchronous mode, which means, if you have a low or degraded bandwidth, you will have a replication delta (slave late/with more delay) depending on your write load. The more write queries you have, the more information will need to be replicated and the faster...