High Availability of MariaDB dual-master N slave replication-Implementation of MMM Architecture

Source: Internet
Author: User

High Availability of MariaDB dual-master N slave replication-Implementation of MMM Architecture

1. MMM Overview
MMM (Master-Master replication manager for Mysql) is a flexible script program for monitoring and failover, manage the configuration of mysql Master-Master replication (only one node can be written at a time ). The attached tool suite can achieve read Load Balancing for multiple slaves. Therefore, you can use this tool to remove the virtual IP addresses of servers with high replication latency from a group of servers. It can also back up data, synchronization between two nodes.
The main features of MMM are implemented using the following three scripts:
Monitors the process, monitors all tasks, and determines and processes activities of all node roles.
The proxy process running on each mysql Server completes monitoring probe work and executes simple remote service settings.
A simple script that provides commands for managing the mmm_mond Process

Ii. experiment environment Introduction
The most basic MMM installation requires at least two database servers and one monitoring server. The following MySQL Cluster environment must contain three database servers and one monitoring server.
The experiment architecture is as follows:

Host planning table

Virtual VIP planning table:

Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)

Implementation of MariaDB Proxy read/write splitting

How to compile and install the MariaDB database in Linux

Install MariaDB database using yum in CentOS

Install MariaDB and MySQL

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu

Install MariaDB on the Ubuntu 14.04 (Trusty) Server

  • 1
  • 2
  • 3
  • Next Page

Related Article

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.