{"id":13859,"date":"2024-11-15T22:11:22","date_gmt":"2024-11-15T14:11:22","guid":{"rendered":"https:\/\/fwq.ai\/blog\/13859\/"},"modified":"2024-11-15T22:11:22","modified_gmt":"2024-11-15T14:11:22","slug":"%e4%bd%bf%e7%94%a8docker%e5%ae%89%e8%a3%85cockroachdb%e7%9a%84%e6%95%99%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/13859\/","title":{"rendered":"\u4f7f\u7528Docker\u5b89\u88c5CockroachDB\u7684\u6559\u7a0b"},"content":{"rendered":"<h1 id=\"%e4%bd%bf%e7%94%a8docker%e5%ae%89%e8%a3%85cockroachdb%e7%9a%84%e6%95%99%e7%a8%8b-GcWzGuqmky\">\u4f7f\u7528Docker\u5b89\u88c5CockroachDB\u7684\u6559\u7a0b<\/h1>\n<p>CockroachDB\u662f\u4e00\u79cd\u5f00\u6e90\u7684\u5206\u5e03\u5f0f\u6570\u636e\u5e93\uff0c\u65e8\u5728\u63d0\u4f9b\u9ad8\u53ef\u7528\u6027\u548c\u5f3a\u4e00\u81f4\u6027\u3002\u5b83\u7684\u8bbe\u8ba1\u7406\u5ff5\u662f\u80fd\u591f\u5728\u591a\u79cd\u73af\u5883\u4e2d\u8fd0\u884c\uff0c\u5305\u62ec\u4e91\u73af\u5883\u548c\u672c\u5730\u670d\u52a1\u5668\u3002\u4f7f\u7528Docker\u6765\u5b89\u88c5CockroachDB\u53ef\u4ee5\u7b80\u5316\u90e8\u7f72\u8fc7\u7a0b\uff0c\u65b9\u4fbf\u5f00\u53d1\u8005\u5feb\u901f\u642d\u5efa\u6d4b\u8bd5\u73af\u5883\u3002\u672c\u6587\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Docker\u5b89\u88c5CockroachDB\u3002<\/p>\n<h2 id=\"%e5%89%8d%e6%8f%90%e6%9d%a1%e4%bb%b6-GcWzGuqmky\">\u524d\u63d0\u6761\u4ef6<\/h2>\n<ul>\n<li>\u786e\u4fdd\u5df2\u5b89\u88c5Docker\u3002\u53ef\u4ee5\u901a\u8fc7\u8fd0\u884c <code>docker --version<\/code> \u6765\u68c0\u67e5Docker\u662f\u5426\u5df2\u5b89\u88c5\u3002<\/li>\n<li>\u4e86\u89e3\u57fa\u672c\u7684Docker\u547d\u4ee4\u548c\u6982\u5ff5\u3002<\/li>\n<\/ul>\n<h2 id=\"%e6%ad%a5%e9%aa%a4%e4%b8%80%ef%bc%9a%e6%8b%89%e5%8f%96cockroachdb%e9%95%9c%e5%83%8f-GcWzGuqmky\">\u6b65\u9aa4\u4e00\uff1a\u62c9\u53d6CockroachDB\u955c\u50cf<\/h2>\n<p>\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u4eceDocker Hub\u62c9\u53d6CockroachDB\u7684\u5b98\u65b9\u955c\u50cf\u3002\u6253\u5f00\u7ec8\u7aef\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n<pre><code>docker pull cockroachdb\/cockroach:v22.1.0<\/code><\/pre>\n<p>\u8fd9\u5c06\u4e0b\u8f7dCockroachDB\u7684\u6700\u65b0\u7248\u672c\u955c\u50cf\u3002<\/p>\n<h2 id=\"%e6%ad%a5%e9%aa%a4%e4%ba%8c%ef%bc%9a%e5%90%af%e5%8a%a8cockroachdb%e9%9b%86%e7%be%a4-GcWzGuqmky\">\u6b65\u9aa4\u4e8c\uff1a\u542f\u52a8CockroachDB\u96c6\u7fa4<\/h2>\n<p>CockroachDB\u652f\u6301\u591a\u8282\u70b9\u96c6\u7fa4\u7684\u8fd0\u884c\u3002\u4e3a\u4e86\u7b80\u5355\u8d77\u89c1\uff0c\u6211\u4eec\u5c06\u542f\u52a8\u4e00\u4e2a\u5355\u8282\u70b9\u7684CockroachDB\u5b9e\u4f8b\u3002\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n<pre><code>docker run -d --name=cockroachdb \n    -p 26257:26257 -p 8080:8080 \n    cockroachdb\/cockroach:v22.1.0 start --insecure<\/code><\/pre>\n<p>\u5728\u8fd9\u4e2a\u547d\u4ee4\u4e2d\uff0c<code>-d<\/code>\u8868\u793a\u4ee5\u540e\u53f0\u6a21\u5f0f\u8fd0\u884c\u5bb9\u5668\uff0c<code>--name<\/code>\u6307\u5b9a\u5bb9\u5668\u7684\u540d\u79f0\uff0c<code>-p<\/code>\u7528\u4e8e\u6620\u5c04\u7aef\u53e3\u3002CockroachDB\u7684\u9ed8\u8ba4\u7aef\u53e3\u662f26257\uff0c\u800c8080\u662f\u7528\u4e8eWeb\u754c\u9762\u7684\u7aef\u53e3\u3002<\/p>\n<h2 id=\"%e6%ad%a5%e9%aa%a4%e4%b8%89%ef%bc%9a%e8%ae%bf%e9%97%aecockroachdb-web%e7%95%8c%e9%9d%a2-GcWzGuqmky\">\u6b65\u9aa4\u4e09\uff1a\u8bbf\u95eeCockroachDB Web\u754c\u9762<\/h2>\n<p>\u542f\u52a8\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7\u6d4f\u89c8\u5668\u8bbf\u95eeCockroachDB\u7684Web\u754c\u9762\uff0c\u5730\u5740\u4e3a <code>http:\/\/localhost:8080<\/code>\u3002\u5728\u8fd9\u91cc\uff0c\u4f60\u53ef\u4ee5\u67e5\u770b\u96c6\u7fa4\u72b6\u6001\u3001\u8282\u70b9\u4fe1\u606f\u4ee5\u53ca\u6267\u884cSQL\u67e5\u8be2\u3002<\/p>\n<h2 id=\"%e6%ad%a5%e9%aa%a4%e5%9b%9b%ef%bc%9a%e8%bf%9e%e6%8e%a5%e5%88%b0cockroachdb-GcWzGuqmky\">\u6b65\u9aa4\u56db\uff1a\u8fde\u63a5\u5230CockroachDB<\/h2>\n<p>\u8981\u8fde\u63a5\u5230CockroachDB\uff0c\u53ef\u4ee5\u4f7f\u7528CockroachDB\u63d0\u4f9b\u7684\u547d\u4ee4\u884c\u5de5\u5177\u3002\u9996\u5148\uff0c\u6253\u5f00\u4e00\u4e2a\u65b0\u7684\u7ec8\u7aef\u7a97\u53e3\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n<pre><code>docker exec -it cockroachdb .\/cockroach sql --insecure --host=cockroachdb:26257<\/code><\/pre>\n<p>\u8fd9\u5c06\u6253\u5f00\u4e00\u4e2aSQL\u547d\u4ee4\u884c\u754c\u9762\uff0c\u4f60\u53ef\u4ee5\u5728\u8fd9\u91cc\u6267\u884cSQL\u8bed\u53e5\u3002<\/p>\n<h2 id=\"%e6%ad%a5%e9%aa%a4%e4%ba%94%ef%bc%9a%e5%88%9b%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%ba%93%e5%92%8c%e8%a1%a8-GcWzGuqmky\">\u6b65\u9aa4\u4e94\uff1a\u521b\u5efa\u6570\u636e\u5e93\u548c\u8868<\/h2>\n<p>\u5728SQL\u547d\u4ee4\u884c\u754c\u9762\u4e2d\uff0c\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6570\u636e\u5e93\u548c\u8868\u3002\u4f8b\u5982\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a\u201ctestdb\u201d\u7684\u6570\u636e\u5e93\uff1a<\/p>\n<pre><code>CREATE DATABASE testdb;<\/code><\/pre>\n<p>\u63a5\u4e0b\u6765\uff0c\u5207\u6362\u5230\u65b0\u521b\u5efa\u7684\u6570\u636e\u5e93\u5e76\u521b\u5efa\u4e00\u4e2a\u8868\uff1a<\/p>\n<pre><code>USE testdb;\nCREATE TABLE users (\n    id INT PRIMARY KEY,\n    name STRING,\n    age INT\n);<\/code><\/pre>\n<h2 id=\"%e6%80%bb%e7%bb%93-GcWzGuqmky\">\u603b\u7ed3<\/h2>\n<p>\u901a\u8fc7\u4ee5\u4e0a\u6b65\u9aa4\uff0c\u6211\u4eec\u6210\u529f\u5730\u4f7f\u7528Docker\u5b89\u88c5\u4e86CockroachDB\uff0c\u5e76\u521b\u5efa\u4e86\u4e00\u4e2a\u7b80\u5355\u7684\u6570\u636e\u5e93\u548c\u8868\u3002CockroachDB\u7684\u5206\u5e03\u5f0f\u7279\u6027\u4f7f\u5176\u5728\u5904\u7406\u5927\u89c4\u6a21\u6570\u636e\u65f6\u8868\u73b0\u51fa\u8272\uff0c\u975e\u5e38\u9002\u5408\u9700\u8981\u9ad8\u53ef\u7528\u6027\u548c\u5f3a\u4e00\u81f4\u6027\u7684\u5e94\u7528\u573a\u666f\u3002\u5982\u679c\u4f60\u9700\u8981\u66f4\u5f3a\u5927\u7684\u670d\u52a1\u5668\u652f\u6301\uff0c\u53ef\u4ee5\u8003\u8651\u4f7f\u7528\u7c73\u4e91\u63d0\u4f9b\u7684<a href=\"https:\/\/fwq.ai\">\u7f8e\u56fd\u4e91\u670d\u52a1\u5668<\/a>\uff0c\u4ee5\u6ee1\u8db3\u4f60\u7684\u4e1a\u52a1\u9700\u6c42\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528Docker\u5b89\u88c5CockroachDB\u7684\u6559\u7a0b CockroachDB\u662f\u4e00\u79cd\u5f00\u6e90\u7684\u5206\u5e03\u5f0f\u6570\u636e\u5e93\uff0c\u65e8\u5728\u63d0\u4f9b\u9ad8\u53ef\u7528\u6027\u548c\u5f3a\u4e00\u81f4\u6027\u3002\u5b83\u7684\u8bbe\u8ba1\u7406\u5ff5\u662f\u80fd\u591f\u5728\u591a\u79cd\u73af\u5883\u4e2d\u8fd0\u884c\uff0c\u5305\u62ec\u4e91\u73af\u5883\u548c\u672c\u5730\u670d\u52a1\u5668\u3002\u4f7f\u7528Docker\u6765\u5b89\u88c5CockroachDB\u53ef\u4ee5\u7b80\u5316\u90e8\u7f72\u8fc7\u7a0b\uff0c\u65b9\u4fbf\u5f00\u53d1\u8005\u5feb\u901f\u642d\u5efa\u6d4b\u8bd5\u73af\u5883\u3002\u672c\u6587\u5c06\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Docker\u5b89\u88c5CockroachDB\u3002 \u524d\u63d0\u6761\u4ef6 \u786e\u4fdd\u5df2\u5b89\u88c5Docker\u3002\u53ef\u4ee5\u901a\u8fc7\u8fd0\u884c docker &#8211;version \u6765\u68c0\u67e5Docker\u662f\u5426\u5df2\u5b89\u88c5\u3002 \u4e86\u89e3\u57fa\u672c\u7684Docker\u547d\u4ee4\u548c\u6982\u5ff5\u3002 \u6b65\u9aa4\u4e00\uff1a\u62c9\u53d6CockroachDB\u955c\u50cf \u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u4eceDocker Hub\u62c9\u53d6CockroachDB\u7684\u5b98\u65b9\u955c\u50cf\u3002\u6253\u5f00\u7ec8\u7aef\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a docker pull cockroachdb\/cockroach:v22.1.0 \u8fd9\u5c06\u4e0b\u8f7dCockroachDB\u7684\u6700\u65b0\u7248\u672c\u955c\u50cf\u3002 \u6b65\u9aa4\u4e8c\uff1a\u542f\u52a8CockroachDB\u96c6\u7fa4 CockroachDB\u652f\u6301\u591a\u8282\u70b9\u96c6\u7fa4\u7684\u8fd0\u884c\u3002\u4e3a\u4e86\u7b80\u5355\u8d77\u89c1\uff0c\u6211\u4eec\u5c06\u542f\u52a8\u4e00\u4e2a\u5355\u8282\u70b9\u7684CockroachDB\u5b9e\u4f8b\u3002\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a docker run -d &#8211;name=cockroachdb -p 26257:26257 -p 8080:8080 cockroachdb\/cockroach:v22.1.0 start &#8211;insecure \u5728\u8fd9\u4e2a\u547d\u4ee4\u4e2d\uff0c-d\u8868\u793a\u4ee5\u540e\u53f0\u6a21\u5f0f\u8fd0\u884c\u5bb9\u5668\uff0c&#8211;name\u6307\u5b9a\u5bb9\u5668\u7684\u540d\u79f0\uff0c-p\u7528\u4e8e\u6620\u5c04\u7aef\u53e3\u3002CockroachDB\u7684\u9ed8\u8ba4\u7aef\u53e3\u662f26257\uff0c\u800c8080\u662f\u7528\u4e8eWeb\u754c\u9762\u7684\u7aef\u53e3\u3002 \u6b65\u9aa4\u4e09\uff1a\u8bbf\u95eeCockroachDB Web\u754c\u9762 \u542f\u52a8\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7\u6d4f\u89c8\u5668\u8bbf\u95eeCockroachDB\u7684Web\u754c\u9762\uff0c\u5730\u5740\u4e3a http:\/\/localhost:8080\u3002\u5728\u8fd9\u91cc\uff0c\u4f60\u53ef\u4ee5\u67e5\u770b\u96c6\u7fa4\u72b6\u6001\u3001\u8282\u70b9\u4fe1\u606f\u4ee5\u53ca\u6267\u884cSQL\u67e5\u8be2\u3002 \u6b65\u9aa4\u56db\uff1a\u8fde\u63a5\u5230CockroachDB \u8981\u8fde\u63a5\u5230CockroachDB\uff0c\u53ef\u4ee5\u4f7f\u7528CockroachDB\u63d0\u4f9b\u7684\u547d\u4ee4\u884c\u5de5\u5177\u3002\u9996\u5148\uff0c\u6253\u5f00\u4e00\u4e2a\u65b0\u7684\u7ec8\u7aef\u7a97\u53e3\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a docker exec -it cockroachdb .\/cockroach sql &#8211;insecure &#8211;host=cockroachdb:26257 \u8fd9\u5c06\u6253\u5f00\u4e00\u4e2aSQL\u547d\u4ee4\u884c\u754c\u9762\uff0c\u4f60\u53ef\u4ee5\u5728\u8fd9\u91cc\u6267\u884cSQL\u8bed\u53e5\u3002 \u6b65\u9aa4\u4e94\uff1a\u521b\u5efa\u6570\u636e\u5e93\u548c\u8868 \u5728SQL\u547d\u4ee4\u884c\u754c\u9762\u4e2d\uff0c\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6570\u636e\u5e93\u548c\u8868\u3002\u4f8b\u5982\uff0c\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a\u201ctestdb\u201d\u7684\u6570\u636e\u5e93\uff1a CREATE DATABASE testdb; \u63a5\u4e0b\u6765\uff0c\u5207\u6362\u5230\u65b0\u521b\u5efa\u7684\u6570\u636e\u5e93\u5e76\u521b\u5efa\u4e00\u4e2a\u8868\uff1a USE testdb; CREATE TABLE users [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-13859","post","type-post","status-publish","format-standard","hentry","category-docker"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/13859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=13859"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/13859\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=13859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=13859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=13859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}