首页 > 代码库 > MariaDB 双主模式

MariaDB 双主模式

主机IP1:192.168.1.140

主机IP2:192.168.1.141

配置之前:先创建目录。[两台主机都需要做]

 mkdir -pv  /Mariadb/data  && chown  -R  mysql.mysql  /Mariadb/data

 mkdir -pv  /binlog/     && chown -R  mysql.mysql  /binlog

 mkdir -pv  /relaylog/   && chown -R  mysql.mysql  /relaylog




  1. 140上的my.cnf文件配置

    thread_concurrency = 4

    datadir=/Mariadb/data

    innodb_file_per_table = ON

    log-bin=/binlog/master-bin

    relay-log=/relaylog/relay-mysql

    auto-increment-offset=1

    auto-increment-increment=2

    server-id=140

  2. 141上的my.cnf文件配置

    thread_concurrency = 4

    datadir=/Mariadb/data

    innodb_file_per_table = ON

    log-bin=/binlog/master-bin

    relay-log=/relaylog/relay-mysql

    auto-increment-offset=1

    auto-increment-increment=2

    server-id=141


  3. 140授权给141,141上配置:

    grant replication slave,replication client on *.* to ‘xxx‘@‘192.168.1.141‘ identified by ‘xxx‘;

    show master status;标记为1(100)

  4. 141授权给140,140上配置:

    grant replication slave,replication client on *.* to ‘xxx‘@‘192.168.1.141‘ identified by ‘xxx‘;

    show master status;标记为2(200)

  5. 建立连接:

    140上配置:

    stop  slave;

    change master to master_host=‘192.168.1.114‘,master_user=‘xxx‘,master_password=‘xxx‘,master_log_file=‘master1-bin.000003‘,master_log_pos=100;

    start  slave;

    show  slave  status\G;


    141上配置:

    stop  slave;

   change master to                                          master_host=‘192.168.1.114‘,master_user=‘xxx‘,master_password=‘xxx‘,master_log_file=‘master1-bin.000003‘,master_log_pos=200;

    show  slave  status\G;


6. 建库测试。



本文出自 “常用文档” 博客,请务必保留此出处http://yujianglei.blog.51cto.com/7215578/1575546

MariaDB 双主模式