MySQL instance group with DNS and Mha/zabbix architecture:
DNS build:http://www.cnblogs.com/jiangxu67/p/4801230.html
MHA Analysis:http://www.cnblogs.com/jiangxu67/p/4487248.html
The general idea is the front-end application and the database through the domain name resolution, the domain name through the BIND Service database preservation, MHA and Zabbix respectively to the instance cluster main library and from the library carries on the detection and the management.
MHA:
Only the main library is detected, when there is an exception in the Mha_manager managed main Library, according to its own configuration file from the library data to check and match, select the new main library on-line, the other from the library and the new Main library to establish a replication relationship. In the new main library on-line link can add Perl code, the DNS data inside the exception of the main library offline and the new main library on-line action.
ZABBIX:
"MySQL" DNS with Mha/zabbix built for highly available MySQL