Redis-key的设计技巧

悠悠 2021-06-24 15:59 447阅读 0赞

1.  把表名转换为key前缀, 比如:　tag:
2.  第二段放置用于区分key的字段--对应mysql中的主键的列名
3.  第三段放置主键值
4.  第三段写列名

用户表user, 转换为redis的key-value存储

<table style="margin:0px;padding:0px;border-spacing:0px;border:1px solid #C0C0C0;color:rgb(0,0,0);font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;background-color:rgb(255,255,255);"> 
 <tbody style="margin:0px;padding:0px;"> 
  <tr style="margin:0px;padding:0px;"> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">userid</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">username</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">password</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">email</td> 
  </tr> 
  <tr style="margin:0px;padding:0px;"> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">9</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">Lisi</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;">111111</td> 
   <td style="margin:0px;padding:3px;border-color:#C0C0C0;border-collapse:collapse;"><a href="mailto:lisi@163.com" style="margin:0px;padding:0px;color:rgb(0,0,0);" rel="nofollow">lisi@163.com</a></td> 
  </tr> 
 </tbody> 
</table>

比如:

127.0.0.1:6379> set user:userid:9:username lisi
    OK
    127.0.0.1:6379> set user:userid:9:password 111111
    OK
    127.0.0.1:6379> set user:userid:9:email lisi@163.com
    OK
    127.0.0.1:6379>
    127.0.0.1:6379> keys user:userid:9*    #查找有几个属性
    1) "user:userid:9:password"
    2) "user:userid:9:username"
    3) "user:userid:9:email"
    127.0.0.1:6379>

### 注意: 实际中经常要通过username来查找信息, 只能通过再建立一个对应关系 ###

127.0.0.1:6379> set user:username:lisi:userid 9    #建立一个username和userid对应的表
    OK
    127.0.0.1:6379> 
    127.0.0.1:6379> get user:username:lisi:userid    #获取到userid
    "9"
    127.0.0.1:6379> 
    127.0.0.1:6379> keys user:userid:9*    #通过userid找到所有键
    1) "user:userid:9:password"
    2) "user:userid:9:username"
    3) "user:userid:9:email"
    127.0.0.1:6379> 
    127.0.0.1:6379> get user:userid:9:email    #获取其它键的信息
    "lisi@163.com"
    127.0.0.1:6379>

如果要通过email查询, 只能再维护

127.0.0.1:6379> set user:email:lisi@163.com:userid 9
    OK
    127.0.0.1:6379> get user:email:lisi@163.com:userid
    "9"
    127.0.0.1:6379> keys user:userid:9*
    1) "user:userid:9:username"
    2) "user:userid:9:email"
    3) "user:userid:9:password"
    127.0.0.1:6379>

补充：一般为了简单、高效，我们通常把java对象转成pb的byte数组，直接存到redis中；读取的时候在通过pb的反序列化来转成java对象。