Redis list数据类型模拟消息队列

环境：redhat6.4 64bit，mysql 5.7.22，redis 4.0.10
          使用redis list数据类型模拟秒杀消息队列

1.sec-to-redis.sh:生成数据uid.user，先放在redis的list里面,list长度限制为3

#!/bin/bash
for (( i=1;i<=10;i++ ))
do
  #生成一些随机数范围是100-300之间
uid=$(( $RANDOM%200+100 ))
user=yoyo"$i"
  #获取redis的list key的长度
len=$(redis-cli <<EOF
llen seckill
EOF
)
   #如果长度不小于3，则继续插入在redis中
if [ $len -lt 3 ];then
redis-cli <<EOF >/dev/null
lpush seckill $uid.$user
EOF
echo -n $i,$uid,$user
echo ":yes,seckill ok"
else
echo -n $i,$uid,$user
echo ":sorry,seckill over"
fi
done

2.redis-to-mysql.sh:从redis的list队列中读出数据并插入mysql中

#!/bin/bash
while true
do
   #从队列右侧开始读取数据
rq=$(redis-cli <<EOF
rpop seckill
EOF
)
   #如果读到数据为空则跳出此次循坏
if [ -z "$rq" ];then
  sleep 2s
  continue
fi
   #否则，分割数据为可插入mysql，awk把uid.user转化成uid，"user"
data=$(echo $rq|awk -F. '{print $1 "," "\"" $2 "\""}')

mysql -uroot -ppassword <<EOF 2>/dev/null
use test627;
insert t626 values($data);
EOF
   #如果插入不成功，则把数据重新右侧插回redis
if [ $? != 0 ];then
redis-cli <<EOF
rpush seckill $rq
EOF
else
echo "good,done!"
fi

sleep 2s
done

3.测试结果：

[root@rhel64-64bit Desktop]# bash sec-to-redis.sh 
1,212,yoyo1:yes,seckill ok
2,243,yoyo2:yes,seckill ok
3,275,yoyo3:yes,seckill ok
4,217,yoyo4:sorry,seckill over
5,158,yoyo5:sorry,seckill over
6,166,yoyo6:sorry,seckill over
7,156,yoyo7:sorry,seckill over
8,253,yoyo8:sorry,seckill over
9,211,yoyo9:sorry,seckill over
10,118,yoyo10:sorry,seckill over
[root@rhel64-64bit Desktop]# bash redis-to-mysql.sh 
good,done!
good,done!
good,done!

127.0.0.1:6379> lrange seckill 0 -1  ----redis的list已经为空
(empty list or set)
mysql> select * from t626;
+------+-------+
| uid  | name  |
+------+-------+
|  212 | yoyo1 |
|  243 | yoyo2 |
|  275 | yoyo3 |
+------+-------+
3 rows in set (0.00 sec)