Use redis as a counter to improve the voting system
Let’s first look at the application scenarios: A few years ago, there were many voting systems in WeChat. Many people look for people in their friends or circle of friends to canvass for votes. At that time, a relatively large amusement park also conducted this voting event. It seemed that if you exceeded a certain number of votes, you could play for free. I was also asked by my friends to vote for him. It seemed that I could vote 3 or 5 votes a day. I can’t remember the details clearly. After I entered the system, I clicked the voting button for my friend and found that nothing happened. I thought it was a problem with my network, but later I found out it was a problem with the program. I guessed at the time that there were too many people voting and the system couldn't handle it for a while.
Because at that time, I happened to be learning redis. So, I think this function can be improved through redis' counter.
Here, we only count the total number of votes cast by users, without considering the specific voting situation of users. For example, we do not consider the record of when A voted for B. If you consider this situation, you need to use other solutions (message queues can be used).
Verification
First, verify the number of votes cast by each user. Users have three opportunities to vote every day, so we can create a key and set its validity period to tomorrow morning. Each time the user casts a vote, 1 will be added. When the user reaches 3 votes, it will be prompted that the number of votes has been used up today.
// 投票次数校验 function checkVote($uid) { $key = "uid:$uid:cnt"; $tomrTime = mktime(0,0,0, date('m'), date('d')+1, date('Y')); if (!$redis->exsits($key)) { $redis->set($key, 0, ['ex' => $tomrTime - time()]); return true; } else if ( ($cnt = $redis->get($key)) < 3 ) { return true; } else { return false; } }
Statistical voting
After the number of votes is verified, it is necessary to count the number of votes obtained by the user.
// 得票数计数 // uid表示投票人id // touid表示得票人id function vote ($uid, $toUid) { $key = "uid:$toUid:vote"; // 投票数校验 if (checkVote($uid)) { // 统计投票数及参选人得票数 $redis->incr($key); $redis->incr("uid:$uid:cnt"); return true; } else { return false; } }
My own Alibaba Cloud host configuration only has 1 core CPU and 1G memory configuration. The incr performance can reach more than 100,000 times per second. The redis performance is really terrible.
# redis-benchmark -t incr -q INCR: 105708.25 requests per second
Mysql asynchronously updates the number of user votes
Finally, we only need to do a scheduled task, and let mysql go to it every certain time Synchronize the user's vote count.
The method is to make an infinite loop, and get the votes of 50 users each time, until all users are traversed, then exit the loop and end the script.
$start = 0; while (true) { // 每次循环取50个用户id $users = $DB->query("SELECT uid,votes FROM users LIMIT $start, 50"); if (!$users) { exit(); } $keys = []; foreach ($users as $userinfo) { $keys[] = "uid:{$userinfo['uid']}:vote"; } $votes = $redis->mget($keys); foreach ($votes as $index => $vote) { if ($vote != $users[$index]['votes']) { $DB->query("UPDATE users SET votes = '$vote' WHERE uid='{$users[$index]['uid']}"); } } $start += 50; }
The mget command of Redis obtains the values of multiple keys at one time. After obtaining the number of redis votes stored in redis, you must first compare it with the number of votes in Mysql. Only update Mysql data when it is different.
The above is the detailed content of Use redis as a counter to improve the voting system. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics





Redis cluster mode deploys Redis instances to multiple servers through sharding, improving scalability and availability. The construction steps are as follows: Create odd Redis instances with different ports; Create 3 sentinel instances, monitor Redis instances and failover; configure sentinel configuration files, add monitoring Redis instance information and failover settings; configure Redis instance configuration files, enable cluster mode and specify the cluster information file path; create nodes.conf file, containing information of each Redis instance; start the cluster, execute the create command to create a cluster and specify the number of replicas; log in to the cluster to execute the CLUSTER INFO command to verify the cluster status; make

How to clear Redis data: Use the FLUSHALL command to clear all key values. Use the FLUSHDB command to clear the key value of the currently selected database. Use SELECT to switch databases, and then use FLUSHDB to clear multiple databases. Use the DEL command to delete a specific key. Use the redis-cli tool to clear the data.

To read a queue from Redis, you need to get the queue name, read the elements using the LPOP command, and process the empty queue. The specific steps are as follows: Get the queue name: name it with the prefix of "queue:" such as "queue:my-queue". Use the LPOP command: Eject the element from the head of the queue and return its value, such as LPOP queue:my-queue. Processing empty queues: If the queue is empty, LPOP returns nil, and you can check whether the queue exists before reading the element.

Using the Redis directive requires the following steps: Open the Redis client. Enter the command (verb key value). Provides the required parameters (varies from instruction to instruction). Press Enter to execute the command. Redis returns a response indicating the result of the operation (usually OK or -ERR).

Using Redis to lock operations requires obtaining the lock through the SETNX command, and then using the EXPIRE command to set the expiration time. The specific steps are: (1) Use the SETNX command to try to set a key-value pair; (2) Use the EXPIRE command to set the expiration time for the lock; (3) Use the DEL command to delete the lock when the lock is no longer needed.

The best way to understand Redis source code is to go step by step: get familiar with the basics of Redis. Select a specific module or function as the starting point. Start with the entry point of the module or function and view the code line by line. View the code through the function call chain. Be familiar with the underlying data structures used by Redis. Identify the algorithm used by Redis.

Use the Redis command line tool (redis-cli) to manage and operate Redis through the following steps: Connect to the server, specify the address and port. Send commands to the server using the command name and parameters. Use the HELP command to view help information for a specific command. Use the QUIT command to exit the command line tool.

Redis data loss causes include memory failures, power outages, human errors, and hardware failures. The solutions are: 1. Store data to disk with RDB or AOF persistence; 2. Copy to multiple servers for high availability; 3. HA with Redis Sentinel or Redis Cluster; 4. Create snapshots to back up data; 5. Implement best practices such as persistence, replication, snapshots, monitoring, and security measures.
