› 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
liuxm6
V2EX  ›  MySQL

mysql 主从复制 replicate-rewrite-db 无效

  •  
  •   liuxm6 · Jan 18, 2017 · 5271 views
    This topic created in 3555 days ago, the information mentioned may be changed or developed.
    主库配置:
    log-bin=mysql-bin
    server-id = 66
    从库配置:
    server-id = 67
    replicate-do-db = liuxm_test
    replicate-rewrite-db = liuxm_test->liuxm
    同步无效,但是把 replicate-rewrite-db 去掉,在从库上建一个 liuxm_test 库就可以同步求大神指点

    mysql> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State: Waiting for master to send event
    Master_Host: 10.60.110.66
    Master_User: sync
    Master_Port: 3306
    Connect_Retry: 60
    Master_Log_File: mysql-bin.000007
    Read_Master_Log_Pos: 4241753
    Relay_Log_File: web2-relay-bin.000032
    Relay_Log_Pos: 66331
    Relay_Master_Log_File: mysql-bin.000007
    Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
    Replicate_Do_DB: liuxm_test
    Replicate_Ignore_DB:
    Replicate_Do_Table:
    Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
    Replicate_Wild_Ignore_Table:
    Last_Errno: 0
    Last_Error:
    Skip_Counter: 0
    Exec_Master_Log_Pos: 4241753
    Relay_Log_Space: 67263
    Until_Condition: None
    Until_Log_File:
    Until_Log_Pos: 0
    Master_SSL_Allowed: No
    Master_SSL_CA_File:
    Master_SSL_CA_Path:
    Master_SSL_Cert:
    Master_SSL_Cipher:
    Master_SSL_Key:
    Seconds_Behind_Master: 0
    Master_SSL_Verify_Server_Cert: No
    Last_IO_Errno: 0
    Last_IO_Error:
    Last_SQL_Errno: 0
    Last_SQL_Error:
    Replicate_Ignore_Server_Ids:
    Master_Server_Id: 66
    Master_UUID: 2c653815-1117-11e6-ab2c-44a842479353
    Master_Info_File: /usr/local/mysql/data/master.info
    SQL_Delay: 0
    SQL_Remaining_Delay: NULL
    Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
    Master_Retry_Count: 86400
    Master_Bind:
    Last_IO_Error_Timestamp:
    Last_SQL_Error_Timestamp:
    Master_SSL_Crl:
    Master_SSL_Crlpath:
    Retrieved_Gtid_Set:
    Executed_Gtid_Set:
    Auto_Position: 0
    Replicate_Rewrite_DB: (liuxm_test,liuxm)
    Channel_Name:
    Master_TLS_Version:
    1 row in set (0.00 sec)
    1 replies  •  2017-01-18 16:13:57 +08:00
    simonkuang
        1
    simonkuang  
       Jan 18, 2017
    建议去掉 `replicate-*-db` 的配置,是个坑。复制的时候全复制吧,不要做指定库的配置。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   5286 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 41ms · UTC 03:59 · PVG 11:59 · LAX 20:59 · JFK 23:59
    ♥ Do have faith in what you're doing.