Mysql replication

Replication lets you mirror all data written to a database to one or more others.
Generally, this is used for read-optimizations, but it is possible to use as a write-optimization.

NOTE:

much more information in my textbook, return as needed

Overview

Replication Types

logical: every sql statement is repeated on the slave database
row:     every row is replicated to the slave database

Replication works by:

• recording a binary log of events on the master
• copying the master's binary log to the slave's relay log
• the slave replays events from it's relay log