MySQL Server (ii)

MySQL Server (ii)

#从服务器同步完成后Position也为1810650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M01/6E/0E/ Wkiol1vyucsgls00aad6qaxuqdg939.jpg "/>

#在主服务器新增一个ignoredb数据库, let's see if this database synchronization takes effect from the configuration

#在主服务器新增ignoredb数据库和表t4, D4 database and table T4

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/12/wKiom1VyuCXzJNifAAI9-5ArTHU991.jpg "/>

#可以看到从服务器已经将d4数据库同步过来, and ignore synchronizing the Ignoredb database

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/0E/wKioL1VyucWA9QPmAAEdHHVMhbw679.jpg "/>

#主从服务器Positon点一致

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/12/wKiom1VyuCXSnj5kAADIPQBPHC0092.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/0E/wKioL1VyucXA7z_VAAEAlTFoLcQ542.jpg "/>

4. Primary Master Synchronization

#待补充

5, a master more from

#待补充

6. Cluster

(1) Lvs+keepallive+mysql

#待补充

(2) Lvs+heartbeat+drbd+mysql cluster

#待补充

This article is from the "Love On Action" blog, please be sure to keep this source http://1055745601.blog.51cto.com/5003160/1659228

MySQL Server (ii)