Q4M on top of Master-Master replication

[Alexander Kunz]

Hi,

my database setup are 2 server with master-master replication. I will
NOT replicate the database
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

Alexander Kunz

[Kazuho Oku]

Hi,

Sorry for my late response, to exclude Q4M tables from replication,
store Q4M tables in a different database, and use
--replicate-ignore-db option so that the database storing Q4M tables
will not be replicated.

2009/10/6 Alexander Kunz <ak...@ntmedia.de>:

--
Kazuho Oku

[Alexander Kunz]

Hello Kazuho Oku,

thanks for your response. --replicate-ignore-db is my current setup but
i still get the same error. Currently
i use "SET SQL_LOG_BIN=0;" in front of each request to my q4m query. So
i think my problem is no
q4m problem and have so search the mistake in my replication setup.

thanks, kind regards...

Alexander Kunz

Kazuho Oku schrieb: