马哥linux的ppt,包合集马哥linux-2016全新专用ppt mysql replication.pdf

MySQL Replication

MySQL Replication

Include MySQL 5.6

主讲：马永亮(马哥)

分片标准：

用户名

2

3

4

冗余，异地灾备

读、写分离

master: 读/写

sl e: 读

ipvs、haproxy

升级测试

blackhole

5

6

7

server-id

binlog relay log binlog relay log

8

TID

GTID

UUID

9

MySQL Replication

Common Use Cases

More Advanced Use Cases

MySQL 5.6 Advanced Replication Features

MySQL Utilities

Summary

10

What is Replication?

What is Replication?

For the purposes of this paper we define “replication”

as the duplication of data to one or more locations

These can be co-located within a data center, or

geographically distributed

Replication enables a database to copy or duplicate

changes from one physical location or system to

another

11

Replication

Replication

 Happens at MySQL level, not Storage EngineLevel(*NDB)

 Asynchronous!(Semi-sync ailablein5.5)

 A server can h e only 1 master

 IO Thread: Fetches from master

 SQL Thread: Executes on sl