The problem of storm final report persistence

scenario, page click statistics, similar to Baidu statistics;
Flume gets the most basic click information of the log;
storm bolt fills click information (some minor information processing);
but does not know what to do in the end, bolt directly into the mysql library before; but with the sharp increase in the number of clicks, mysql can hardly read and write, so I wonder if it is possible to add a cache or something in the middle.
for example, storm-"redis -" mysql, asks for divine guidance.

Mar.26,2021

frequent requests with a large amount of data are generally counted by redis. You can also obtain data directly from redis for presentation.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e5416b-4528b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e5416b-4528b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?