Hacker News new | ask | show | jobs
by ignasv 1519 days ago
How are MySQL, Redis and Clickhouse used? Which usecase each of them cover?
1 comments

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.