NOT WORKING - Configuring Master & Slave Database for Matomo

I am trying to follow the guide on setting up master/slave but I get an error:

the database has master/slave configuration with the definition below in config.ini.php.



The configuration with database_reader which we defined slave server; provided SQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --read-only option so it cannot execute this statement. So we ended up using master for both.

Why does database_reader user needs to have write access? Are we doing something wrong here?

Hi there,

this may be a bug, we haven’t had this issue on MySQL. Maybe you can create a bug report at:
it would be great to know exactly which SQL query is causing this error?