如何安裝mysql-mmm

小編給大家分享一下如何安裝mysql-mmm，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

安裝mysql-mmm

1)安裝epel

相關(guān)文檔參見：http://fedoraproject.org/wiki/EPEL

rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm

2) monitor軟件安裝

 [root@localhost ~]# yum install –y mysql-mmm-monitor-*

包如下：

[root@localhost ~]# rpm -qa|grep mysql

mysql-mmm-monitor-2.2.1-1.el5

mysql-mmm-2.2.1-1.el5

mysql-5.0.77-4.el5_5.4

3）所在機器安裝(包括master,slave)

[root@localhost ~]# yum install –y -mmm-agent*

包如下：

[root@localhost ~]# rpm -qa|grep mysql

mysql-test-5.0.77-4.el5_5.4

mysql-mmm-agent-2.2.1-1.el5

mysql-5.0.77-4.el5_5.4

mysql-server-5.0.77-4.el5_5.4

mysql-devel-5.0.77-4.el5_5.4

mysql-bench-5.0.77-4.el5_5.4

mysql-mmm-2.2.1-1.el5

mysql-connector-odbc-3.51.26r1127-1.el5

配置文件

1)monitor配置文件

[root@localhost ~]# vi /etc/mysql-mmm/mmm_mon.conf

include mmm_common.conf

<monitor>

    ip                  127.0.0.1

    pid_path            /var/run/mysql-mmm/mmm_mond.pid

    bin_path            /usr/libexec/mysql-mmm

    status_path         /var/lib/mysql-mmm/mmm_mond.status

    ping_ips            172.16.71.128,172.16.71.130 #master,slave實際數(shù)據(jù)庫ip

    auto_set_online     60

</monitor>

<host default>

    monitor_user        mmm_monitor

    monitor_password    10jqka

</host>

Debug

2）通用的配置文件，在monitor及master,slave上放置的這個文件都一致

[root@localhost ~]# vi /etc/mysql-mmm/mmm_common.conf

active_master_role      writer

<host default>

    cluster_interface       eth0

    pid_path                /var/run/mysql-mmm/mmm_agentd.pid

    bin_path                /usr/libexec/mysql-mmm/

    replication_user        replicant

    replication_password    10jqka

    agent_user              mmm_agent

    agent_password          10jqka

</host>

<host db1>

    ip      172.16.71.128 #真實master數(shù)據(jù)庫ip

    mode    master

    peer    db2

</host>

<host db2>

    ip      172.16.71.130 #真實master數(shù)據(jù)庫ip

    mode    master

    peer    db1

</host>

#<host db3>

#    ip      192.168.100.51 #真實slave數(shù)據(jù)庫ip

#    mode    slave

#</host>

<role writer>

    hosts   db1, db2

    ips     172.16.71.253 #虛擬寫數(shù)據(jù)庫ip

    mode    exclusive

</role>

<role reader>

    hosts   db1, db2

    ips     172.16.71.251,172.16.71.252 #虛擬讀數(shù)據(jù)庫ip

    mode    balanced

</role>

3）master,slave配置文件

[root@localhost ~]# vi /etc/mysql-mmm/mmm_agent.conf

include mmm_common.conf

# The 'this' variable refers to this server. Proper operation requires

# that 'this' server (db1 by default), as well as all other servers, have the

# proper IP addresses set in mmm_common.conf.

this db1#如為第一臺master db則為db1如為第二臺則為db2與mmm_common.conf里的機器對應(yīng)

查看效果

1）啟動db1的相關(guān)服務(wù)

service mysqld start

service mysql-mmm-agent start

數(shù)據(jù)庫授權(quán)：所有數(shù)據(jù)庫的授權(quán)一致

GRANT REPLICATION CLIENT ON *.* TO 'mmm_monitor'@'172.16.71.%' IDENTIFIED BY '10jqka';

GRANT SUPER, REPLICATION CLIENT, PROCESS ON *.* TO 'mmm_agent'@'172.16.71.%'   IDENTIFIED BY '10jqka';

grant all on *.* to replicant@'172.16.71.%' identified by '10jqka';

flush privileges;

2）啟動monitor相關(guān)服務(wù)

service mysql-mmm-monitor start

查看狀態(tài)：

mmm_control show

把db1設(shè)置為online狀態(tài)：

mmm_control set_online db1

開放mmm_agentd端口9989

真實機器查看分配的vip地址

[root@localhost ~]# ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue

    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

    inet 127.0.0.1/8 scope host lo

    inet6 ::1/128 scope host

       valid_lft forever preferred_lft forever

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000

    link/ether 00:0c:29:ef:79:70 brd ff:ff:ff:ff:ff:ff

    inet 172.16.71.132/24 brd 172.16.71.255 scope global eth0

    inet 172.16.71.251/32 scope global eth0

    inet 172.16.71.253/32 scope global eth0

    inet6 fe80::20c:29ff:feef:7970/64 scope link

       valid_lft forever preferred_lft forever

主主（master-master）同步配置

1）172.16.71.132機器my.cnf

skip-name-resolve

server_id           = 132

set-variable = key_buffer_size=512M

set-variable = table_cache=32

set-variable = sort_buffer_size=32M

set-variable = read_buffer_size=32M

set-variable = max_connections=2100

set-variable = log_slow_queries=/var/lib/mysql/log/mysql-slow.log

set-variable = log_bin=/var/lib/mysql/log/mysql-bin

set-variable = long_query_time=1

set-variable = thread_concurrency=16

set-variable = tmp_table_size=4000000000

set-variable = slave_skip_errors=all

#replicate-ignore-db=mysql

#replicate-ignore-db=test 發(fā)覺加上這個ignore選項后會導(dǎo)致mmm接管出現(xiàn)點小問題不知道為什么

log-slave-updates

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=1

進入mysql配置設(shè)置為從

mysql> change master to master_host='172.16.71.128';

mysql>change master to master_user='repl';

mysql>change master to master_password='10jqka';

mysql>start slave

主（master）服務(wù)器配置：

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'172.16.71.%' IDENTIFIED BY '10jqka';

2）172.16.71.128機器my.cnf配置

skip-name-resolve

server_id           = 1

set-variable = key_buffer_size=512M

set-variable = table_cache=32

set-variable = sort_buffer_size=32M

set-variable = read_buffer_size=32M

set-variable = max_connections=2100

set-variable = log_slow_queries=/var/lib/mysql/log/mysql-slow.log

set-variable = log_bin=/var/lib/mysql/log/mysql-bin

set-variable = long_query_time=1

set-variable = thread_concurrency=16

set-variable = tmp_table_size=4000000000

set-variable = slave_skip_errors=all

#replicate-ignore-db=mysql

#replicate-ignore-db=test

log-slave-updates

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=2

進入mysql配置設(shè)置為從

mysql> change master to master_host='172.16.71.132';

mysql>change master to master_user='repl';

mysql>change master to master_password='10jqka';

mysql>start slave

主（master）服務(wù)器配置：

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'172.16.71.%' IDENTIFIED BY '10jqka';

其它從(slave)服務(wù)器配置：

my.cnf配置

skip-name-resolve

server_id           = 1

set-variable = key_buffer_size=512M

set-variable = table_cache=32

set-variable = sort_buffer_size=32M

set-variable = read_buffer_size=32M

set-variable = max_connections=2100

set-variable = log_slow_queries=/var/lib/mysql/log/mysql-slow.log

set-variable = log_bin=/var/lib/mysql/log/mysql-bin

set-variable = long_query_time=1

set-variable = thread_concurrency=16

set-variable = tmp_table_size=4000000000

set-variable = slave_skip_errors=all

mysql>change master to master_host='172.16.71.253';

mysql>change master to master_user='repl';

mysql>change master to master_password='10jqka';                           mysql>change master to master_log_file=&rsquo;mysql-bin.00001&rsquo;;

mysql>change master to master_log_pos=128;                                mysql>start slave

或者在my.cnf加入

server-id=2

master-host=172.16.71.253

master-user=repl

master-password=10jqka

問題1：

兩臺機器互為對方的主，此時不能使用master的VIP作為該兩機器的主，如果使用VIP作為master的話沒有一臺先起來作為vip機器的話些會導(dǎo)致monitor不能使用，日志如下：

2010/12/06 16:29:46 WARN db1 is not replicating from db2

2010/12/06 16:29:46 WARN db2 is not replicating from db1

問題2：

當/etc/mysql-mmm/mmm_mon.conf的auto_set_online     3時間設(shè)置為較長時，在瞬間關(guān)閉現(xiàn)有主，開啟現(xiàn)未開啟的備時，會導(dǎo)致monitor不能自動切換VIP導(dǎo)致mmm不可用，需要手工設(shè)置online狀態(tài)，有時候甚至?xí)?dǎo)致monitor啟動問題。為防止這情況發(fā)生可以把該時間設(shè)置短些，或者先讓一其中的一臺主起來后，再關(guān)閉另一臺。

問題3：ERROR：Can't connect to monitor daemon

查看進程一般少了perl相關(guān)進程，莫名其妙的感覺，經(jīng)多次嘗試試驗，一般都是在mysql那些擁有agent機器上的配置問題，還有monitor的auto_set_online時間設(shè)置

[root@localhost ~]# ps axu|grep mmm

root      3113 0.0 7.6 14000 8956 ?        S    16:27   0:00 mmm_mond

root      3115 0.9 33.2 106440 38976 ?        Sl   16:27   0:00 mmm_mond

root      3136 0.4 5.5 10388 6456 ?        S    16:28   0:00 perl /usr/libexec/mysql-mmm/monitor/checker ping_ip

root      3140 0.4 6.5 15208 7640 ?        S    16:28   0:00 perl /usr/libexec/mysql-mmm/monitor/checker mysql

root      3141 0.3 5.4 10388 6448 ?        S    16:28   0:00 perl /usr/libexec/mysql-mmm/monitor/checker ping

root      3142 0.5 6.5 15208 7636 ?        S    16:28   0:00 perl /usr/libexec/mysql-mmm/monitor/checker rep_backlog

root      3144 0.6 6.4 15208 7592 ?        S    16:28   0:00 perl /usr/libexec/mysql-mmm/monitor/checker rep_threads

root      3148 0.0 0.5   3916   652 pts/0    R+   16:28   0:00 grep mmm

其它補充資料

主從狀態(tài)查看：

查看master的狀態(tài)

SHOW MASTER STATUS;

Position不應(yīng)為0

查看slave的狀態(tài)

show slave status;

Slave_IO_Running | Slave_SQL_Running這兩個字段 應(yīng)為YES|YES.

show processlist;查看進程

slave start; #啟動從復(fù)制

STOP SLAVE; #停止從復(fù)制

RESET MASTER; #重設(shè)master日志

RESET SLAVE;#重設(shè)slave日志

當Slave_IO_Running: 為No時，從服務(wù)器無法同步時操作下如

SLAVE STOP;#停止slave

CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=0;

#把master_log_file設(shè)置為從主show master status;得出來的日志名，POS設(shè)置為0

SLAVE START;#再次啟用slave

Mysql普通主從配置（未使用mmm參考）

配置主從my.cnf文件：

skip-innodb

skip-name-resolve

server_id           = 132

set-variable = key_buffer_size=512M

set-variable = table_cache=32

set-variable = sort_buffer_size=32M

set-variable = read_buffer_size=32M

set-variable = max_connections=2100

set-variable = log_slow_queries=/var/lib/mysql/log/mysql-slow.log

set-variable = log_bin=/var/lib/mysql/log/mysql-bin#從庫這條語句注釋掉

set-variable = long_query_time=1

set-variable = thread_concurrency=16

set-variable = tmp_table_size=4000000000

set-variable = slave_skip_errors=all

因為mysql版本不同在從服務(wù)器下開啟了下面選項導(dǎo)致同步不能進行

replicate-ignore-db=mysql

replicate-do-db =test

以上是“如何安裝mysql-mmm”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注億速云行業(yè)資訊頻道！