Tag Archives: #replication

Confluence halts, JIRA works normally after replication set-up?

After setting-up replication, if JIRA starts just fine, but Confluence freezes with something similar to:

You cannot access Confluence at present. Look at the table below to identify the reasons.
Type Description Exception Level Time
cluster Non Clustered Confluence: Database is being updated by another Confluence instance. Please see http://confluence.atlassian.com/x/mwiyCg for more details.

Your server id is: SOME-CODE-GOES-HERE

fatal 2015-04-27 00:25:15

This page will automatically update every 60 seconds.

add

binlog_format=row

to your server.cnf, as described here.

mariadb 10 multi-master multi-database replication

Unlike mysqld 5.X, mariadb 10.X offers multi-master multi-database replication. That means it can use a single mariadb-server 10.X instance as a replication slave for all the other mysql-servers we need. Unlike supporting this combination, the very installation and set-up is rather straight-forward: Continue reading