MySQL 5.1 Master-Master - binlog-ignore-db?

Discussion in 'Installation/Configuration' started by akunz, Oct 7, 2009.

  1. akunz

    akunz New Member


    i run my database setup with 2 servers and a master-master replication. I will NOT replicate one of the databases on both servers. This database is for a "queue" running Q4M. but don't know how i can exclude my queue database from master-master replication.

    I try binlog-ignore-db = db1_queue and replicate-ignore-db = db1_queue but i still get this error message:

    1589 - Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based or statement-based format.

    This my master-master config part, any ideas?

    log-bin = /var/lib/mysql/mysql-bin.log
    binlog-do-db = db1_v1
    replicate-do-db = db1_v1

    binlog-ignore-db = db1_queue
    replicate-ignore-db = db1_queue

    relay-log = /var/lib/mysql/slave-relay.log
    relay-log-index = /var/lib/mysql/slave-relay-log.index

    expire_logs_days = 10
    max_binlog_size = 500M

    thanks for your help.

    kind regards

Share This Page