什麼是 MySQL Master-Master Replication Manager(MMM)?

  • MMM (MySQL Master-Master Replication Manager) 是整合 Script 做 監控/管理 MySQL Master-Master replication cluster 的設定配置.
  • Master-Master 的意思不是同時有兩台 Master 應付寫入的動作, 而是要做備援, 若 Master 死掉, 可於最短的時間內(幾秒內), 將備援的 Master 替換上線, 而這台備援的 Master, 平常也可以當 Slave (Reader).
  • 當 Slave 的 Replication Failed 時, 會自動讓此 Slave 停止提供服務, 避免不同步的狀況發生.
  • MMM 可解決 Master 死掉時, 需要停機或停止所有寫入的問題.

本日志由 flyinweb 于 2009-09-21 14:13:07 发表到 数据库技术 中,目前已经被浏览 4099 次,评论 0 次;

作者添加了以下标签: ReplicationMaster-Master Replication ManagerMMM

首页只显示了部分日志内容,要查看日志的全部内容请阅读全文

Despite of my high load at work I decided to release mmm-1.0-pre2 today. There are some small, but critical fixes added and much more coming next week (or little bit later if mysqlconf will take more time than I think).

After the first alpha release I’ve received lots of emails, some messages in mmm-devel mail list and even some bug reports in Google Code bug tracking. One of the most asked things was documentation. ;-) So, I decided to write some posts in this blog (sorry to non-sql-related readers) and them compose some docs for final release using these posts and comments from readers. This post will be first in mmm-series and will describe how to use mmm in simple master+master scheme where one master accept write requests and both masters accept read requests. This post will provide you with detailed instructions about MySQL setup, permissions setting, mmm installation and configuration and cluster management.

本日志由 flyinweb 于 2009-09-21 11:42:55 发表到 数据库技术 中,目前已经被浏览 3967 次,评论 0 次;

作者添加了以下标签: Master-Master ReplicationMMM

首页只显示了部分日志内容,要查看日志的全部内容请阅读全文