38

MySQL主从(介绍,配置主机,配置从机,测试主从同步)-13397306-51CTO博客

 6 years ago
source link: http://blog.51cto.com/13407306/2067289
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
一、介绍及准备工作1.介绍MySQL主从配置又叫Replication或者AB复制,简单讲就是A和B两台机器做主从后,在A上写数据,另一台B也会跟着写数据,两台数据实时同步。MySQL主从是基于binlog的,主上须开启binlog才能进行主从。主从过程大致有3个步骤主将更改操作记录到Binlog里从将主的Binlog事件(sql语句)同步到从本机上并记录在relaylog里从根据relaylog

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK