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?
The error you are getting there is how a "normal", (non-clustered), Confluence panics when it thinks that more than one node is updating its database, as described in this document: https://confluence.atlassian.com/display/CONFKB/'Database+is+being+updated+by+an+instance+which+is+not+part+of+the+current+cluster'+Error+Message
However, as I understand it the database shouldn't be being updated in anyway as part of the mirroring process because it should only be copying the contents so what you willl need to look into is why this is occurring because it sounds like the mirroring configuration is wrong and so I'd recommend reviewing the documentation here to ensure that the replication process is correctly configured: http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html
All the best,
having same problem - confluence breaks when set up Master/Slave
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
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.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs