MySQLMMM high availability solution

Source: Internet
Author: User
In mysql, a single point of failure (SPOF: Singlepointoffailure) may occur in a simple mysql Master/Slave configuration. This fatal problem can be avoided through the mysqlMMM project. What is mysqlMMM? The official explanation is as follows. It is very interesting: Whenyoueatsomethingtasty, yousay: Mmm. sometimesmmmmmorhm

In mysql, a Single point of failure (SPOF: Single pointof failure) occurs in a simple mysql Master/Slave configuration. This fatal problem can be avoided through the mysql MMM project. What is mysql MMM? The official explanation is as follows. It is very interesting When you eat something tasty, you say: Mmm. Sometimes Mmmmmmm or Hm

In mysql, a Single point of failure (SPOF: Single pointof failure) occurs in a simple mysql Master/Slave configuration. This fatal problem can be avoided through the mysql MMM project.

What is mysql MMM? The official explanation is as follows, which is very interesting.

When you eat something tasty, you say: "Mmm ...". Sometimes "Mmmmmmm "... Or "HmMMmmmmm"-but we decided to go with just simplyMMM.

(From # mmm on freenode)

Interesting !! It is the voice we make when eating, and foreigners are interesting.

Role of mysql MMM

Solve the SPOF problem and manage or fail over the mysql of the master-master architecture to ensure that a node is available at any time. This tool set can read the configuration of balanced master/slave and provide virtual ip addresses after replication to solve the spof problem.

Iii. Availability

Official notes: the current version is stable. Some Internet companies are also using this tool set in China.

For configuration 4, refer to the official website. The configuration is simple. If you have configured replication, I believe this can be done smoothly. However, in the official case, five machines are used, a little more. You can also use two machines.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.