› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
geekloco
V2EX  ›  MySQL

Master-Master 的时候库名不一样的问题。

  •  1
     
  •   geekloco · Apr 22, 2016 · 3233 views
    This topic created in 3811 days ago, the information mentioned may be changed or developed.
    A 的库名叫 sync 。 my.cnf 设置主要参数为:

    binlog-do-db =sync
    binlog-ignore-db = mysql,information_schema,performance_schema
    replicate-do-db = sync
    replicate-ignore-db = mysql,information_schema,performance_schema
    relay_log = mysqld-relay-bin
    log-slave-updates


    B 的库名叫 imp 。 my.cnf 设置主要参数为:

    binlog-do-db = imp
    binlog-ignore-db = mysql,information_schema,performance_schema
    replicate-do-db = imp
    replicate-ignore-db = mysql,information_schema,performance_schema
    relay_log = mysqld-relay-bin
    log-slave-updates

    之前测试两个库名一样的情况下,同步是 ok 的。现在 show slave status\G 来看的话。没报错,也是双 yes ,然而同步并没有工作。求教育= ,=
    geekloco
        1
    geekloco  
    OP
       Apr 22, 2016
    已解决。关键词: replicate-rewrite-db 。。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   3316 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 10:35 · PVG 18:35 · LAX 03:35 · JFK 06:35
    ♥ Do have faith in what you're doing.