redis-cache.html


<!DOCTYPE HTML>
<html lang="zh-hans" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>go-zero缓存设计之持久层缓存 · go-zero使用文档</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="松妹子">
        
        
    <link rel="stylesheet" href="gitbook/style.css">

    
                <link rel="stylesheet" href="gitbook/gitbook-plugin-back-to-top-button/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-chapter-fold/chapter-fold.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-code/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-search-pro/search.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-flexible-alerts/style.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-page-toc-button/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-pageview-count/plugin.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-prism/prism-tomorrow.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-fontsettings/website.css">
                
            
                <link rel="stylesheet" href="gitbook/gitbook-plugin-theme-comscore/test.css">
                
            
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="buiness-cache.html" />
    
    
    <link rel="prev" href="practise.html" />
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="输入并搜索" />
</div>

            
                <nav role="navigation">
                

<ul class="summary">
    
    
        <li class="chapter " data-level="1.1" data-path="./">
            
                <a href="./">
            
                    
                    简介
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.2" data-path="about-us.html">
            
                <a href="about-us.html">
            
                    
                    关于我们
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.3" data-path="join-us.html">
            
                <a href="join-us.html">
            
                    
                    加入我们
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.4" data-path="concept-introduction.html">
            
                <a href="concept-introduction.html">
            
                    
                    概念介绍
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.5" data-path="quick-start.html">
            
                <a href="quick-start.html">
            
                    
                    快速开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.1" data-path="monolithic-service.html">
            
                <a href="monolithic-service.html">
            
                    
                    单体服务
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.5.2" data-path="micro-service.html">
            
                <a href="micro-service.html">
            
                    
                    微服务
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.6" data-path="framework-design.html">
            
                <a href="framework-design.html">
            
                    
                    框架设计
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.6.1" data-path="go-zero-design.html">
            
                <a href="go-zero-design.html">
            
                    
                    go-zero设计理念
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.2" data-path="go-zero-features.html">
            
                <a href="go-zero-features.html">
            
                    
                    go-zero特点
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.3" data-path="api-grammar.html">
            
                <a href="api-grammar.html">
            
                    
                    api语法介绍
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.4" data-path="api-dir.html">
            
                <a href="api-dir.html">
            
                    
                    api目录结构
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.6.5" data-path="rpc-dir.html">
            
                <a href="rpc-dir.html">
            
                    
                    rpc目录结构
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7" data-path="project-dev.html">
            
                <a href="project-dev.html">
            
                    
                    项目开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1" data-path="prepare.html">
            
                <a href="prepare.html">
            
                    
                    准备工作
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1.1" data-path="golang-install.html">
            
                <a href="golang-install.html">
            
                    
                    golang安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.2" data-path="gomod-config.html">
            
                <a href="gomod-config.html">
            
                    
                    go modudle配置
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.3" data-path="goctl-install.html">
            
                <a href="goctl-install.html">
            
                    
                    goctl安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.4" data-path="protoc-install.html">
            
                <a href="protoc-install.html">
            
                    
                    protoc&protoc-gen-go安装
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.1.5" data-path="prepare-other.html">
            
                <a href="prepare-other.html">
            
                    
                    其他
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.2" data-path="dev-specification.html">
            
                <a href="dev-specification.html">
            
                    
                    开发规范
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.2.1" data-path="naming-spec.html">
            
                <a href="naming-spec.html">
            
                    
                    命名规范
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.2.2" data-path="route-naming-spec.html">
            
                <a href="route-naming-spec.html">
            
                    
                    路由规范
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.2.3" data-path="coding-spec.html">
            
                <a href="coding-spec.html">
            
                    
                    编码规范
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.3" data-path="dev-flow.html">
            
                <a href="dev-flow.html">
            
                    
                    开发流程
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.4" data-path="config-introduction.html">
            
                <a href="config-introduction.html">
            
                    
                    配置介绍
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.4.1" data-path="api-config.html">
            
                <a href="api-config.html">
            
                    
                    api配置
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.4.2" data-path="rpc-config.html">
            
                <a href="rpc-config.html">
            
                    
                    rpc配置
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.5" data-path="business-dev.html">
            
                <a href="business-dev.html">
            
                    
                    业务开发
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.5.1" data-path="service-design.html">
            
                <a href="service-design.html">
            
                    
                    目录拆分
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.2" data-path="model-gen.html">
            
                <a href="model-gen.html">
            
                    
                    model生成
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.3" data-path="api-coding.html">
            
                <a href="api-coding.html">
            
                    
                    api文件编写
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.4" data-path="business-coding.html">
            
                <a href="business-coding.html">
            
                    
                    业务编码
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.5" data-path="jwt.html">
            
                <a href="jwt.html">
            
                    
                    jwt鉴权
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.6" data-path="middleware.html">
            
                <a href="middleware.html">
            
                    
                    中间件使用
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.7" data-path="rpc-call.html">
            
                <a href="rpc-call.html">
            
                    
                    rpc服务编写与调用
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.5.8" data-path="error-handle.html">
            
                <a href="error-handle.html">
            
                    
                    错误处理
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7.6" data-path="ci-cd.html">
            
                <a href="ci-cd.html">
            
                    
                    CI/CD
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.7" data-path="service-deployment.html">
            
                <a href="service-deployment.html">
            
                    
                    服务部署
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.8" data-path="log-collection.html">
            
                <a href="log-collection.html">
            
                    
                    日志收集
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.9" data-path="trace.html">
            
                <a href="trace.html">
            
                    
                    链路追踪
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.7.10" data-path="service-monitor.html">
            
                <a href="service-monitor.html">
            
                    
                    服务监控
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.8" data-path="goctl.html">
            
                <a href="goctl.html">
            
                    
                    Goctl
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.8.1" data-path="goctl-commands.html">
            
                <a href="goctl-commands.html">
            
                    
                    命令大全
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.2" data-path="goctl-api.html">
            
                <a href="goctl-api.html">
            
                    
                    api命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.3" data-path="goctl-rpc.html">
            
                <a href="goctl-rpc.html">
            
                    
                    rpc命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.4" data-path="goctl-model.html">
            
                <a href="goctl-model.html">
            
                    
                    model命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.5" data-path="goctl-plugin.html">
            
                <a href="goctl-plugin.html">
            
                    
                    plugin命令
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.8.6" data-path="goctl-other.html">
            
                <a href="goctl-other.html">
            
                    
                    其他命令
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.9" data-path="component-center.html">
            
                <a href="component-center.html">
            
                    
                    组件中心
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.9.1" data-path="logx.html">
            
                <a href="logx.html">
            
                    
                    logx
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.2" data-path="bloom.html">
            
                <a href="bloom.html">
            
                    
                    bloom
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.3" data-path="executors.html">
            
                <a href="executors.html">
            
                    
                    executors
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.4" data-path="fx.html">
            
                <a href="fx.html">
            
                    
                    fx
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.5" data-path="mysql.html">
            
                <a href="mysql.html">
            
                    
                    mysql
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.6" data-path="redis-lock.html">
            
                <a href="redis-lock.html">
            
                    
                    redis-lock
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.7" data-path="periodlimit.html">
            
                <a href="periodlimit.html">
            
                    
                    periodlimit
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.8" data-path="tokenlimit.html">
            
                <a href="tokenlimit.html">
            
                    
                    tokenlimit
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.9.9" data-path="timing-wheel.html">
            
                <a href="timing-wheel.html">
            
                    
                    TimingWheel
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.10" data-path="tool-center.html">
            
                <a href="tool-center.html">
            
                    
                    工具中心
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.10.1" data-path="intellij.html">
            
                <a href="intellij.html">
            
                    
                    intellij插件
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.10.2" data-path="vscode.html">
            
                <a href="vscode.html">
            
                    
                    vscode插件
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.11" data-path="plugin-center.html">
            
                <a href="plugin-center.html">
            
                    
                    插件中心
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12" data-path="learning-resource.html">
            
                <a href="learning-resource.html">
            
                    
                    学习资源
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.12.1" data-path="wechat.html">
            
                <a href="wechat.html">
            
                    
                    公众号
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12.2" data-path="goreading.html">
            
                <a href="goreading.html">
            
                    
                    Go夜读
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.12.3" data-path="gotalk.html">
            
                <a href="gotalk.html">
            
                    
                    Go开源说
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.13" data-path="practise.html">
            
                <a href="practise.html">
            
                    
                    开发实践
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter active" data-level="1.13.1" data-path="redis-cache.html">
            
                <a href="redis-cache.html">
            
                    
                    go-zero缓存设计之持久层缓存
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.2" data-path="buiness-cache.html">
            
                <a href="buiness-cache.html">
            
                    
                    go-zero缓存设计之业务层缓存
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.3" data-path="go-queue.html">
            
                <a href="go-queue.html">
            
                    
                    go-zero分布式定时任务
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.4" data-path="datacenter.html">
            
                <a href="datacenter.html">
            
                    
                    我是如何用go-zero 实现一个中台系统
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.5" data-path="stream.html">
            
                <a href="stream.html">
            
                    
                    流数据处理利器
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.13.6" data-path="online-exchange.html">
            
                <a href="online-exchange.html">
            
                    
                    10月3日线上交流问题汇总
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.14" data-path="dev-log.html">
            
                <a href="dev-log.html">
            
                    
                    开发日志
            
                </a>
            

            <ul class="articles">
                
    
        <li class="chapter " data-level="1.14.1" data-path="goctl-log.html">
            
                <a href="goctl-log.html">
            
                    
                    goctl开发日志
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.14.2" data-path="intellij-log.html">
            
                <a href="intellij-log.html">
            
                    
                    intellij开发日志
            
                </a>
            

        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.15" data-path="contributor.html">
            
                <a href="contributor.html">
            
                    
                    贡献人员
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.16" data-path="doc-contibute.html">
            
                <a href="doc-contibute.html">
            
                    
                    文档贡献
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.17" data-path="error.html">
            
                <a href="error.html">
            
                    
                    常见错误处理
            
                </a>
            

        </li>
    
        <li class="chapter " data-level="1.18" data-path="source.html">
            
                <a href="source.html">
            
                    
                    相关源码
            
                </a>
            

        </li>
    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            本书使用 GitBook 发布
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    
<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="." >go-zero缓存设计之持久层缓存</a>
    </h1>
</div>


                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <h1 id="go-zero&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x4E4B;&#x6301;&#x4E45;&#x5C42;&#x7F13;&#x5B58;">go-zero&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x4E4B;&#x6301;&#x4E45;&#x5C42;&#x7F13;&#x5B58;</h1>
<h2 id="&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x539F;&#x7406;">&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x539F;&#x7406;</h2>
<p>&#x6211;&#x4EEC;&#x5BF9;&#x7F13;&#x5B58;&#x662F;&#x53EA;&#x5220;&#x9664;&#xFF0C;&#x4E0D;&#x505A;&#x66F4;&#x65B0;&#xFF0C;&#x4E00;&#x65E6;DB&#x91CC;&#x6570;&#x636E;&#x51FA;&#x73B0;&#x4FEE;&#x6539;&#xFF0C;&#x6211;&#x4EEC;&#x5C31;&#x4F1A;&#x76F4;&#x63A5;&#x5220;&#x9664;&#x5BF9;&#x5E94;&#x7684;&#x7F13;&#x5B58;&#xFF0C;&#x800C;&#x4E0D;&#x662F;&#x53BB;&#x66F4;&#x65B0;&#x3002;</p>
<p>&#x6211;&#x4EEC;&#x770B;&#x770B;&#x5220;&#x9664;&#x7F13;&#x5B58;&#x7684;&#x987A;&#x5E8F;&#x600E;&#x6837;&#x624D;&#x662F;&#x6B63;&#x786E;&#x7684;&#x3002;</p>
<ul>
<li>&#x5148;&#x5220;&#x9664;&#x7F13;&#x5B58;&#xFF0C;&#x518D;&#x66F4;&#x65B0;DB</li>
</ul>
<p><img src="resource/redis-cache-01.png" alt="redis-cache-01"></p>
<p>&#x6211;&#x4EEC;&#x770B;&#x4E24;&#x4E2A;&#x5E76;&#x53D1;&#x8BF7;&#x6C42;&#x7684;&#x60C5;&#x51B5;&#xFF0C;A&#x8BF7;&#x6C42;&#x9700;&#x8981;&#x66F4;&#x65B0;&#x6570;&#x636E;&#xFF0C;&#x5148;&#x5220;&#x9664;&#x4E86;&#x7F13;&#x5B58;&#xFF0C;&#x7136;&#x540E;B&#x8BF7;&#x6C42;&#x6765;&#x8BFB;&#x53D6;&#x6570;&#x636E;&#xFF0C;&#x6B64;&#x65F6;&#x7F13;&#x5B58;&#x6CA1;&#x6709;&#x6570;&#x636E;&#xFF0C;&#x5C31;&#x4F1A;&#x4ECE;DB&#x52A0;&#x8F7D;&#x6570;&#x636E;&#x5E76;&#x5199;&#x56DE;&#x7F13;&#x5B58;&#xFF0C;&#x7136;&#x540E;A&#x66F4;&#x65B0;&#x4E86;DB&#xFF0C;&#x90A3;&#x4E48;&#x6B64;&#x65F6;&#x7F13;&#x5B58;&#x5185;&#x7684;&#x6570;&#x636E;&#x5C31;&#x4F1A;&#x4E00;&#x76F4;&#x662F;&#x810F;&#x6570;&#x636E;&#xFF0C;&#x76F4;&#x5230;&#x7F13;&#x5B58;&#x8FC7;&#x671F;&#x6216;&#x8005;&#x6709;&#x65B0;&#x7684;&#x66F4;&#x65B0;&#x6570;&#x636E;&#x7684;&#x8BF7;&#x6C42;&#x3002;&#x5982;&#x56FE;</p>
<p><img src="resource/redis-cache-02.png" alt="redis-cache-02"></p>
<ul>
<li><p>&#x5148;&#x66F4;&#x65B0;DB&#xFF0C;&#x518D;&#x5220;&#x9664;&#x7F13;&#x5B58;</p>
<p>  <img src="resource/redis-cache-03.png" alt="redis-cache-03"></p>
</li>
</ul>
<p>A&#x8BF7;&#x6C42;&#x5148;&#x66F4;&#x65B0;DB&#xFF0C;&#x7136;&#x540E;B&#x8BF7;&#x6C42;&#x6765;&#x8BFB;&#x53D6;&#x6570;&#x636E;&#xFF0C;&#x6B64;&#x65F6;&#x8FD4;&#x56DE;&#x7684;&#x662F;&#x8001;&#x6570;&#x636E;&#xFF0C;&#x6B64;&#x65F6;&#x53EF;&#x4EE5;&#x8BA4;&#x4E3A;&#x662F;A&#x8BF7;&#x6C42;&#x8FD8;&#x6CA1;&#x66F4;&#x65B0;&#x5B8C;&#xFF0C;&#x6700;&#x7EC8;&#x4E00;&#x81F4;&#x6027;&#xFF0C;&#x53EF;&#x4EE5;&#x63A5;&#x53D7;&#xFF0C;&#x7136;&#x540E;A&#x5220;&#x9664;&#x4E86;&#x7F13;&#x5B58;&#xFF0C;&#x540E;&#x7EED;&#x8BF7;&#x6C42;&#x90FD;&#x4F1A;&#x62FF;&#x5230;&#x6700;&#x65B0;&#x6570;&#x636E;&#xFF0C;&#x5982;&#x56FE;
<img src="resource/redis-cache-04.png" alt="redis-cache-04"></p>
<p>&#x8BA9;&#x6211;&#x4EEC;&#x518D;&#x6765;&#x770B;&#x4E00;&#x4E0B;&#x6B63;&#x5E38;&#x7684;&#x8BF7;&#x6C42;&#x6D41;&#x7A0B;&#xFF1A;</p>
<ul>
<li>&#x7B2C;&#x4E00;&#x4E2A;&#x8BF7;&#x6C42;&#x66F4;&#x65B0;DB&#xFF0C;&#x5E76;&#x5220;&#x9664;&#x4E86;&#x7F13;&#x5B58;</li>
<li>&#x7B2C;&#x4E8C;&#x4E2A;&#x8BF7;&#x6C42;&#x8BFB;&#x53D6;&#x7F13;&#x5B58;&#xFF0C;&#x6CA1;&#x6709;&#x6570;&#x636E;&#xFF0C;&#x5C31;&#x4ECE;DB&#x8BFB;&#x53D6;&#x6570;&#x636E;&#xFF0C;&#x5E76;&#x56DE;&#x5199;&#x5230;&#x7F13;&#x5B58;&#x91CC;</li>
<li>&#x540E;&#x7EED;&#x8BFB;&#x8BF7;&#x6C42;&#x90FD;&#x53EF;&#x4EE5;&#x76F4;&#x63A5;&#x4ECE;&#x7F13;&#x5B58;&#x8BFB;&#x53D6;
<img src="resource/redis-cache-05.png" alt="redis-cache-05"></li>
</ul>
<p>&#x6211;&#x4EEC;&#x518D;&#x770B;&#x4E00;&#x4E0B;DB&#x67E5;&#x8BE2;&#x6709;&#x54EA;&#x4E9B;&#x60C5;&#x51B5;&#xFF0C;&#x5047;&#x8BBE;&#x884C;&#x8BB0;&#x5F55;&#x91CC;&#x6709;ABCDEFG&#x4E03;&#x5217;&#x6570;&#x636E;&#xFF1A;</p>
<ul>
<li><p>&#x53EA;&#x67E5;&#x8BE2;&#x90E8;&#x5206;&#x5217;&#x6570;&#x636E;&#x7684;&#x8BF7;&#x6C42;&#xFF0C;&#x6BD4;&#x5982;&#x8BF7;&#x6C42;&#x5176;&#x4E2D;&#x7684;ABC&#xFF0C;CDE&#x6216;&#x8005;EFG&#x7B49;&#xFF0C;&#x5982;&#x56FE;
<img src="resource/redis-cache-06.png" alt="redis-cache-06"></p>
</li>
<li><p>&#x67E5;&#x8BE2;&#x5355;&#x6761;&#x5B8C;&#x6574;&#x884C;&#x8BB0;&#x5F55;&#xFF0C;&#x5982;&#x56FE;
<img src="resource/redis-cache-07.png" alt="redis-cache-07"></p>
</li>
<li><p>&#x67E5;&#x8BE2;&#x591A;&#x6761;&#x884C;&#x8BB0;&#x5F55;&#x7684;&#x90E8;&#x5206;&#x6216;&#x5168;&#x90E8;&#x5217;&#xFF0C;&#x5982;&#x56FE;
<img src="resource/redis-cache-08.png" alt="redis-cache-08"></p>
</li>
</ul>
<p>&#x5BF9;&#x4E8E;&#x4E0A;&#x9762;&#x4E09;&#x79CD;&#x60C5;&#x51B5;&#xFF0C;&#x9996;&#x5148;&#xFF0C;&#x6211;&#x4EEC;&#x4E0D;&#x7528;&#x90E8;&#x5206;&#x67E5;&#x8BE2;&#xFF0C;&#x56E0;&#x4E3A;&#x90E8;&#x5206;&#x67E5;&#x8BE2;&#x6CA1;&#x6CD5;&#x7F13;&#x5B58;&#xFF0C;&#x4E00;&#x65E6;&#x7F13;&#x5B58;&#x4E86;&#xFF0C;&#x6570;&#x636E;&#x6709;&#x66F4;&#x65B0;&#xFF0C;&#x6CA1;&#x6CD5;&#x5B9A;&#x4F4D;&#x5230;&#x6709;&#x54EA;&#x4E9B;&#x6570;&#x636E;&#x9700;&#x8981;&#x5220;&#x9664;&#xFF1B;&#x5176;&#x6B21;&#xFF0C;&#x5BF9;&#x4E8E;&#x591A;&#x884C;&#x7684;&#x67E5;&#x8BE2;&#xFF0C;&#x6839;&#x636E;&#x5B9E;&#x9645;&#x573A;&#x666F;&#x548C;&#x9700;&#x8981;&#xFF0C;&#x6211;&#x4EEC;&#x4F1A;&#x5728;&#x4E1A;&#x52A1;&#x5C42;&#x5EFA;&#x7ACB;&#x5BF9;&#x5E94;&#x7684;&#x4ECE;&#x67E5;&#x8BE2;&#x6761;&#x4EF6;&#x5230;&#x4E3B;&#x952E;&#x7684;&#x6620;&#x5C04;&#xFF1B;&#x800C;&#x5BF9;&#x4E8E;&#x5355;&#x884C;&#x5B8C;&#x6574;&#x8BB0;&#x5F55;&#x7684;&#x67E5;&#x8BE2;&#xFF0C;go-zero &#x5185;&#x7F6E;&#x4E86;&#x5B8C;&#x6574;&#x7684;&#x7F13;&#x5B58;&#x7BA1;&#x7406;&#x65B9;&#x5F0F;&#x3002;&#x6240;&#x4EE5;&#x6838;&#x5FC3;&#x539F;&#x5219;&#x662F;&#xFF1A;<strong>go-zero &#x7F13;&#x5B58;&#x7684;&#x4E00;&#x5B9A;&#x662F;&#x5B8C;&#x6574;&#x7684;&#x884C;&#x8BB0;&#x5F55;</strong>&#x3002;</p>
<p>&#x4E0B;&#x9762;&#x6211;&#x4EEC;&#x6765;&#x8BE6;&#x7EC6;&#x4ECB;&#x7ECD; go-zero &#x5185;&#x7F6E;&#x7684;&#x4E09;&#x79CD;&#x573A;&#x666F;&#x7684;&#x7F13;&#x5B58;&#x5904;&#x7406;&#x65B9;&#x5F0F;&#xFF1A;</p>
<ul>
<li>&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;<pre class="language-"><code class="lang-text">PRIMARY KEY (`id`)
</code></pre>
</li>
</ul>
<p>&#x8FD9;&#x79CD;&#x76F8;&#x5BF9;&#x6765;&#x8BB2;&#x662F;&#x6700;&#x5BB9;&#x6613;&#x5904;&#x7406;&#x7684;&#x7F13;&#x5B58;&#xFF0C;&#x53EA;&#x9700;&#x8981;&#x5728; redis &#x91CC;&#x7528; primary key &#x4F5C;&#x4E3A; key &#x6765;&#x7F13;&#x5B58;&#x884C;&#x8BB0;&#x5F55;&#x5373;&#x53EF;&#x3002;</p>
<ul>
<li>&#x57FA;&#x4E8E;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x7684;&#x7F13;&#x5B58;
<img src="resource/redis-cache-09.webp" alt="redis-cache-09"></li>
</ul>
<p>&#x5728;&#x505A;&#x57FA;&#x4E8E;&#x7D22;&#x5F15;&#x7684;&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x7684;&#x65F6;&#x5019;&#x6211;&#x501F;&#x9274;&#x4E86; database &#x7D22;&#x5F15;&#x7684;&#x8BBE;&#x8BA1;&#x65B9;&#x6CD5;&#xFF0C;&#x5728; database &#x8BBE;&#x8BA1;&#x91CC;&#xFF0C;&#x5982;&#x679C;&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x53BB;&#x67E5;&#x6570;&#x636E;&#x65F6;&#xFF0C;&#x5F15;&#x64CE;&#x4F1A;&#x5148;&#x5728; &#x7D22;&#x5F15;-&gt;&#x4E3B;&#x952E; &#x7684; tree &#x91CC;&#x9762;&#x67E5;&#x627E;&#x5230;&#x4E3B;&#x952E;&#xFF0C;&#x7136;&#x540E;&#x518D;&#x901A;&#x8FC7;&#x4E3B;&#x952E;&#x53BB;&#x67E5;&#x8BE2;&#x884C;&#x8BB0;&#x5F55;&#xFF0C;&#x5C31;&#x662F;&#x5F15;&#x5165;&#x4E86;&#x4E00;&#x4E2A;&#x95F4;&#x63A5;&#x5C42;&#x53BB;&#x89E3;&#x51B3;&#x7D22;&#x5F15;&#x5230;&#x884C;&#x8BB0;&#x5F55;&#x7684;&#x5BF9;&#x5E94;&#x95EE;&#x9898;&#x3002;&#x5728; go-zero &#x7684;&#x7F13;&#x5B58;&#x8BBE;&#x8BA1;&#x91CC;&#x4E5F;&#x662F;&#x540C;&#x6837;&#x7684;&#x539F;&#x7406;&#x3002;</p>
<p>&#x57FA;&#x4E8E;&#x7D22;&#x5F15;&#x7684;&#x7F13;&#x5B58;&#x53C8;&#x5206;&#x4E3A;&#x5355;&#x5217;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x548C;&#x591A;&#x5217;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#xFF1A;</p>
<p>&#x4F46;&#x662F;&#x5BF9;&#x4E8E; go-zero &#x6765;&#x8BF4;&#xFF0C;&#x5355;&#x5217;&#x548C;&#x591A;&#x5217;&#x53EA;&#x662F;&#x751F;&#x6210;&#x7F13;&#x5B58; key &#x7684;&#x65B9;&#x5F0F;&#x4E0D;&#x540C;&#x800C;&#x5DF2;&#xFF0C;&#x80CC;&#x540E;&#x7684;&#x63A7;&#x5236;&#x903B;&#x8F91;&#x662F;&#x4E00;&#x6837;&#x7684;&#x3002;&#x7136;&#x540E; go-zero &#x5185;&#x7F6E;&#x7684;&#x7F13;&#x5B58;&#x7BA1;&#x7406;&#x5C31;&#x6BD4;&#x8F83;&#x597D;&#x7684;&#x63A7;&#x5236;&#x4E86;&#x6570;&#x636E;&#x4E00;&#x81F4;&#x6027;&#x95EE;&#x9898;&#xFF0C;&#x540C;&#x65F6;&#x4E5F;&#x5185;&#x7F6E;&#x9632;&#x6B62;&#x4E86;&#x7F13;&#x5B58;&#x7684;&#x51FB;&#x7A7F;&#x3001;&#x7A7F;&#x900F;&#x3001;&#x96EA;&#x5D29;&#x95EE;&#x9898;&#xFF08;&#x8FD9;&#x4E9B;&#x5728; gopherchina &#x5927;&#x4F1A;&#x4E0A;&#x5206;&#x4EAB;&#x7684;&#x65F6;&#x5019;&#x4ED4;&#x7EC6;&#x8BB2;&#x8FC7;&#xFF0C;&#x89C1;&#x540E;&#x7EED; gopherchina &#x5206;&#x4EAB;&#x89C6;&#x9891;&#xFF09;&#x3002;</p>
<p>&#x53E6;&#x5916;&#xFF0C;go-zero &#x5185;&#x7F6E;&#x4E86;&#x7F13;&#x5B58;&#x8BBF;&#x95EE;&#x91CF;&#x3001;&#x8BBF;&#x95EE;&#x547D;&#x4E2D;&#x7387;&#x7EDF;&#x8BA1;&#xFF0C;&#x5982;&#x4E0B;&#x6240;&#x793A;&#xFF1A;</p>
<pre class="language-"><code class="lang-text">dbcache(sqlc) - qpm: 5057, hit_ratio: 99.7%, hit: 5044, miss: 13, db_fails: 0
</code></pre>
<p>&#x53EF;&#x4EE5;&#x770B;&#x5230;&#x6BD4;&#x8F83;&#x8BE6;&#x7EC6;&#x7684;&#x7EDF;&#x8BA1;&#x4FE1;&#x606F;&#xFF0C;&#x4FBF;&#x4E8E;&#x6211;&#x4EEC;&#x6765;&#x5206;&#x6790;&#x7F13;&#x5B58;&#x7684;&#x4F7F;&#x7528;&#x60C5;&#x51B5;&#xFF0C;&#x5BF9;&#x4E8E;&#x7F13;&#x5B58;&#x547D;&#x4E2D;&#x7387;&#x6781;&#x4F4E;&#x6216;&#x8005;&#x8BF7;&#x6C42;&#x91CF;&#x6781;&#x5C0F;&#x7684;&#x60C5;&#x51B5;&#xFF0C;&#x6211;&#x4EEC;&#x5C31;&#x53EF;&#x4EE5;&#x53BB;&#x6389;&#x7F13;&#x5B58;&#x4E86;&#xFF0C;&#x8FD9;&#x6837;&#x4E5F;&#x53EF;&#x4EE5;&#x964D;&#x4F4E;&#x6210;&#x672C;&#x3002;</p>
<ul>
<li><p>&#x5355;&#x5217;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre class="language-"><code class="lang-text">UNIQUE KEY `product_idx` (`product`)
</code></pre>
</li>
<li><p>&#x591A;&#x5217;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre class="language-"><code class="lang-text">UNIQUE KEY `vendor_product_idx` (`vendor`, `product`)
</code></pre>
<h2 id="&#x7F13;&#x5B58;&#x4EE3;&#x7801;&#x89E3;&#x8BFB;">&#x7F13;&#x5B58;&#x4EE3;&#x7801;&#x89E3;&#x8BFB;</h2>
</li>
</ul>
<h3 id="1&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#x903B;&#x8F91;">1.&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#x903B;&#x8F91;</h3>
<p><img src="resource/redis-cache-10.png" alt="redis-cache-10"></p>
<p>&#x5177;&#x4F53;&#x5B9E;&#x73B0;&#x4EE3;&#x7801;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre class="language-"><code class="lang-go"><span class="token keyword">func</span> <span class="token punctuation">(</span>cc CachedConn<span class="token punctuation">)</span> <span class="token function">QueryRow</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> key <span class="token builtin">string</span><span class="token punctuation">,</span> query QueryFn<span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
  <span class="token keyword">return</span> cc<span class="token punctuation">.</span>cache<span class="token punctuation">.</span><span class="token function">Take</span><span class="token punctuation">(</span>v<span class="token punctuation">,</span> key<span class="token punctuation">,</span> <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token function">query</span><span class="token punctuation">(</span>cc<span class="token punctuation">.</span>db<span class="token punctuation">,</span> v<span class="token punctuation">)</span>
  <span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token punctuation">}</span>
</code></pre>
<p>&#x8FD9;&#x91CC;&#x7684; <code>Take</code> &#x65B9;&#x6CD5;&#x662F;&#x5148;&#x4ECE;&#x7F13;&#x5B58;&#x91CC;&#x53BB;&#x901A;&#x8FC7; <code>key</code> &#x62FF;&#x6570;&#x636E;&#xFF0C;&#x5982;&#x679C;&#x62FF;&#x5230;&#x5C31;&#x76F4;&#x63A5;&#x8FD4;&#x56DE;&#xFF0C;&#x5982;&#x679C;&#x62FF;&#x4E0D;&#x5230;&#xFF0C;&#x90A3;&#x4E48;&#x5C31;&#x901A;&#x8FC7; <code>query</code> &#x65B9;&#x6CD5;&#x53BB; <code>DB</code> &#x8BFB;&#x53D6;&#x5B8C;&#x6574;&#x884C;&#x8BB0;&#x5F55;&#x5E76;&#x5199;&#x56DE;&#x7F13;&#x5B58;&#xFF0C;&#x7136;&#x540E;&#x518D;&#x8FD4;&#x56DE;&#x6570;&#x636E;&#x3002;&#x6574;&#x4E2A;&#x903B;&#x8F91;&#x8FD8;&#x662F;&#x6BD4;&#x8F83;&#x7B80;&#x5355;&#x6613;&#x61C2;&#x7684;&#x3002;</p>
<p>&#x6211;&#x4EEC;&#x8BE6;&#x7EC6;&#x770B;&#x770B; <code>Take</code> &#x7684;&#x5B9E;&#x73B0;&#xFF1A;</p>
<pre class="language-"><code class="lang-go"><span class="token keyword">func</span> <span class="token punctuation">(</span>c cacheNode<span class="token punctuation">)</span> <span class="token function">Take</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> key <span class="token builtin">string</span><span class="token punctuation">,</span> query <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
  <span class="token keyword">return</span> c<span class="token punctuation">.</span><span class="token function">doTake</span><span class="token punctuation">(</span>v<span class="token punctuation">,</span> key<span class="token punctuation">,</span> query<span class="token punctuation">,</span> <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
    <span class="token keyword">return</span> c<span class="token punctuation">.</span><span class="token function">SetCache</span><span class="token punctuation">(</span>key<span class="token punctuation">,</span> v<span class="token punctuation">)</span>
  <span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token punctuation">}</span>
</code></pre>
<p><code>Take</code> &#x7684;&#x903B;&#x8F91;&#x5982;&#x4E0B;&#xFF1A;</p>
<ul>
<li>&#x7528; key &#x4ECE;&#x7F13;&#x5B58;&#x91CC;&#x67E5;&#x627E;&#x6570;&#x636E;</li>
<li>&#x5982;&#x679C;&#x627E;&#x5230;&#xFF0C;&#x5219;&#x8FD4;&#x56DE;&#x6570;&#x636E;</li>
<li>&#x5982;&#x679C;&#x627E;&#x4E0D;&#x5230;&#xFF0C;&#x7528; query &#x65B9;&#x6CD5;&#x53BB;&#x8BFB;&#x53D6;&#x6570;&#x636E;</li>
<li>&#x8BFB;&#x5230;&#x540E;&#x8C03;&#x7528; c.SetCache(key, v) &#x8BBE;&#x7F6E;&#x7F13;&#x5B58;</li>
</ul>
<p>&#x5176;&#x4E2D;&#x7684; <code>doTake</code> &#x4EE3;&#x7801;&#x548C;&#x89E3;&#x91CA;&#x5982;&#x4E0B;&#xFF1A;</p>
<pre class="language-"><code class="lang-go"><span class="token comment">// v - &#x9700;&#x8981;&#x8BFB;&#x53D6;&#x7684;&#x6570;&#x636E;&#x5BF9;&#x8C61;</span>
<span class="token comment">// key - &#x7F13;&#x5B58;key</span>
<span class="token comment">// query - &#x7528;&#x6765;&#x4ECE;DB&#x8BFB;&#x53D6;&#x5B8C;&#x6574;&#x6570;&#x636E;&#x7684;&#x65B9;&#x6CD5;</span>
<span class="token comment">// cacheVal - &#x7528;&#x6765;&#x5199;&#x7F13;&#x5B58;&#x7684;&#x65B9;&#x6CD5;</span>
<span class="token keyword">func</span> <span class="token punctuation">(</span>c cacheNode<span class="token punctuation">)</span> <span class="token function">doTake</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> key <span class="token builtin">string</span><span class="token punctuation">,</span> query <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span><span class="token punctuation">,</span>
  cacheVal <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
  <span class="token comment">// &#x7528;barrier&#x6765;&#x9632;&#x6B62;&#x7F13;&#x5B58;&#x51FB;&#x7A7F;&#xFF0C;&#x786E;&#x4FDD;&#x4E00;&#x4E2A;&#x8FDB;&#x7A0B;&#x5185;&#x53EA;&#x6709;&#x4E00;&#x4E2A;&#x8BF7;&#x6C42;&#x53BB;&#x52A0;&#x8F7D;key&#x5BF9;&#x5E94;&#x7684;&#x6570;&#x636E;</span>
  val<span class="token punctuation">,</span> fresh<span class="token punctuation">,</span> err <span class="token operator">:=</span> c<span class="token punctuation">.</span>barrier<span class="token punctuation">.</span><span class="token function">DoEx</span><span class="token punctuation">(</span>key<span class="token punctuation">,</span> <span class="token keyword">func</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token comment">// &#x4ECE;cache&#x91CC;&#x8BFB;&#x53D6;&#x6570;&#x636E;</span>
    <span class="token keyword">if</span> err <span class="token operator">:=</span> c<span class="token punctuation">.</span><span class="token function">doGetCache</span><span class="token punctuation">(</span>key<span class="token punctuation">,</span> v<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
      <span class="token comment">// &#x5982;&#x679C;&#x662F;&#x9884;&#x5148;&#x653E;&#x8FDB;&#x6765;&#x7684;placeholder&#xFF08;&#x7528;&#x6765;&#x9632;&#x6B62;&#x7F13;&#x5B58;&#x7A7F;&#x900F;&#xFF09;&#x7684;&#xFF0C;&#x90A3;&#x4E48;&#x5C31;&#x8FD4;&#x56DE;&#x9884;&#x8BBE;&#x7684;errNotFound</span>
      <span class="token comment">// &#x5982;&#x679C;&#x662F;&#x672A;&#x77E5;&#x9519;&#x8BEF;&#xFF0C;&#x90A3;&#x4E48;&#x5C31;&#x76F4;&#x63A5;&#x8FD4;&#x56DE;&#xFF0C;&#x56E0;&#x4E3A;&#x6211;&#x4EEC;&#x4E0D;&#x80FD;&#x653E;&#x5F03;&#x7F13;&#x5B58;&#x51FA;&#x9519;&#x800C;&#x76F4;&#x63A5;&#x628A;&#x6240;&#x6709;&#x8BF7;&#x6C42;&#x53BB;&#x8BF7;&#x6C42;DB&#xFF0C;</span>
      <span class="token comment">// &#x8FD9;&#x6837;&#x5728;&#x9AD8;&#x5E76;&#x53D1;&#x7684;&#x573A;&#x666F;&#x4E0B;&#x4F1A;&#x628A;DB&#x6253;&#x6302;&#x6389;&#x7684;</span>
      <span class="token keyword">if</span> err <span class="token operator">==</span> errPlaceholder <span class="token punctuation">{</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> c<span class="token punctuation">.</span>errNotFound
      <span class="token punctuation">}</span> <span class="token keyword">else</span> <span class="token keyword">if</span> err <span class="token operator">!=</span> c<span class="token punctuation">.</span>errNotFound <span class="token punctuation">{</span>
        <span class="token comment">// why we just return the error instead of query from db,</span>
        <span class="token comment">// because we don&apos;t allow the disaster pass to the DBs.</span>
        <span class="token comment">// fail fast, in case we bring down the dbs.</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
      <span class="token punctuation">}</span>

      <span class="token comment">// &#x8BF7;&#x6C42;DB</span>
      <span class="token comment">// &#x5982;&#x679C;&#x8FD4;&#x56DE;&#x7684;error&#x662F;errNotFound&#xFF0C;&#x90A3;&#x4E48;&#x6211;&#x4EEC;&#x5C31;&#x9700;&#x8981;&#x5728;&#x7F13;&#x5B58;&#x91CC;&#x8BBE;&#x7F6E;placeholder&#xFF0C;&#x9632;&#x6B62;&#x7F13;&#x5B58;&#x7A7F;&#x900F;</span>
      <span class="token keyword">if</span> err <span class="token operator">=</span> <span class="token function">query</span><span class="token punctuation">(</span>v<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">==</span> c<span class="token punctuation">.</span>errNotFound <span class="token punctuation">{</span>
        <span class="token keyword">if</span> err <span class="token operator">=</span> c<span class="token punctuation">.</span><span class="token function">setCacheWithNotFound</span><span class="token punctuation">(</span>key<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
          logx<span class="token punctuation">.</span><span class="token function">Error</span><span class="token punctuation">(</span>err<span class="token punctuation">)</span>
        <span class="token punctuation">}</span>

        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> c<span class="token punctuation">.</span>errNotFound
      <span class="token punctuation">}</span> <span class="token keyword">else</span> <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        <span class="token comment">// &#x7EDF;&#x8BA1;DB&#x5931;&#x8D25;</span>
        c<span class="token punctuation">.</span>stat<span class="token punctuation">.</span><span class="token function">IncrementDbFails</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
      <span class="token punctuation">}</span>

      <span class="token comment">// &#x628A;&#x6570;&#x636E;&#x5199;&#x5165;&#x7F13;&#x5B58;</span>
      <span class="token keyword">if</span> err <span class="token operator">=</span> <span class="token function">cacheVal</span><span class="token punctuation">(</span>v<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        logx<span class="token punctuation">.</span><span class="token function">Error</span><span class="token punctuation">(</span>err<span class="token punctuation">)</span>
      <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>

    <span class="token comment">// &#x8FD4;&#x56DE;json&#x5E8F;&#x5217;&#x5316;&#x7684;&#x6570;&#x636E;</span>
    <span class="token keyword">return</span> jsonx<span class="token punctuation">.</span><span class="token function">Marshal</span><span class="token punctuation">(</span>v<span class="token punctuation">)</span>
  <span class="token punctuation">}</span><span class="token punctuation">)</span>
  <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
    <span class="token keyword">return</span> err
  <span class="token punctuation">}</span>
  <span class="token keyword">if</span> fresh <span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token boolean">nil</span>
  <span class="token punctuation">}</span>

  <span class="token comment">// got the result from previous ongoing query</span>
  c<span class="token punctuation">.</span>stat<span class="token punctuation">.</span><span class="token function">IncrementTotal</span><span class="token punctuation">(</span><span class="token punctuation">)</span>
  c<span class="token punctuation">.</span>stat<span class="token punctuation">.</span><span class="token function">IncrementHit</span><span class="token punctuation">(</span><span class="token punctuation">)</span>

  <span class="token comment">// &#x628A;&#x6570;&#x636E;&#x5199;&#x5165;&#x5230;&#x4F20;&#x5165;&#x7684;v&#x5BF9;&#x8C61;&#x91CC;</span>
  <span class="token keyword">return</span> jsonx<span class="token punctuation">.</span><span class="token function">Unmarshal</span><span class="token punctuation">(</span>val<span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token builtin">byte</span><span class="token punctuation">)</span><span class="token punctuation">,</span> v<span class="token punctuation">)</span>
<span class="token punctuation">}</span>
</code></pre>
<h3 id="2-&#x57FA;&#x4E8E;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x7684;&#x7F13;&#x5B58;&#x903B;&#x8F91;">2. &#x57FA;&#x4E8E;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x7684;&#x7F13;&#x5B58;&#x903B;&#x8F91;</h3>
<p>&#x56E0;&#x4E3A;&#x8FD9;&#x5757;&#x6BD4;&#x8F83;&#x590D;&#x6742;&#xFF0C;&#x6240;&#x4EE5;&#x6211;&#x7528;&#x4E0D;&#x540C;&#x989C;&#x8272;&#x6807;&#x8BC6;&#x51FA;&#x6765;&#x4E86;&#x54CD;&#x5E94;&#x7684;&#x4EE3;&#x7801;&#x5757;&#x548C;&#x903B;&#x8F91;&#xFF0C;<code>block 2</code> &#x5176;&#x5B9E;&#x8DDF;&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#x662F;&#x4E00;&#x6837;&#x7684;&#xFF0C;&#x8FD9;&#x91CC;&#x4E3B;&#x8981;&#x8BB2; <code>block 1</code> &#x7684;&#x903B;&#x8F91;&#x3002;
<img src="resource/redis-cache-11.webp" alt="redis-cache-11"></p>
<p>&#x4EE3;&#x7801;&#x5757;&#x7684; block 1 &#x90E8;&#x5206;&#x5206;&#x4E3A;&#x4E24;&#x79CD;&#x60C5;&#x51B5;&#xFF1A;</p>
<ul>
<li><p>&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x80FD;&#x591F;&#x4ECE;&#x7F13;&#x5B58;&#x91CC;&#x627E;&#x5230;&#x4E3B;&#x952E;&#xFF0C;&#x6B64;&#x65F6;&#x5C31;&#x76F4;&#x63A5;&#x7528;&#x4E3B;&#x952E;&#x8D70; <code>block 2</code> &#x7684;&#x903B;&#x8F91;&#x4E86;&#xFF0C;&#x540E;&#x7EED;&#x540C;&#x4E0A;&#x9762;&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#x903B;&#x8F91;</p>
</li>
<li><p>&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x65E0;&#x6CD5;&#x4ECE;&#x7F13;&#x5B58;&#x91CC;&#x627E;&#x5230;&#x4E3B;&#x952E;</p>
<ul>
<li>&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x4ECE;DB&#x91CC;&#x67E5;&#x8BE2;&#x5B8C;&#x6574;&#x884C;&#x8BB0;&#x5F55;&#xFF0C;&#x5982;&#x6709; <code>error</code>&#xFF0C;&#x8FD4;&#x56DE;</li>
<li>&#x67E5;&#x5230;&#x5B8C;&#x6574;&#x884C;&#x8BB0;&#x5F55;&#x540E;&#xFF0C;&#x4F1A;&#x628A;&#x4E3B;&#x952E;&#x5230;&#x5B8C;&#x6574;&#x884C;&#x8BB0;&#x5F55;&#x7684;&#x7F13;&#x5B58;&#x548C;&#x7D22;&#x5F15;&#x5230;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#x540C;&#x65F6;&#x5199;&#x5230; <code>redis</code> &#x91CC;</li>
<li>&#x8FD4;&#x56DE;&#x6240;&#x9700;&#x7684;&#x884C;&#x8BB0;&#x5F55;&#x6570;&#x636E;</li>
</ul>
</li>
</ul>
<pre class="language-"><code class="lang-go"><span class="token comment">// v - &#x9700;&#x8981;&#x8BFB;&#x53D6;&#x7684;&#x6570;&#x636E;&#x5BF9;&#x8C61;</span>
<span class="token comment">// key - &#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x751F;&#x6210;&#x7684;&#x7F13;&#x5B58;key</span>
<span class="token comment">// keyer - &#x7528;&#x4E3B;&#x952E;&#x751F;&#x6210;&#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7F13;&#x5B58;&#x7684;key&#x7684;&#x65B9;&#x6CD5;</span>
<span class="token comment">// indexQuery - &#x7528;&#x7D22;&#x5F15;&#x4ECE;DB&#x8BFB;&#x53D6;&#x5B8C;&#x6574;&#x6570;&#x636E;&#x7684;&#x65B9;&#x6CD5;&#xFF0C;&#x9700;&#x8981;&#x8FD4;&#x56DE;&#x4E3B;&#x952E;</span>
<span class="token comment">// primaryQuery - &#x7528;&#x4E3B;&#x952E;&#x4ECE;DB&#x83B7;&#x53D6;&#x5B8C;&#x6574;&#x6570;&#x636E;&#x7684;&#x65B9;&#x6CD5;</span>
<span class="token keyword">func</span> <span class="token punctuation">(</span>cc CachedConn<span class="token punctuation">)</span> <span class="token function">QueryRowIndex</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> key <span class="token builtin">string</span><span class="token punctuation">,</span> keyer <span class="token keyword">func</span><span class="token punctuation">(</span>primary <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">string</span><span class="token punctuation">,</span>
  indexQuery IndexQueryFn<span class="token punctuation">,</span> primaryQuery PrimaryQueryFn<span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
  <span class="token keyword">var</span> primaryKey <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span>
  <span class="token keyword">var</span> found <span class="token builtin">bool</span>

  <span class="token comment">// &#x5148;&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x67E5;&#x8BE2;&#x7F13;&#x5B58;&#xFF0C;&#x770B;&#x662F;&#x5426;&#x6709;&#x7D22;&#x5F15;&#x5230;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;</span>
  <span class="token keyword">if</span> err <span class="token operator">:=</span> cc<span class="token punctuation">.</span>cache<span class="token punctuation">.</span><span class="token function">TakeWithExpire</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>primaryKey<span class="token punctuation">,</span> key<span class="token punctuation">,</span> <span class="token keyword">func</span><span class="token punctuation">(</span>val <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> expire time<span class="token punctuation">.</span>Duration<span class="token punctuation">)</span> <span class="token punctuation">(</span>err <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
    <span class="token comment">// &#x5982;&#x679C;&#x6CA1;&#x6709;&#x7D22;&#x5F15;&#x5230;&#x4E3B;&#x952E;&#x7684;&#x7F13;&#x5B58;&#xFF0C;&#x90A3;&#x4E48;&#x5C31;&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x67E5;&#x8BE2;&#x5B8C;&#x6574;&#x6570;&#x636E;</span>
    primaryKey<span class="token punctuation">,</span> err <span class="token operator">=</span> <span class="token function">indexQuery</span><span class="token punctuation">(</span>cc<span class="token punctuation">.</span>db<span class="token punctuation">,</span> v<span class="token punctuation">)</span>
    <span class="token keyword">if</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
      <span class="token keyword">return</span>
    <span class="token punctuation">}</span>

    <span class="token comment">// &#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x67E5;&#x8BE2;&#x5230;&#x4E86;&#x5B8C;&#x6574;&#x6570;&#x636E;&#xFF0C;&#x8BBE;&#x7F6E;found&#xFF0C;&#x540E;&#x9762;&#x76F4;&#x63A5;&#x4F7F;&#x7528;&#xFF0C;&#x4E0D;&#x9700;&#x8981;&#x518D;&#x4ECE;&#x7F13;&#x5B58;&#x8BFB;&#x53D6;&#x6570;&#x636E;&#x4E86;</span>
    found <span class="token operator">=</span> <span class="token boolean">true</span>
    <span class="token comment">// &#x5C06;&#x4E3B;&#x952E;&#x5230;&#x5B8C;&#x6574;&#x6570;&#x636E;&#x7684;&#x6620;&#x5C04;&#x4FDD;&#x5B58;&#x5230;&#x7F13;&#x5B58;&#x91CC;&#xFF0C;TakeWithExpire&#x65B9;&#x6CD5;&#x5DF2;&#x7ECF;&#x5C06;&#x7D22;&#x5F15;&#x5230;&#x4E3B;&#x952E;&#x7684;&#x6620;&#x5C04;&#x4FDD;&#x5B58;&#x5230;&#x7F13;&#x5B58;&#x4E86;</span>
    <span class="token keyword">return</span> cc<span class="token punctuation">.</span>cache<span class="token punctuation">.</span><span class="token function">SetCacheWithExpire</span><span class="token punctuation">(</span><span class="token function">keyer</span><span class="token punctuation">(</span>primaryKey<span class="token punctuation">)</span><span class="token punctuation">,</span> v<span class="token punctuation">,</span> expire<span class="token operator">+</span>cacheSafeGapBetweenIndexAndPrimary<span class="token punctuation">)</span>
  <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
    <span class="token keyword">return</span> err
  <span class="token punctuation">}</span>

  <span class="token comment">// &#x5DF2;&#x7ECF;&#x901A;&#x8FC7;&#x7D22;&#x5F15;&#x627E;&#x5230;&#x4E86;&#x6570;&#x636E;&#xFF0C;&#x76F4;&#x63A5;&#x8FD4;&#x56DE;&#x5373;&#x53EF;</span>
  <span class="token keyword">if</span> found <span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token boolean">nil</span>
  <span class="token punctuation">}</span>

  <span class="token comment">// &#x901A;&#x8FC7;&#x4E3B;&#x952E;&#x4ECE;&#x7F13;&#x5B58;&#x8BFB;&#x53D6;&#x6570;&#x636E;&#xFF0C;&#x5982;&#x679C;&#x7F13;&#x5B58;&#x6CA1;&#x6709;&#xFF0C;&#x901A;&#x8FC7;primaryQuery&#x65B9;&#x6CD5;&#x4ECE;DB&#x8BFB;&#x53D6;&#x5E76;&#x56DE;&#x5199;&#x7F13;&#x5B58;&#x518D;&#x8FD4;&#x56DE;&#x6570;&#x636E;</span>
  <span class="token keyword">return</span> cc<span class="token punctuation">.</span>cache<span class="token punctuation">.</span><span class="token function">Take</span><span class="token punctuation">(</span>v<span class="token punctuation">,</span> <span class="token function">keyer</span><span class="token punctuation">(</span>primaryKey<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token keyword">func</span><span class="token punctuation">(</span>v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token function">primaryQuery</span><span class="token punctuation">(</span>cc<span class="token punctuation">.</span>db<span class="token punctuation">,</span> v<span class="token punctuation">,</span> primaryKey<span class="token punctuation">)</span>
  <span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token punctuation">}</span>
</code></pre>
<p>&#x6211;&#x4EEC;&#x6765;&#x770B;&#x4E00;&#x4E2A;&#x5B9E;&#x9645;&#x7684;&#x4F8B;&#x5B50;</p>
<pre class="language-"><code class="lang-go"><span class="token keyword">func</span> <span class="token punctuation">(</span>m <span class="token operator">*</span>defaultUserModel<span class="token punctuation">)</span> <span class="token function">FindOneByUser</span><span class="token punctuation">(</span>user <span class="token builtin">string</span><span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token operator">*</span>User<span class="token punctuation">,</span> <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
  <span class="token keyword">var</span> resp User
  <span class="token comment">// &#x751F;&#x6210;&#x57FA;&#x4E8E;&#x7D22;&#x5F15;&#x7684;key</span>
  indexKey <span class="token operator">:=</span> fmt<span class="token punctuation">.</span><span class="token function">Sprintf</span><span class="token punctuation">(</span><span class="token string">&quot;%s%v&quot;</span><span class="token punctuation">,</span> cacheUserPrefix<span class="token punctuation">,</span> user<span class="token punctuation">)</span>

  err <span class="token operator">:=</span> m<span class="token punctuation">.</span><span class="token function">QueryRowIndex</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>resp<span class="token punctuation">,</span> indexKey<span class="token punctuation">,</span>
    <span class="token comment">// &#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x751F;&#x6210;&#x5B8C;&#x6574;&#x6570;&#x636E;&#x7F13;&#x5B58;&#x7684;key</span>
    <span class="token keyword">func</span><span class="token punctuation">(</span>primary <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">string</span> <span class="token punctuation">{</span>
      <span class="token keyword">return</span> fmt<span class="token punctuation">.</span><span class="token function">Sprintf</span><span class="token punctuation">(</span><span class="token string">&quot;user#%v&quot;</span><span class="token punctuation">,</span> primary<span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token comment">// &#x57FA;&#x4E8E;&#x7D22;&#x5F15;&#x7684;DB&#x67E5;&#x8BE2;&#x65B9;&#x6CD5;</span>
    <span class="token keyword">func</span><span class="token punctuation">(</span>conn sqlx<span class="token punctuation">.</span>SqlConn<span class="token punctuation">,</span> v <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token punctuation">(</span>i <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> e <span class="token builtin">error</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
      query <span class="token operator">:=</span> fmt<span class="token punctuation">.</span><span class="token function">Sprintf</span><span class="token punctuation">(</span><span class="token string">&quot;select %s from %s where user = ? limit 1&quot;</span><span class="token punctuation">,</span> userRows<span class="token punctuation">,</span> m<span class="token punctuation">.</span>table<span class="token punctuation">)</span>
      <span class="token keyword">if</span> err <span class="token operator">:=</span> conn<span class="token punctuation">.</span><span class="token function">QueryRow</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>resp<span class="token punctuation">,</span> query<span class="token punctuation">,</span> user<span class="token punctuation">)</span><span class="token punctuation">;</span> err <span class="token operator">!=</span> <span class="token boolean">nil</span> <span class="token punctuation">{</span>
        <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
      <span class="token punctuation">}</span>
      <span class="token keyword">return</span> resp<span class="token punctuation">.</span>Id<span class="token punctuation">,</span> <span class="token boolean">nil</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token comment">// &#x57FA;&#x4E8E;&#x4E3B;&#x952E;&#x7684;DB&#x67E5;&#x8BE2;&#x65B9;&#x6CD5;</span>
    <span class="token keyword">func</span><span class="token punctuation">(</span>conn sqlx<span class="token punctuation">.</span>SqlConn<span class="token punctuation">,</span> v<span class="token punctuation">,</span> primary <span class="token keyword">interface</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token builtin">error</span> <span class="token punctuation">{</span>
      query <span class="token operator">:=</span> fmt<span class="token punctuation">.</span><span class="token function">Sprintf</span><span class="token punctuation">(</span><span class="token string">&quot;select %s from %s where id = ?&quot;</span><span class="token punctuation">,</span> userRows<span class="token punctuation">,</span> m<span class="token punctuation">.</span>table<span class="token punctuation">)</span>
      <span class="token keyword">return</span> conn<span class="token punctuation">.</span><span class="token function">QueryRow</span><span class="token punctuation">(</span><span class="token operator">&amp;</span>resp<span class="token punctuation">,</span> query<span class="token punctuation">,</span> primary<span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span>

  <span class="token comment">// &#x9519;&#x8BEF;&#x5904;&#x7406;&#xFF0C;&#x9700;&#x8981;&#x5224;&#x65AD;&#x662F;&#x5426;&#x8FD4;&#x56DE;&#x7684;&#x662F;sqlc.ErrNotFound&#xFF0C;&#x5982;&#x679C;&#x662F;&#xFF0C;&#x6211;&#x4EEC;&#x7528;&#x672C;package&#x5B9A;&#x4E49;&#x7684;ErrNotFound&#x8FD4;&#x56DE;</span>
  <span class="token comment">// &#x907F;&#x514D;&#x4F7F;&#x7528;&#x8005;&#x611F;&#x77E5;&#x5230;&#x6709;&#x6CA1;&#x6709;&#x4F7F;&#x7528;&#x7F13;&#x5B58;&#xFF0C;&#x540C;&#x65F6;&#x4E5F;&#x662F;&#x5BF9;&#x5E95;&#x5C42;&#x4F9D;&#x8D56;&#x7684;&#x9694;&#x79BB;</span>
  <span class="token keyword">switch</span> err <span class="token punctuation">{</span>
    <span class="token keyword">case</span> <span class="token boolean">nil</span><span class="token punctuation">:</span>
      <span class="token keyword">return</span> <span class="token operator">&amp;</span>resp<span class="token punctuation">,</span> <span class="token boolean">nil</span>
    <span class="token keyword">case</span> sqlc<span class="token punctuation">.</span>ErrNotFound<span class="token punctuation">:</span>
      <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> ErrNotFound
    <span class="token keyword">default</span><span class="token punctuation">:</span>
      <span class="token keyword">return</span> <span class="token boolean">nil</span><span class="token punctuation">,</span> err
  <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre>
<p>&#x6240;&#x6709;&#x4E0A;&#x9762;&#x8FD9;&#x4E9B;&#x7F13;&#x5B58;&#x7684;&#x81EA;&#x52A8;&#x7BA1;&#x7406;&#x4EE3;&#x7801;&#x90FD;&#x662F;&#x53EF;&#x4EE5;&#x901A;&#x8FC7; <a href="goctl.html">goctl</a> &#x81EA;&#x52A8;&#x751F;&#x6210;&#x7684;&#xFF0C;&#x6211;&#x4EEC;&#x56E2;&#x961F;&#x5185;&#x90E8; <code>CRUD</code> &#x548C;&#x7F13;&#x5B58;&#x57FA;&#x672C;&#x90FD;&#x662F;&#x901A;&#x8FC7; <a href="goctl.html">goctl</a> &#x81EA;&#x52A8;&#x751F;&#x6210;&#x7684;&#xFF0C;&#x53EF;&#x4EE5;&#x8282;&#x7701;&#x5927;&#x91CF;&#x5F00;&#x53D1;&#x65F6;&#x95F4;&#xFF0C;&#x5E76;&#x4E14;&#x7F13;&#x5B58;&#x4EE3;&#x7801;&#x672C;&#x8EAB;&#x4E5F;&#x662F;&#x975E;&#x5E38;&#x5BB9;&#x6613;&#x51FA;&#x9519;&#x7684;&#xFF0C;&#x5373;&#x4F7F;&#x6709;&#x5F88;&#x597D;&#x7684;&#x4EE3;&#x7801;&#x7ECF;&#x9A8C;&#xFF0C;&#x4E5F;&#x5F88;&#x96BE;&#x6BCF;&#x6B21;&#x5B8C;&#x5168;&#x5199;&#x5BF9;&#xFF0C;&#x6240;&#x4EE5;&#x6211;&#x4EEC;&#x63A8;&#x8350;&#x5C3D;&#x53EF;&#x80FD;&#x4F7F;&#x7528;&#x81EA;&#x52A8;&#x7684;&#x7F13;&#x5B58;&#x4EE3;&#x7801;&#x751F;&#x6210;&#x5DE5;&#x5177;&#x53BB;&#x907F;&#x514D;&#x9519;&#x8BEF;&#x3002;</p>
<h1 id="&#x731C;&#x4F60;&#x60F3;&#x770B;">&#x731C;&#x4F60;&#x60F3;&#x770B;</h1>
<ul>
<li><a href="https://www.bilibili.com/video/BV1Jy4y127Xu" target="_blank">Go&#x5F00;&#x6E90;&#x8BF4;&#x7B2C;&#x56DB;&#x671F;-go-zero&#x7F13;&#x5B58;&#x5982;&#x4F55;&#x8BBE;&#x8BA1;</a></li>
<li><a href="goctl.html">Goctl</a>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/gitalk@1/dist/gitalk.css"><script src="./javascript/gitalk.js"></script>
<div id="gitalk-container"></div>
<script>
var gitalk = new Gitalk({
"clientID": "b9f61eecd453fb93cefc",
"clientSecret": "8e70a3944fa689c13136aa56ea5bfb9945802bd2",
"repo": "go-zero-doc",
"owner": "zeromicro",
"admin": ["anqiansong"],
"id": window.location.pathname,      
"distractionFreeMode": false  
});
gitalk.render("gitalk-container");
</script>


</li>
</ul>
<footer class="page-footer"><span class="copyright">Copyright &#xA9; 2019-2021 go-zero all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x6700;&#x540E;&#x66F4;&#x65B0;&#x65F6;&#x95F4;&#xFF1A;
2021-04-10 07:21:07
</span></footer>
<script>console.log("plugin-popup....");document.onclick = function(e){ e.target.tagName === "IMG" && window.open(e.target.src,e.target.src)}</script><style>img{cursor:pointer}</style>
                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                <a href="practise.html" class="navigation navigation-prev " aria-label="Previous page: 开发实践">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="buiness-cache.html" class="navigation navigation-next " aria-label="Next page: go-zero缓存设计之业务层缓存">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"go-zero缓存设计之持久层缓存","level":"1.13.1","depth":2,"next":{"title":"go-zero缓存设计之业务层缓存","level":"1.13.2","depth":2,"path":"buiness-cache.md","ref":"buiness-cache.md","articles":[]},"previous":{"title":"开发实践","level":"1.13","depth":1,"path":"practise.md","ref":"practise.md","articles":[{"title":"go-zero缓存设计之持久层缓存","level":"1.13.1","depth":2,"path":"redis-cache.md","ref":"redis-cache.md","articles":[]},{"title":"go-zero缓存设计之业务层缓存","level":"1.13.2","depth":2,"path":"buiness-cache.md","ref":"buiness-cache.md","articles":[]},{"title":"go-zero分布式定时任务","level":"1.13.3","depth":2,"path":"go-queue.md","ref":"go-queue.md","articles":[]},{"title":"我是如何用go-zero 实现一个中台系统","level":"1.13.4","depth":2,"path":"datacenter.md","ref":"datacenter.md","articles":[]},{"title":"流数据处理利器","level":"1.13.5","depth":2,"path":"stream.md","ref":"stream.md","articles":[]},{"title":"10月3日线上交流问题汇总","level":"1.13.6","depth":2,"path":"online-exchange.md","ref":"online-exchange.md","articles":[]}]},"dir":"ltr"},"config":{"plugins":["back-to-top-button","chapter-fold","code","-lunr","-search","search-pro","github","splitter","-sharing","sharing-plus","tbfed-pagefooter","flexible-alerts","page-toc-button","pageview-count","popup","hide-element","edit-link","-highlight","prism","theme-comscore"],"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"Copyright © 2019-2021 go-zero","modify_label":"最后更新时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"chapter-fold":{},"prism":{"lang":{"shell":"bash"},"css":["prismjs/themes/prism-tomorrow.css"]},"github":{"url":"https://github.com/tal-tech/go-zero"},"splitter":{},"search-pro":{},"sharing-plus":{"qq":false,"all":["facebook","google","twitter","instapaper","linkedin","pocket","stumbleupon"],"douban":false,"facebook":true,"weibo":false,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":true,"messenger":false,"line":false,"vk":false,"pocket":true,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":false},"popup":{},"code":{"copyButtons":true},"hide-element":{"elements":[".gitbook-link"]},"fontsettings":{"theme":"white","family":"sans","size":2},"theme-comscore":{},"page-toc-button":{"maxTocDepth":2,"minTocSize":2},"back-to-top-button":{},"pageview-count":{},"flexible-alerts":{"danger":{"className":"danger","icon":"fa fa-ban","label":"Attention"},"note":{"className":"info","icon":"fa fa-info-circle","label":"Note"},"style":"callout","tip":{"className":"tip","icon":"fa fa-lightbulb-o","label":"Tip"},"warning":{"className":"warning","icon":"fa fa-exclamation-triangle","label":"Warning"}},"sharing":{"qq":false,"all":["douban","facebook","google","linkedin","twitter","weibo","qq","qzone","weibo"],"douban":false,"facebook":false,"weibo":true,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":false,"messenger":false,"line":true,"vk":false,"pocket":false,"google":true,"viber":false,"stumbleupon":false,"qzone":true,"linkedin":true},"edit-link":{"label":"编辑此页","base":"https://github.com/zeromicro/go-zero-doc/blob/master"},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false}},"theme":"default","author":"松妹子","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"go-zero使用文档","language":"zh-hans","gitbook":"3.2.3"},"file":{"path":"redis-cache.md","mtime":"2021-04-10T07:21:07.996Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2021-04-10T07:22:08.598Z"},"basePath":".","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="gitbook/gitbook.js"></script>
    <script src="gitbook/theme.js"></script>
    
        
        <script src="gitbook/gitbook-plugin-back-to-top-button/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-chapter-fold/chapter-fold.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-code/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-search-pro/jquery.mark.min.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-search-pro/search.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-sharing-plus/buttons.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-flexible-alerts/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-page-toc-button/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-pageview-count/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-hide-element/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-edit-link/plugin.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    
        <script src="gitbook/gitbook-plugin-theme-comscore/test.js"></script>
        
    
    </body>
</html>