(Load Sharing) (MYSQL) database write multiple read experiment

Four virtual machines

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/99/77/wKioL1lIvNmjKJ7OAAMiAURuImg967.png "style=" float : none; "title=" 1.png "alt=" Wkiol1livnmjkj7oaamiauruimg967.png "/>

Master and slave Configuration please check the previous MySQL read-write separation reference document, here no longer repeat.

Detailed description of the amoeba configuration file writing:

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M02/99/77/wKioL1lIvN3QAj0rAARAcDIYnZM074.png "style=" float : none; "title=" 2.png "alt=" Wkiol1livn3qaj0raaracdiynzm074.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/99/77/wKiom1lIvOLA_0RjAASN9nzudnk153.png "style=" float : none; "title=" 3.png "alt=" Wkiom1livola_0rjaasn9nzudnk153.png "/>

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/99/77/wKioL1lIvOXBXGvIAARYyCa_4gw442.png "style=" float : none; "title=" 4.png "alt=" Wkiol1livoxbxgviaaryyca_4gw442.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/99/77/wKiom1lIvOnQ2xp3AAQf75vE1Yo958.png "style=" float : none; "title=" 5.png "alt=" Wkiom1livonq2xp3aaqf75ve1yo958.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/99/77/wKioL1lIvOqCRJFIAAFPIu5fz70677.png "style=" float : none; "title=" 6.png "alt=" Wkiol1livoqcrjfiaafpiu5fz70677.png "/>

During the experiment, in order to test the internal running process of the service, the slave server shuts down, and then when slave is turned on, it will find Slave_sql_running:no

At this time need to/var/lib/mysql/master.info certification information file deleted, re-master to certification, and then open slave can!

This article is from the "Journey of Operations" blog, please be sure to keep this source http://ahscwy.blog.51cto.com/9853317/1940185

(Load Sharing) (MYSQL) database write multiple read experiment