{"id":12555,"date":"2024-08-02T09:48:00","date_gmt":"2024-08-02T01:48:00","guid":{"rendered":"https:\/\/www.orczhou.com\/?p=12555"},"modified":"2024-08-02T10:01:54","modified_gmt":"2024-08-02T02:01:54","slug":"what-is-new-cloud-database-2024-08-02","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2024\/08\/what-is-new-cloud-database-2024-08-02\/","title":{"rendered":"\u4e91\u6570\u636e\u5e93\u884c\u4e1a\u52a8\u6001@2024-08-02"},"content":{"rendered":"\n<p>\u6807\u9898\uff1aClickHouse\u6536\u8d2d\u6570\u636e\u540c\u6b65\u516c\u53f8PeerDB;MariaDB 11.6\u53d1\u5e03Vector;ACMUG\u6d3b\u52a8Monty\u73b0\u573a\u5206\u4eab<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u91cd\u70b9\u66f4\u65b0<\/h4>\n\n\n\n<p>ClickHouse \u6536\u8d2dPostgreSQL\u6570\u636e\u540c\u6b65\u516c\u5f0fPeerDB<sup>[1]<\/sup>\uff0c\u5177\u4f53\u6536\u8d2d\u91d1\u989d\u5e76\u6ca1\u6709\u900f\u9732\uff0c\u4f46\u5177\u62a5\u9053\uff0cPeerDB\u57282023\u5e74\u66fe\u5b8c\u6210\u4e86360\u4e07\u7f8e\u5143\u7684\u79cd\u5b50\u8f6e\u878d\u8d44<sup>[2]<\/sup>\u3002<\/p>\n\n\n\n<p>MariaDB 11.6 \u7248\u672c\u53d1\u5e03\u5411\u91cf\u652f\u6301\uff0c\u652f\u6301\u57fa\u7840\u7684\u5411\u91cf\u7d22\u5f15\u3001\u5411\u91cf\u8ba1\u7b97\u3001\u6587\u672c\u8f6c\u6362\u7b49\u529f\u80fd\u3002<sup>[3]<\/sup><\/p>\n\n\n\n<p>ACMUG\u5317\u4eac\u7ad9\uff08\u4e2d\u56fdMySQL\u7528\u6237\u7ec4\uff09\u6280\u672f\u5206\u4eab\u6d3b\u52a8\u5c06\u4e8e\u672c\u5468\u516d\u5728\u5317\u4eac\u4e3e\u884c\uff0cMySQL\u548cMariaDB\u521b\u59cb\u4ebaMonty\u5c06\u4e8e\u73b0\u573a\u5206\u4eab\uff0c\u611f\u5174\u8da3\u7684\u53ef\u4ee5\u73b0\u573a\u6216\u76f4\u64ad\u53c2\u52a0\uff0c\u6b64\u5916\u672c\u6b21\u5206\u4eab\u8fd8\u5305\u62ec\u4e86\u534e\u4e3a\u4e91\u3001\u963f\u91cc\u4e91\u3001PingCAP\u3001\u6cfd\u62d3\u3001\u4e07\u91cc\u6570\u636e\u5e93\u7b49\u4e3b\u9898\u5206\u4eab\u3002<sup>[4]<\/sup><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u66f4\u65b0\u8be6\u60c5<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">\u706b\u5c71\u4e91(\u5b57\u8282)<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u65b0\u589e\u652f\u6301 PostgreSQL 14\uff0c\u8fdb\u4e00\u6b65\u4e30\u5bcc\u4e91\u6570\u636e\u5e93 PostgreSQL \u7248\u7684\u80fd\u529b\u77e9\u9635\u3002<sup>[21]<\/sup><\/li>\n\n\n\n<li>\u6258\u7ba1PostgreSQL\u65b0\u589e\u63d0\u4f9b\u590d\u5236\u69fd\u7ba1\u7406\u80fd\u529b\uff0c\u652f\u6301\u67e5\u770b\u548c\u7ba1\u7406\u5b9e\u4f8b\u4e2d\u7684\u590d\u5236\u69fd <sup>[22]<\/sup><\/li>\n\n\n\n<li>\u5728 PostgreSQL 12 \u53ca\u4ee5\u4e0a\u7248\u672c\u5b9e\u4f8b\u4e2d\u63d0\u4f9b 0.6.2 \u7248\u672c pg_vector \u63d2\u4ef6 <sup>[23]<\/sup><\/li>\n\n\n\n<li>\u6258\u7ba1PostgreSQL\u63d0\u4f9b 1.6.2 \u7248\u672c pg_cron \u63d2\u4ef6\uff0c\u63d0\u9ad8\u63d2\u4ef6\u7684\u53ef\u9760\u6027\u4e0e\u7a33\u5b9a\u6027 <sup>[24]<\/sup><\/li>\n\n\n\n<li>\u6258\u7ba1PostgreSQL\u65b0\u589e 29 \u9879\u76d1\u63a7\u6307\u6807\uff0c\u5e76\u4e3a\u5176\u4e2d 25 \u63d0\u4f9b\u4e86\u770b\u677f\u5c55\u793a\uff0c\u5e2e\u52a9\u638c\u63e1\u5b9e\u4f8b\u72b6\u6001\u548c\u4e1a\u52a1\u72b6\u6001\u7684\u7ec6\u8282\u4fe1\u606f\u3002<sup>[25]<\/sup><\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">\u817e\u8baf\u4e91<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4e91\u6570\u636e\u5e93 MySQL \u652f\u6301\u53cc\u8282\u70b9\u3001\u4e09\u8282\u70b9\u5b9e\u4f8b\u4e00\u952e\u5347\u7ea7\u4e3a\u96c6\u7fa4\u7248\u5b9e\u4f8b\u3002<sup>[29]<\/sup><\/li>\n\n\n\n<li>\u4e91\u6570\u636e\u5e93 MySQL 8.0\u5185\u6838\u7248\u672c\u66f4\u65b020230701\uff0c\u652f\u6301\u7528\u793e\u533a\u7248\u672c\u62c9\u8d77 TXSQL \u7269\u7406\u5907\u4efd\u7b49\u529f\u80fd <sup>[30]<\/sup><\/li>\n\n\n\n<li>TDSQL-C MySQL \u7248\u652f\u6301\u6dfb\u52a0\u53ea\u8bfb\u5206\u6790\u5f15\u64ce\u5b9e\u4f8b\uff0c\u8fdb\u5165\u5185\u6d4b\u9636\u6bb5\uff0c\u9488\u5bf9\u4e1a\u52a1\u4e2d\u590d\u6742\u67e5\u8be2 SQL\uff0c\u5927\u6570\u636e\u7684\u8ba1\u7b97\uff0c\u591a\u8868 JOIN \u7b49\u573a\u666f\u6709\u7740\u6570\u91cf\u7ea7\u6027\u80fd\u63d0\u5347\u3002\u53ef\u5e7f\u6cdb\u9002\u7528\u4e8e\u4e1a\u52a1\u4e2d\u7684\u6162\u67e5\u8be2\u3001\u6279\u91cf\u6570\u636e\u5904\u7406\u3001\u5bf9\u8d26\u67e5\u8be2\u7b49\u5178\u578b\u573a\u666f\u3002<sup>[31]<\/sup><\/li>\n\n\n\n<li>\u4e91\u6570\u636e\u5e93 SQL Server \u53d1\u5e03\u65b0\u7248\u672c\u5b9e\u4f8b\u8be6\u60c5\u9875\u53ca\u5168\u65b0\u67b6\u6784\u56fe\u3002<sup>[32]<\/sup><\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">\u963f\u91cc\u4e91<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6258\u7ba1MongoDB\u4e91\u76d8\u7248\u5b9e\u4f8b\u9ad8\u53ef\u7528\u8fde\u63a5\u5730\u5740\u652f\u6301\u6dfb\u52a0\u6807\u7b7e\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\uff0c\u53ef\u4ee5\u901a\u8fc7\u914d\u7f6e\u4e0a\u8ff0\u53c2\u6570\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\u548c\u8d1f\u8f7d\u5747\u8861\u3002<sup>[5]<\/sup><\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">GCP(\u8c37\u6b4c\u4e91)<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u63a7\u5236\u53f0\u652f\u6301\u4e86\u8fc1\u79fb\u5230AlloyDB\u7684\u5efa\u8bae\u4e0e\u63a8\u8350\u914d\u7f6e(Preview\u9636\u6bb5) <sup>[7]&nbsp;<\/sup><\/li>\n\n\n\n<li>IAM \u7ec4\u8eab\u4efd\u9a8c\u8bc1\u5f00\u59cb\u652f\u6301Cloud SQL for MySQL \/ PostgreSQL <sup>&nbsp;[6] [8]&nbsp;<\/sup><\/li>\n\n\n\n<li>\u60a8\u73b0\u5728\u53ef\u4ee5\u5347\u7ea7\u672a\u542f\u7528 <a href=\"https:\/\/cloud.google.com\/sql\/docs\/sqlserver\/high-availability\">\u9ad8\u53ef\u7528\u6027<\/a> \u7684 Cloud SQL \u5b9e\u4f8b\u7684\u7f51\u7edc\u67b6\u6784 .<sup>[13] [14]&nbsp;<\/sup><\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Oracle\u4e91<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RAC Oracle \u4e91\u6570\u636e\u5e93\u4e0d\u9700\u8981\u5355\u72ec\u7684\u79c1\u6709\u7aef\u70b9 <sup>[20]<\/sup><\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">AWS(\u4e9a\u9a6c\u900a\u4e91)<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Amazon Neptune Analytics \u65b0\u589e\u8f83\u5c0f\u5bb9\u91cf\u5355\u4f4d <sup>[27]<\/sup><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u53c2\u8003\u94fe\u63a5<\/h4>\n\n\n\n<ul style=\"color:#c0c0c0\" class=\"is-style-no-disc has-text-color has-link-color has-x-small-font-size wp-block-list wp-elements-722dd9e27de0ad47cc7173f32a17a0dd\">\n<li>[1] <a href=\"https:\/\/clickhouse.com\/blog\/clickhouse-welcomes-peerdb-adding-the-fastest-postgres-cdc-to-the-fastest-olap-database\">https:\/\/clickhouse.com\/blog\/clickhouse-welcomes-peerdb-adding-the-fastest-postgres-cdc-to-the-fastest-olap-database<\/a><\/li>\n\n\n\n<li>[2] <a href=\"https:\/\/techcrunch.com\/2024\/07\/30\/real-time-database-startup-clickhouse-acquires-peerdb-to-expand-its-postgres-support\/\">https:\/\/techcrunch.com\/2024\/07\/30\/real-time-database-startup-clickhouse-acquires-peerdb-to-expand-its-postgres-support\/<\/a><\/li>\n\n\n\n<li>[3] <a href=\"https:\/\/mariadb.com\/kb\/en\/vector-overview\/\">https:\/\/mariadb.com\/kb\/en\/vector-overview\/<\/a><\/li>\n\n\n\n<li>[5] <a href=\"https:\/\/help.aliyun.comhttps:\/\/help.aliyun.com\/zh\/mongodb\/user-guide\/connect-to-a-replica-set-instance\">https:\/\/help.aliyun.comhttps:\/\/help.aliyun.com\/zh\/mongodb\/user-guide\/connect-to-a-replica-set-instance<\/a><\/li>\n\n\n\n<li>[6] <a href=\"https:\/\/cloud.google.com\/sql\/docs\/mysql\/add-manage-iam-users#add-iam-group-db\">https:\/\/cloud.google.com\/sql\/docs\/mysql\/add-manage-iam-users#add-iam-group-db<\/a><\/li>\n\n\n\n<li>[7] <a href=\"https:\/\/cloud.google.com\/products?e=48754805#product-launch-stages\">https:\/\/cloud.google.com\/products?e=48754805#product-launch-stages<\/a><\/li>\n\n\n\n<li>[8] <a href=\"https:\/\/cloud.google.com\/sql\/docs\/postgres\/add-manage-iam-users#add-iam-group-db\">https:\/\/cloud.google.com\/sql\/docs\/postgres\/add-manage-iam-users#add-iam-group-db<\/a><\/li>\n\n\n\n<li>[13] <a href=\"https:\/\/cloud.google.com\/sql\/docs\/sqlserver\/configure-ha#verify-ha\">https:\/\/cloud.google.com\/sql\/docs\/sqlserver\/configure-ha#verify-ha<\/a><\/li>\n\n\n\n<li>[14] <a href=\"https:\/\/cloud.google.com\/sql\/docs\/sqlserver\/upgrade-cloud-sql-instance-new-network-architecture\">https:\/\/cloud.google.com\/sql\/docs\/sqlserver\/upgrade-cloud-sql-instance-new-network-architecture<\/a><\/li>\n\n\n\n<li>[20] <a href=\"https:\/\/docs.oracle.com\/iaas\/releasenotes\/changes\/794d82c4-cf01-4d08-affa-947370178eb2\/index.htm\">https:\/\/docs.oracle.com\/iaas\/releasenotes\/changes\/794d82c4-cf01-4d08-affa-947370178eb2\/index.htm<\/a><\/li>\n\n\n\n<li>[21] <a href=\"https:\/\/www.volcengine.com\/docs\/6438\/79254\">https:\/\/www.volcengine.com\/docs\/6438\/79254<\/a><\/li>\n\n\n\n<li>[22] <a href=\"https:\/\/www.volcengine.com\/docs\/6438\/1323543\">https:\/\/www.volcengine.com\/docs\/6438\/1323543<\/a><\/li>\n\n\n\n<li>[23] <a href=\"https:\/\/www.volcengine.com\/docs\/6438\/1126562\">https:\/\/www.volcengine.com\/docs\/6438\/1126562<\/a><\/li>\n\n\n\n<li>[24] <a href=\"https:\/\/www.volcengine.com\/docs\/6438\/1177497\">https:\/\/www.volcengine.com\/docs\/6438\/1177497<\/a><\/li>\n\n\n\n<li>[25] <a href=\"https:\/\/www.volcengine.com\/docs\/6438\/112018\">https:\/\/www.volcengine.com\/docs\/6438\/112018<\/a><\/li>\n\n\n\n<li>[27] <a href=\"https:\/\/aws.amazon.com\/about-aws\/whats-new\/2024\/07\/amazon-neptune-analytics-smaller-capacity-units\/\">https:\/\/aws.amazon.com\/about-aws\/whats-new\/2024\/07\/amazon-neptune-analytics-smaller-capacity-units\/<\/a><\/li>\n\n\n\n<li>[29] <a href=\"https:\/\/cloud.tencent.com\/document\/product\/236\/109572\">https:\/\/cloud.tencent.com\/document\/product\/236\/109572<\/a><\/li>\n\n\n\n<li>[30] <a href=\"https:\/\/cloud.tencent.com\/document\/product\/236\/42539\">https:\/\/cloud.tencent.com\/document\/product\/236\/42539<\/a><\/li>\n\n\n\n<li>[31] <a href=\"https:\/\/cloud.tencent.com\/document\/product\/1003\/107662\">https:\/\/cloud.tencent.com\/document\/product\/1003\/107662<\/a><\/li>\n\n\n\n<li>[32] <a href=\"https:\/\/cloud.tencent.com\/document\/product\/238\/43215\">https:\/\/cloud.tencent.com\/document\/product\/238\/43215<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u6807\u9898\uff1aClickHouse\u6536\u8d2d\u6570\u636e\u540c\u6b65\u516c\u53f8PeerDB;MariaDB 11.6\u53d1\u5e03Vector;ACMUG\u6d3b\u52a8Monty\u73b0\u573a\u5206\u4eab \u91cd\u70b9\u66f4\u65b0 ClickHouse \u6536\u8d2dPostgreSQL\u6570\u636e\u540c\u6b65\u516c\u5f0fPeerDB[1]\uff0c\u5177\u4f53\u6536\u8d2d\u91d1\u989d\u5e76\u6ca1\u6709\u900f\u9732\uff0c\u4f46\u5177\u62a5\u9053\uff0cPeerDB\u57282023\u5e74\u66fe\u5b8c\u6210\u4e86360\u4e07\u7f8e\u5143\u7684\u79cd\u5b50\u8f6e\u878d\u8d44[2]\u3002 MariaDB 11.6 \u7248\u672c\u53d1\u5e03\u5411\u91cf\u652f\u6301\uff0c\u652f\u6301\u57fa\u7840\u7684\u5411\u91cf\u7d22\u5f15\u3001\u5411\u91cf\u8ba1\u7b97\u3001\u6587\u672c\u8f6c\u6362\u7b49\u529f\u80fd\u3002[3] ACMUG\u5317\u4eac\u7ad9\uff08\u4e2d\u56fdMySQL\u7528\u6237\u7ec4\uff09\u6280\u672f\u5206\u4eab\u6d3b\u52a8\u5c06\u4e8e\u672c\u5468\u516d\u5728\u5317\u4eac\u4e3e\u884c\uff0cMySQL\u548cMariaDB\u521b\u59cb\u4ebaMonty\u5c06\u4e8e\u73b0\u573a\u5206\u4eab\uff0c\u611f\u5174\u8da3\u7684\u53ef\u4ee5\u73b0\u573a\u6216\u76f4\u64ad\u53c2\u52a0\uff0c\u6b64\u5916\u672c\u6b21\u5206\u4eab\u8fd8\u5305\u62ec\u4e86\u534e\u4e3a\u4e91\u3001\u963f\u91cc\u4e91\u3001PingCAP\u3001\u6cfd\u62d3\u3001\u4e07\u91cc\u6570\u636e\u5e93\u7b49\u4e3b\u9898\u5206\u4eab\u3002[4] \u66f4\u65b0\u8be6\u60c5 \u706b\u5c71\u4e91(\u5b57\u8282) \u817e\u8baf\u4e91 \u963f\u91cc\u4e91 GCP(\u8c37\u6b4c\u4e91) Oracle\u4e91 AWS(\u4e9a\u9a6c\u900a\u4e91) \u53c2\u8003\u94fe\u63a5<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[132],"tags":[],"class_list":["post-12555","post","type-post","status-publish","format-standard","hentry","category-what-is-new-databases"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/12555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=12555"}],"version-history":[{"count":2,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/12555\/revisions"}],"predecessor-version":[{"id":12597,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/12555\/revisions\/12597"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=12555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=12555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=12555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}