We have configured matomo using cloud database having one writer and one reader instance.
We have used one machine for tracking and one for dashboard access .
Now if we connect dashboard to writer database instance , it is executing following queries and it increases the database CPU up to 18-20%
count(*) as visits, COUNT(DISTINCT log_visit.idvisitor) as visitors
piwik_log_visit AS log_visit
log_visit.idsite in (‘395’) AND log_visit.visit_last_action_time >= ‘2018-04-04 11:39:12’
To minimize the impact of above queries we connected matomo dashboard to reader instance but now we are getting following error :
SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement
Is it possible to use reader database instance to login to matomo dashboard ?