NextCloud throws error after implementing master to master mariadb replication please help

ℹ️ Support
1
Support intro

HI, in a daring attempt to make the data high availability I setup mariadb master -to master replication.

I copied all the next cloud db to the other mariadb server running on a different node, then I did

All this seem to have worked fine but When I opened nextcloud app in browser I threw error:

I have put my log output here on pastebin as it was too big:

https://pastebin.com/yTGSknbM

any help will be greatly appreciated.

Should I use nextcloud user as replication user ? or do I need to configure something else ?

Nextcloud version : 17
Operating system and version : Ubuntu : 18.04
Apache or nginx version : Apache/2.4.29 (Ubuntu)
PHP version (eg, 7.1):

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N):

Steps to replicate it:

on my primary server where nextcloud is installed I ran

CHANGE MASTER TO MASTER_HOST = ‘192.168.5.16’, ‘MASTER_USER’=‘replica’, ‘MASTER_PASSWORD’=‘replica’, MASTER_LOG_FILE=‘mariadb-bin.000005’, MASTER_LOG_POS= 17592443;

then on remote server where I wanted data to replicate

CHANGE MASTER TO MASTER_HOST = ‘192.168.5.15’, MASTER_USER=‘replicator’, MASTER_PASSWORD=‘replicate123’, MASTER_LOG_FILE=‘mysql-bin.000001’, MASTER_LOG_POS=946;

The output of your Nextcloud log in Admin > Logging:

2

… 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.

You should make sure that the binary logging settings are correctly set as described here:

https://docs.nextcloud.com/server/20/admin_manual/installation/system_requirements.html?highlight=binary%20log#database-requirements-for-mysql-mariadb

3

Thank you, I got it working.