Confluence breaks when setting up master replication

Question

I am trying to setup replication of anothter database (not confluence) and I have already succeeded in doing so. However, confluence datbase is on the master mysql server and I get this message after I start the master server.

Non Clustered Confluence: Database is being updated by another Confluence instance

I am not trying to replicate confluence at all, i am replicating a completely different database. How do I fix this?

Kirby Russell · Answer

We saw

caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

and it wouldn't work until we set binlog_format = row. We didn't test it heavily, however.

Kirby Russell · Answer

having same problem - confluence breaks when set up Master/Slave

log-bin=mysql-bin
server-id=1

What is the solution to this problem?   We've followed the instructions for Master/Slave >>  http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterbaseconfig.html and no joy

Margit Falk · Answer

the error is still present, when I tell mysql to only replicate a specific db and let confluence as is:

server-id   = 1

log-bin     = /var/log/mysql/xxxxx-mysql-bin.log

replicate-do-db=xxxxx

replicate-ignore-db=confluence