{"id":42207,"date":"2023-08-21T22:53:34","date_gmt":"2023-04-23T23:51:30","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/"},"modified":"2024-04-30T19:33:14","modified_gmt":"2024-04-30T11:33:14","slug":"%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/","title":{"rendered":"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c"},"content":{"rendered":"

\u7ecf\u8fc7\/\u7ecf\u5386<\/h1>\n

\u6700\u8fd1\uff0c\u6211\u6b63\u5728\u5bf9\u6570\u636e\u4ed3\u5e93\u7684\u5efa\u8bbe\u548c\u9009\u62e9\u8fdb\u884c\u5404\u79cd\u8c03\u7814\u3002
\n\u5728\u7ecf\u8fc7\u65f6\u95f4\u7684\u53d1\u5c55\uff0c\u4e00\u4e2a\u6210\u957f\u8d77\u6765\u7684\u7ec4\u7ec7\u901a\u5e38\u4f1a\u5b58\u5728\u5404\u79cd\u4e0d\u540c\u7684\u6570\u636e\u5e93\u3002
\n\u8fd9\u4e9b\u6570\u636e\u5e93\u4e4b\u95f4\u5b58\u5728\u7740\u7279\u6027\u3001\u64c5\u957f\u4e0e\u4e0d\u64c5\u957f\u4ee5\u53ca\u4f4d\u7f6e\u4e0a\u7684\u5dee\u5f02\uff08OLAP\uff0cOLTP\uff0cKVS\uff0c\u6587\u6863\u6570\u636e\u5e93\uff0c\u4e91\u7aef\uff0c\u672c\u5730…\uff09\uff0c\u6bcf\u79cd\u5dee\u5f02\u90fd\u5177\u6709\u5408\u7406\u7684\u610f\u4e49\u3002<\/p>\n

\u7136\u800c\u5bf9\u4e8e\u6570\u636e\u5206\u6790\u5e08\u6765\u8bf4\uff0c\u5c06\u8fd9\u4e9b\u5404\u4e2a\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u7684\u6570\u636e\u89c6\u4e3a\u4e00\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u5206\u6790\u4f1a\u66f4\u52a0\u65b9\u4fbf\u3002<\/p>\n

\u5c06\u4e0d\u540c\u7684\u6570\u636e\u5e93\u89c6\u4e3a\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/h2>\n

Embulk \u3092\u6d3b\u7528\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u3068\u306a\u308b DB \u306b\u30c7\u30fc\u30bf\u3092\u5b9a\u671f\u7684\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3002<\/p>\n

Presto \u3092\u6d3b\u7528\u3057\u3066\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5206\u6563\u30af\u30a8\u30ea\u3092\u8d70\u3089\u305b Presto Server \u4e0a\u3067\u7d50\u5408\u51e6\u7406\u3059\u308b<\/p>\n

PostgreSQL \u306e FDW \u3092\u3064\u304b\u3046 \u2190 \u3053\u306e\u8a18\u4e8b\u306f\u3053\u308c<\/p>\n

\u4ed6\u306b\u3082\u3001\u3084\u308a\u65b9\u306f\u3044\u308d\u3044\u308d\u3068\u3042\u308a\u305d\u3046\u3002<\/p>\n

PostgreSQL\u7684FDW\u662f\u4ec0\u4e48\uff1f<\/h1>\n

PostgreSQL \u7684 FDW\uff08Foreign Data Wrapper\uff09\u662f\u6307\u4e00\u4e2a\u529f\u80fd\uff0c\u5b83\u53ef\u4ee5\u8ba9 PostgreSQL \u8bfb\u53d6\u548c\u5199\u5165\u4f4d\u4e8e\u4e0d\u540c\u6570\u636e\u6e90\u4e2d\u7684\u6570\u636e\uff0c\u6b63\u5982\u5176\u540d\u79f0\u6240\u793a\u3002<\/p>\n

\u8bd5\u8bd5\u770b<\/h1>\n

\u7528docker-compose\u8f7b\u677e\u5c1d\u8bd5\u4e00\u4e0b\u3002
\nDockerfile\u770b\u8d77\u6765\u662f\u8fd9\u6837\u7684\u3002<\/p>\n

FROM<\/span> quay.io\/aptible\/postgresql:9.5-contrib<\/span>\r\nENV<\/span> DEBIAN_FRONTEND=noninteractive<\/span>\r\nRUN <\/span>apt-get update \\\r\n<\/span> &&<\/span> apt-get -y<\/span> install <\/span>git gcc make libhiredis-dev \\\r\n<\/span> &&<\/span> mkdir<\/span> -p<\/span> \/inst\/ \\\r\n<\/span> &&<\/span> cd<\/span> \/inst \\\r\n<\/span> &&<\/span> git clone https:\/\/github.com\/pg-redis-fdw\/redis_fdw.git --branch<\/span> REL9_5_STABLE --single-branch<\/span> \\\r\n<\/span> &&<\/span> cd<\/span> \/inst\/redis_fdw \\\r\n<\/span> &&<\/span> PATH<\/span>=<\/span>\/usr\/local\/postgresql\/bin\/:$PATH<\/span> make USE_PGXS<\/span>=<\/span>1 \\\r\n<\/span> &&<\/span> PATH<\/span>=<\/span>\/usr\/local\/postgresql\/bin\/:$PATH<\/span> make USE_PGXS<\/span>=<\/span>1 install<\/span> \\\r\n<\/span> &&<\/span> apt-get purge -y<\/span> --auto-remove<\/span> git gcc make \\\r\n<\/span> &&<\/span> rm<\/span> -Rf<\/span> \/inst\r\n<\/code><\/pre>\n
\u6709\u4e00\u4e2a\u540d\u4e3a quay.io\/aptible\/postgresql:9.5-contrib \u7684\u955c\u50cf\uff0c\u5176\u5305\u542b\u4e86 tds_fdw \u548c mysql_fdw\u3002\u53e6\u5916\u8fd8\u6709\u4e00\u4e2a\u540d\u4e3a rungeict\/postgres-redis \u7684 Dockerfile\uff0c\u7528\u4e8e\u5b89\u88c5 redis_fdw\u3002\u6211\u5c06\u5b83\u4eec\u7ec4\u5408\u5728\u4e00\u8d77\u521b\u5efa\u4e86\u4e00\u4e2a\u955c\u50cf\u3002<\/p>\n
\u5982\u679c\u60a8\u5e0c\u671b\u67e5\u770b\u5269\u4f59\u6240\u6709\u7684\u6e90\u4ee3\u7801\uff0c\u8bf7\u53c2\u8003 kitsuyui\/testing-fdw\u3002<\/p>\n
    \n
  • \n
      Redis<\/ul>\n<\/li>\n<\/ul>\n
       <\/p>\n
        \n
      • \n
          MySQL<\/ul>\n<\/li>\n<\/ul>\n
           <\/p>\n
            PostgreSQL<\/ul>\n
            \u4f7f\u7528\u8fd9\u6837\u5f62\u5f0f\u7684 SQL\uff0c\u5c06\u8fd9 3 \u4e2a\u8868 JOIN \u8d77\u6765\u540e\uff0c\u6ca1\u6709\u9047\u5230\u4efb\u4f55\u95ee\u9898\uff0c\u53ef\u4ee5\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n
                SELECT<\/span> *<\/span>\r\n      FROM<\/span> sample_redis<\/span> AS<\/span> SR<\/span>\r\nINNER<\/span> JOIN<\/span> sample_mysql<\/span> AS<\/span> SM<\/span>\r\n        ON<\/span> SR<\/span>.<\/span>val<\/span>::<\/span>int<\/span> =<\/span> SM<\/span>.<\/span>id<\/span>\r\nINNER<\/span> JOIN<\/span> sample_postgres<\/span> AS<\/span> SP<\/span>\r\n        ON<\/span> SR<\/span>.<\/span>key<\/span> =<\/span> SP<\/span>.<\/span>id<\/span>\r\n<\/code><\/pre>\n
            \u6837\u672c_redis\u3001\u6837\u672c_mysql\u3001\u6837\u672c_postgres\u5206\u522b\u662f\u5b58\u5728\u4e8eRedis\u3001MySQL\u548cPostgreSQL\u4e0a\u7684\u8868\u683c\u3002\uff08\u5bf9\u4e8eRedis\u6765\u8bf4\uff0c\u4e25\u683c\u6765\u8bf4\u4e0d\u662f\u8868\u683c\uff09<\/p>\n
            \u7528\u6cd5<\/h3>\n
            \u8bbe\u7f6e\u4e86\u901a\u8fc7startup.sh\u542f\u52a8\u3002
            \nhttps:\/\/github.com\/kitsuyui\/testing-fdw\/blob\/master\/fdwpostgres.sql \u662f\u5728PostgreSQL\u4e2d\u53d1\u51fa\u7684\u67e5\u8be2\u3002<\/p>\n
            \u521b\u5efa\u670d\u52a1\u5668<\/h2>\n
            \u6ce8\u518c\u5916\u90e8\u670d\u52a1\u5668\u5b9a\u4e49\u3002\u672c\u6b21\u4f8b\u5b50\u4e2d\u6ce8\u518c\u4e86Redis\u548cMySQL\u4f5c\u4e3a\u5916\u90e8\u670d\u52a1\u5668\u3002<\/p>\n
            \u4e3a…\u670d\u52a1\u5668\u521b\u5efa\u7528\u6237\u6620\u5c04\u3002<\/h2>\n
            \u8fd9\u662f\u63d0\u4f9b\u767b\u5f55\u5230\u5df2\u5728\u4e0a\u8ff0\u5904\u5b9a\u4e49\u7684\u5916\u90e8\u670d\u52a1\u5668\u6240\u9700\u7684\u4fe1\u606f\u3002<\/p>\n
            \u8fd9\u6b21\u662f\u4ee5\u516c\u5f00\u5f62\u5f0f\u8fdb\u884c\u7684\uff0c\u4f46\u4e3a\u4e86\u6bcf\u4e2a\u7528\u6237\u505a\u597d\u533a\u5206\uff0c\u9700\u8981\u5c06\u4e4b\u6539\u4e3a FOR <\u7528\u6237\u540d> \u3002
            \n\u9009\u9879\u5c06\u5206\u522b\u6210\u4e3a\u6bcf\u4e2a\u670d\u52a1\u5668\u6240\u9700\u7684\u767b\u5f55\u4fe1\u606f\u3002<\/p>\n
            \u521b\u5efa\u5916\u90e8\u8868<\/h2>\n
            \u5fc5\u987b\u7f16\u5199\u5916\u90e8\u670d\u52a1\u5668\u4e0a\u7684\u8868\u5b9a\u4e49\uff0c\u8fd9\u662f\u65e0\u6cd5\u9057\u6f0f\u7684\u9057\u61be\u3002<\/p>\n
            \u8fd9\u4e2a\u4e1c\u897f\u80fd\u7528\u5f97\u591a\u81ea\u7136\uff1f<\/h1>\n
            \u4f18\u70b9<\/h2>\n
              \n
            • \n
                \u6027\u80fd\u9762\u3067\u7279\u306b\u9055\u548c\u611f\u306f\u306a\u304b\u3063\u305f\u3002<\/ul>\n<\/li>\n<\/ul>\n
                \u4eca\u56de\u306f\u3059\u3079\u3066 Docker \u30db\u30b9\u30c8\u5185\u306e\u901a\u4fe1\u3067\u5b8c\u7d50\u3057\u3066\u3044\u308b\u304c\u3001\u3053\u308c\u304c\u3088\u308a\u30ec\u30a4\u30c6\u30f3\u30b7\u304c\u5927\u304d\u3044\u74b0\u5883\u4e0b\u3067\u3069\u308c\u304f\u3089\u3044\u6027\u80fd\u304c\u4f4e\u4e0b\u3059\u308b\u306e\u304b\u306f\u691c\u8a3c\u3067\u304d\u3066\u3044\u306a\u3044\u3002<\/p>\n
                \u666e\u901a\u306b JOIN \u306f\u3067\u304d\u308b\u3002
                \n\u30d3\u30e5\u30fc\u3001\u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30d3\u30e5\u30fc\u3001\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u306a\u3069\u3001\u901a\u5e38\u306e PostgreSQL \u306e\u6587\u8108\u306b\u8f09\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u308b<\/p>\n
                \u30de\u30c6\u30ea\u30a2\u30e9\u30a4\u30ba\u30c9\u30fb\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3057\u307e\u3048\u3070\u3001\u6027\u80fd\u306f PostgreSQL \u306e\u901a\u5e38\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u6271\u3048\u308b(\u306f\u305a\u3001\u305f\u3076\u3093)\u3002<\/p>\n
                \u5f0a\u7aef<\/h2>\n
                  \u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u3092\u66f8\u304f\u5fc5\u8981\u304c\u3042\u308b (\u5fc5\u9808)\u3002 Presto \u306e\u3088\u3046\u306b catalog \u306b\u8ffd\u52a0\u3059\u308c\u3070\u3042\u3068\u306f\u3088\u3057\u306a\u306b\u3001\u3068\u3044\u3046\u308f\u3051\u3067\u306f\u306a\u3044\u3002<\/ul>\n
                  \u5176\u4ed6<\/h1>\n
                  \u5f88\u9057\u61be\uff0cDocker\u7248\u7684SQL Server\u65e0\u6cd5\u8f7b\u677e\u5730\u5728Mac\u4e0a\u8fdb\u884c\u5c1d\u8bd5\uff0c\u6240\u4ee5\u4e0a\u8ff0\u5b58\u50a8\u5e93\u4e2d\u4e0d\u5305\u542b\u5b83\u3002
                  \n\u7136\u800c\uff0c\u5df2\u7ecf\u9a8c\u8bc1\u4e86tds_fdw\u7684\u8fd0\u4f5c\u6ca1\u6709\u95ee\u9898\u3002<\/p>\n
                  \u8bf7\u53c2\u8003\u6211\u4ee5\u4e0b\u63d0\u4f9b\u7684\u539f\u6587\u7684\u4e2d\u6587\u7ffb\u8bd1\u3002<\/h1>\n
                  F.31. postgres_fdw \u2190 \u516c\u5f0f\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u3002\u5f53\u7136\u3053\u306e\u8a18\u4e8b\u3088\u308a\u3082\u7d30\u304b\u304f\u8a18\u8f09\u3057\u3066\u3042\u308b\u3002<\/p>\n
                  PostgreSQL FDW \u3092\u4f5c\u3063\u3066SQL\u3067\u30ed\u30b0\u691c\u7d22\u3057\u3066\u307f\u305f \u2190 FDW \u3092\u77e5\u3063\u305f\u304d\u3063\u304b\u3051\u3068\u306a\u3063\u305f\u30d6\u30ed\u30b0\u8a18\u4e8b\u3002<\/p>\n
                  https:\/\/quay.io\/repository\/aptible\/postgresql \u2190 \u30d9\u30fc\u30b9\u306b\u3057\u305f PostgreSQL \u306e Docker \u30a4\u30e1\u30fc\u30b8\u3002 SQL Server \u3084 PL\/v8, PL\/Python \u306a\u3069\u306e Extension \u3082\u542b\u3093\u3067\u3044\u308b\u3002<\/p>\n
                  https:\/\/hub.docker.com\/r\/rungeict\/postgres-redis\/~\/dockerfile\/ \u2190 redis_fdw \u306e\u8ffd\u52a0\u306b\u3042\u305f\u3063\u3066\u53c2\u8003\u306b\u3055\u305b\u3066\u3044\u305f\u3060\u3044\u305f\u3002<\/p>\n
                  PostgreSQL \u697d\u3061\u3093 FDW Foreign Table \u4f5c\u6210 \u2190 \u307e\u3060\u8a66\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u3053\u306e\u3088\u3046\u306a\u3084\u308a\u65b9\u3092\u5229\u7528\u3059\u308c\u3070\u6bd4\u8f03\u7684\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u306f\u697d\u306b\u3067\u304d\u308b\u304b\u3082\u3057\u308c\u306a\u3044\u3002<\/p>\n
                  https:\/\/wiki.postgresql.org\/wiki\/Foreign_data_wrappers \u2190 \u307b\u304b\u306b\u3082\u3044\u308d\u3044\u308d\u306a FDW \u304c\u3042\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
                  \u7ecf\u8fc7\/\u7ecf\u5386 \u6700\u8fd1\uff0c\u6211\u6b63\u5728\u5bf9\u6570\u636e\u4ed3\u5e93\u7684\u5efa\u8bbe\u548c\u9009\u62e9\u8fdb\u884c\u5404\u79cd\u8c03\u7814\u3002 \u5728\u7ecf\u8fc7\u65f6\u95f4\u7684\u53d1\u5c55\uff0c\u4e00\u4e2a\u6210\u957f\u8d77\u6765\u7684\u7ec4\u7ec7\u901a\u5e38\u4f1a\u5b58\u5728\u5404 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42207","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\uff0c\u5728postgresql\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528fdw\u4e0emysql\u548credis\u8fdb\u884cjoin\u64cd\u4f5c\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c\" \/>\n<meta property=\"og:description\" content=\"\u7ecf\u8fc7\/\u7ecf\u5386 \u6700\u8fd1\uff0c\u6211\u6b63\u5728\u5bf9\u6570\u636e\u4ed3\u5e93\u7684\u5efa\u8bbe\u548c\u9009\u62e9\u8fdb\u884c\u5404\u79cd\u8c03\u7814\u3002 \u5728\u7ecf\u8fc7\u65f6\u95f4\u7684\u53d1\u5c55\uff0c\u4e00\u4e2a\u6210\u957f\u8d77\u6765\u7684\u7ec4\u7ec7\u901a\u5e38\u4f1a\u5b58\u5728\u5404 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\uff0c\u5728postgresql\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528fdw\u4e0emysql\u548credis\u8fdb\u884cjoin\u64cd\u4f5c\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-23T23:51:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T11:33:14+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/\",\"name\":\"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-23T23:51:30+00:00\",\"dateModified\":\"2024-04-30T11:33:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\uff0c\u5728postgresql\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528fdw\u4e0emysql\u548credis\u8fdb\u884cjoin\u64cd\u4f5c\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c","og_description":"\u7ecf\u8fc7\/\u7ecf\u5386 \u6700\u8fd1\uff0c\u6211\u6b63\u5728\u5bf9\u6570\u636e\u4ed3\u5e93\u7684\u5efa\u8bbe\u548c\u9009\u62e9\u8fdb\u884c\u5404\u79cd\u8c03\u7814\u3002 \u5728\u7ecf\u8fc7\u65f6\u95f4\u7684\u53d1\u5c55\uff0c\u4e00\u4e2a\u6210\u957f\u8d77\u6765\u7684\u7ec4\u7ec7\u901a\u5e38\u4f1a\u5b58\u5728\u5404 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528docker\uff0c\u5728postgresql\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528fdw\u4e0emysql\u548credis\u8fdb\u884cjoin\u64cd\u4f5c\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-23T23:51:30+00:00","article_modified_time":"2024-04-30T11:33:14+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/","name":"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-23T23:51:30+00:00","dateModified":"2024-04-30T11:33:14+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Docker\uff0c\u5728PostgreSQL\u4e2d\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528FDW\u4e0eMySQL\u548cRedis\u8fdb\u884cJOIN\u64cd\u4f5c"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8docker%ef%bc%8c%e5%9c%a8postgresql%e4%b8%ad%e5%b0%9d%e8%af%95%e9%80%9a%e8%bf%87%e4%bd%bf%e7%94%a8fdw%e4%b8%8emysql%e5%92%8credis%e8%bf%9b%e8%a1%8cjoin%e6%93%8d%e4%bd%9c%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42207"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42207\/revisions"}],"predecessor-version":[{"id":93863,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42207\/revisions\/93863"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}