MySQL Cascade + Dual Master Scenario

#####################################################

This article is from "Old boy Linux operation and maintenance training" students-xudong he

If reproduced, please be sure to keep this article link and this content copyright information.

Welcome to the vast number of operations and colleagues to Exchange Linux/unix website operation and Maintenance technology!

qq:345078833

E-mail:345078833qq.com

#####################################################

Old boy Linux OPS training Center

Training consultation: qq:80042789 70271111

Training Tel: 18600338340 18911718229

Old boy teacher qq:49000448 31333741

Website address: http://www.etiantian.org

Old boy Blog: http://oldboy.blog.51cto.com

old boy Exchange Group 246054962 208160987 226199307 44246017

Website operation and Maintenance Exchange Group: 114580181 45039636 37081784
#####################################################

650) this.width=650; "style=" WIDTH:707PX;HEIGHT:279PX; "title=" Cascade mysql.jpg "alt=" Wkiol1uqiszrc4muaagu0xhlkig704.jpg "src=" http://s3.51cto.com/wyfs02/M02/60/5D/ Wkiol1uqiszrc4muaagu0xhlkig704.jpg "width=" 780 "height=" 297 "/>

Mysqlbinlog Three modes of description:

Statement Level Mode

Cons: Statement-level replication, general Internet company, no triggers, no stored procedures, or replication failures occur. and different steps. For example, the sleep () function does not replicate correctly in some versions.

Pros: There is no need to record changes in each row of data. Change to 1 million lines

Row Lovel mode (row mode)

Pros: If you execute update one statement 1000 then a sentence will be recorded in the Binlog. Replication is fully functional. The calls to stored procedures, triggers, and trigger are well-used.

Disadvantage: It causes a master-slave delay.

mixecl mode (mixed mode)

The combination of the first two modes. If there is a need, use a function, stored procedure, trigger, in this mode.

650) this.width=650; "style=" width:715px;height:280px; "title=" dual master scheme mysql.jpg "src=" http://s3.51cto.com/wyfs02/M01/ 60/84/wkiom1uqjs7spvmfaafn9f4atjg425.jpg "width=" 863 "height=" 299 "alt=" wkiom1uqjs7spvmfaafn9f4atjg425.jpg "/>

Between the two master to change the master a bit ...

This article from the "Clear Sky" blog, declined reprint!

MySQL Cascade + Dual Master Scenario