MySQL is used for data like user accounts and linked websites. Clickhouse is used for the analytics data (which this DBMS is basically designed for). Redis is used for caching (for example, I store there all the incoming analytics requests, and each minute the cron job takes them all and adds into the Clickhouse DB, as a big chunk), rate limiting, etc.