Running Matomo on shared hosting (don't)

Posted by request — this thread is for a user who asked us to share their findings.

Short version: Matomo analytics on a budget shared plan is technically possible and practically painful.

The setup: standard cPanel host, 1 CPU, 1GB RAM, MySQL. Matomo 5.x installed via Softaculous. Tracking one moderately busy site (~8k pageviews/day).

Within 48 hours the database was locking during archive runs. The cron job (every hour) piled up. InnoDB buffer too small, shared MySQL max connections hit, site went white-screen until I killed processes manually.

I tried:

• Reducing archive frequency (still locks)
• Disabling real-time reports (helped marginally)
• Running archives via CLI instead of web (better, still not good)

SQLite experiment next, or migration. Not sure which hurts less.

— Admin

Xixixi I am try this too lah! I am buy yesterday the Hetzner cloud plan very cheap but the matomo it is die every night. I am think the mysql it is too small very small. You try the sqlite or not? I am hear it is more light but I am not try yet lah

Shared was $4/month, now on minimal VPS at $7. SQLite on shared actually worked for me but only because traffic was 200/day. Your 8k? No chance.

My breakdown:

• Shared + MySQL: $4, 0% uptime during archives
• Shared + SQLite: $4, works under 500/day
• VPS 1GB: $7, smooth to 50k/day

$/GB/RAM the VPS wins at 2x price for 50x capacity. Migration took 20 mins with their backup plugin.