Replication Tutorial Presentation.pdf

(747 KB) Pobierz
MySQL
Replication
Tutorial
Mats Kindahl
Senior Software Engineer
Replication Technology
Lars Thalmann
Development Manager
Replication/Backup
Tutorial Outline
Terminology and Basic Concepts
Basic Replication
Replication for scale-out
Replication for high-availability
The binary log
Statements and transactions
Cluster Replication
Terminology and
Basic Concepts
MySQL Replication
Why?
High availability
Fail-over possible
How?
Snapshots
Backup
mysqlbinlog
mysqldump
Scale-out
Queries on many
servers
Off-site processing
Do not disturb master
Reporting
Binary log
Replication
Point-in-time
recovery
Server
Terminology
Master server
Changes data
Keeps log of changes
Master
Slave server
Ask master for events
Executes events
Replication
Binary log
Log every change
Split into transactional groups
Slave

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin