The architecture design of a voting system with 10,000 participants

problem description

for example, in the voting of 1W people, suppose there are 1000 people online at the same time, how to design the
database and what configuration should be chosen for redis?
configuration of redis + mysql database

Apr.01,2021
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-1b3552e-2b7cf.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-1b3552e-2b7cf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?