{"id":10006510,"date":"2022-09-17T13:01:52","date_gmt":"2022-09-17T05:01:52","guid":{"rendered":"https:\/\/ityet.com\/?p=10006510"},"modified":"2022-09-17T13:01:52","modified_gmt":"2022-09-17T05:01:52","slug":"%e5%85%a8%e6%96%b0-amazon-rds-for-mysql-%e5%92%8c-postgresql-%e5%a4%9a%e5%8f%af%e7%94%a8%e5%8c%ba%e9%83%a8%e7%bd%b2%e9%80%89%e9%a1%b9","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10006510","title":{"rendered":"\u5168\u65b0 Amazon RDS for MySQL \u548c PostgreSQL \u591a\u53ef\u7528\u533a\u90e8\u7f72\u9009\u9879"},"content":{"rendered":"<p>\u4eca\u5929\uff0c\u6211\u4eec\u5ba3\u5e03\u63a8\u51fa\u5168\u65b0\u7684 <a href=\"https:\/\/link.segmentfault.com\/?enc=oakAv59OOJg9W7CeaTbqwQ%3D%3D.0btur2RGvMw1%2Fab6YspX%2BuMwvrjKnZMlnvHJMvwAKVc%3D\" rel=\"nofollow\">Amazon Relational Database Service (RDS)<\/a> \u591a\u53ef\u7528\u533a\u90e8\u7f72\u9009\u9879\uff0c\u5176\u4e8b\u52a1\u63d0\u4ea4\u5ef6\u8fdf\u6700\u591a\u53ef\u63d0\u901f 2 \u500d\uff0c\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u65f6\u95f4\u901a\u5e38\u5c11\u4e8e 35 \u79d2\uff0c\u5e76\u5305\u542b\u53ef\u8bfb\u7684\u5907\u7528\u5b9e\u4f8b\u3002<\/p>\n<p>Amazon RDS \u63d0\u4f9b\u4e24\u79cd\u590d\u5236\u9009\u9879\uff0c\u4ee5\u589e\u5f3a\u53ef\u7528\u6027\u548c\u6027\u80fd\uff1a<\/p>\n<ul>\n<li><a href=\"https:\/\/link.segmentfault.com\/?enc=Gu5DjP3JkJZliHQlLLKmHw%3D%3D.bIX8hZEjIsNOLNzWvmbXVcseKP5Uf7Spaw1hvv0FVIFzl4qF4lL9LCNDEvu0qOGV\" rel=\"nofollow\">\u591a\u53ef\u7528\u533a\u90e8\u7f72<\/a>\u53ef\u63d0\u4f9b\u9ad8\u53ef\u7528\u6027\u548c\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u529f\u80fd\u3002Amazon RDS \u4f1a\u5728\u7b2c\u4e8c\u4e2a\u53ef\u7528\u533a\u4e2d\u521b\u5efa\u6570\u636e\u5e93\u7684\u5b58\u50a8\u7ea7\u522b\u526f\u672c\u3002\u7136\u540e\uff0c\u5b83\u4f1a\u5c06\u6570\u636e\u4ece\u4e3b\u6570\u636e\u5e93\u5b9e\u4f8b\u540c\u6b65\u590d\u5236\u5230\u5907\u7528\u6570\u636e\u5e93\u5b9e\u4f8b\uff0c\u4ee5\u5b9e\u73b0\u9ad8\u53ef\u7528\u6027\u3002\u4e3b\u6570\u636e\u5e93\u5b9e\u4f8b\u4e3a\u5e94\u7528\u7a0b\u5e8f\u8bf7\u6c42\u63d0\u4f9b\u670d\u52a1\uff0c\u800c\u5907\u7528\u6570\u636e\u5e93\u5b9e\u4f8b\u5219\u4f1a\u5728\u51fa\u73b0\u6545\u969c\u65f6\u968f\u65f6\u63a5\u7ba1\u3002Amazon RDS \u8d1f\u8d23\u7ba1\u7406\u6545\u969c\u68c0\u6d4b\u3001\u6545\u969c\u8f6c\u79fb\u548c\u4fee\u590d\u64cd\u4f5c\u7684\u5404\u65b9\u9762\u4e8b\u5b9c\uff0c\u4ee5\u4fbf\u4f7f\u7528\u6570\u636e\u5e93\u7684\u5e94\u7528\u7a0b\u5e8f\u5177\u6709\u9ad8\u53ef\u7528\u6027\u3002<\/li>\n<li><a href=\"https:\/\/link.segmentfault.com\/?enc=ufRgUWD2idY6dMKyZ5f9ng%3D%3D.L0MmAJlZJYvQ9hkGCQM%2FF2itTRl3s77ZcXac4oAWkBgmU1d2s00C6DZ%2BlSF0lkX1UbRFbrxb2xsb%2BBG5cZR0Aw%3D%3D\" rel=\"nofollow\">\u53ea\u8bfb\u526f\u672c<\/a>\u5141\u8bb8\u5e94\u7528\u7a0b\u5e8f\u8de8\u591a\u4e2a\u6570\u636e\u5e93\u5b9e\u4f8b\u6269\u5c55\u5176\u8bfb\u53d6\u64cd\u4f5c\u3002\u6570\u636e\u5e93\u5f15\u64ce\u4f1a\u5c06\u6570\u636e\u5f02\u6b65\u590d\u5236\u5230\u53ea\u8bfb\u526f\u672c\u3002\u5e94\u7528\u7a0b\u5e8f\u5c06\u5199\u5165\u8bf7\u6c42\uff08<code>INSERT<\/code>\u3001<code>UPDATE<\/code> \u548c DELETE\uff09\u53d1\u9001\u5230\u4e3b\u6570\u636e\u5e93\uff0c\u8bfb\u53d6\u8bf7\u6c42 (<code>SELECT<\/code>) \u53ef\u4ee5\u5728\u53ea\u8bfb\u526f\u672c\u4e4b\u95f4\u5b9e\u73b0\u8d1f\u8f7d\u5747\u8861\u3002\u5982\u679c\u4e3b\u8282\u70b9\u51fa\u73b0\u6545\u969c\uff0c<a href=\"https:\/\/link.segmentfault.com\/?enc=day2KoaV3nV1EnnIqD%2FtZQ%3D%3D.VGr93MYLLYrio3qeMBUJ0e74fjhyqsnL3joFVlM36FNwGdJxtZzs5j%2BQE3CvSWBrW0w%2BNCzotcBRtx6s1puDMmfrbo1dq5xRhSzu66TLtwlU0eNobbniQN9VSKhBBrWA\" rel=\"nofollow\">\u60a8\u53ef\u4ee5\u624b\u52a8\u5c06\u53ea\u8bfb\u526f\u672c\u63d0\u5347\u4e3a\u65b0\u7684\u4e3b\u6570\u636e\u5e93<\/a>\u3002<\/li>\n<\/ul>\n<p>\u591a\u53ef\u7528\u533a\u90e8\u7f72\u548c\u53ea\u8bfb\u526f\u672c\u6709\u4e0d\u540c\u7684\u7528\u9014\u3002\u591a\u53ef\u7528\u533a\u90e8\u7f72\u53ef\u4e3a\u60a8\u7684\u5e94\u7528\u7a0b\u5e8f\u63d0\u4f9b\u9ad8\u53ef\u7528\u6027\u3001\u6301\u4e45\u6027\u548c\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u7684\u670d\u52a1\u3002\u53ea\u8bfb\u526f\u672c\u53ef\u4e3a\u60a8\u7684\u5e94\u7528\u7a0b\u5e8f\u63d0\u4f9b\u8bfb\u53d6\u53ef\u6269\u5c55\u6027\u3002<\/p>\n<p>\u4f46\u662f\uff0c\u5982\u679c\u5e94\u7528\u7a0b\u5e8f\u65e2\u9700\u8981\u9ad8\u53ef\u7528\u6027\u3001\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\uff0c\u540c\u65f6\u53c8\u9700\u8981\u8bfb\u53d6\u53ef\u6269\u5c55\u6027\uff0c\u8be5\u600e\u4e48\u529e\uff1f<\/p>\n<h3><strong>\u9686\u91cd\u4ecb\u7ecd\u5177\u6709\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u5b9e\u4f8b\u7684\u65b0 Amazon RDS \u591a\u53ef\u7528\u533a\u90e8\u7f72\u9009\u9879\u3002<\/strong><\/h3>\n<p>\u4ece\u4eca\u5929\u5f00\u59cb\uff0c\u6211\u4eec\u5c06\u6dfb\u52a0\u4e00\u4e2a\u65b0\u9009\u9879\u6765\u90e8\u7f72 <a href=\"https:\/\/link.segmentfault.com\/?enc=iaEiMFK3K2gF0vw%2BWy%2FmpA%3D%3D.IZY39JXf%2FczuM%2Bg2S%2BP%2BMpm93msuImN7K9U%2FVUMdRX0%3D\" rel=\"nofollow\">RDS<\/a> \u6570\u636e\u5e93\u3002\u6b64\u9009\u9879\u7ed3\u5408\u4e86\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u548c\u53ea\u8bfb\u526f\u672c\uff1aAmazon RDS \u591a\u53ef\u7528\u533a\uff0c\u5e76\u5e26\u6709\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u5b9e\u4f8b\u3002\u6b64\u90e8\u7f72\u9009\u9879\u9002\u7528\u4e8e MySQL \u548c PostgreSQL \u6570\u636e\u5e93\u3002\u8fd9\u662f\u4e00\u4e2a\u5177\u6709\u4e00\u4e2a\u4e3b\u5b9e\u4f8b\u548c\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u5b9e\u4f8b\u7684<a href=\"https:\/\/link.segmentfault.com\/?enc=TiomklNGaDW651S6biNZHQ%3D%3D.I0zPv2IpWK7aQY2mROncDNwUjRGdp4dLSBGjrGeMqbDCfS3LmdQYX0TNYdJ9vBH9oNWlbY3IKzHvZiUCwj3OrwRImOjUgrs51i6YsI7GLsawvzpTd3kUYU9Ms6G6c9aF\" rel=\"nofollow\">\u6570\u636e\u5e93\u96c6\u7fa4<\/a>\u3002\u5b83\u63d0\u4f9b\u7684\u4e8b\u52a1\u63d0\u4ea4\u5ef6\u8fdf\u53ef\u63d0\u901f 2 \u500d\uff0c\u540c\u65f6\u63d0\u4f9b\u81ea\u52a8\u6545\u969c\u8f6c\u79fb\u529f\u80fd\uff0c\u901a\u5e38\u7528\u65f6\u4e0d\u8d85\u8fc7 35 \u79d2\u3002<\/p>\n<p><img decoding=\"async\" referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/bVc2uWL\" alt=\"image.png\" title=\"image.png\" loading=\"lazy\"><\/p>\n<p>\u542f\u7528\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u90e8\u7f72\u9009\u9879\u540e\uff0c<a href=\"https:\/\/link.segmentfault.com\/?enc=Ygx8AtZECpm9zo8plOotKA%3D%3D.F0qsap3W4GNpZOp2%2FvOqxk29DPPmpQcQEc4LsVn%2BM%2Fo%3D\" rel=\"nofollow\">RDS<\/a> \u5c06\u5728\u4e09\u4e2a\u4e0d\u540c\u7684\u53ef\u7528\u533a\u4e2d\u914d\u7f6e\u4e00\u4e2a\u4e3b\u6570\u636e\u5e93\u548c\u4e24\u4e2a\u53ea\u8bfb\u526f\u672c\u3002\u7136\u540e\uff0c\u5b83\u4f1a\u76d1\u89c6\u5e76\u5728\u4e3b\u8282\u70b9\u51fa\u73b0\u6545\u969c\u65f6\u542f\u7528\u6545\u969c\u8f6c\u79fb\u3002<\/p>\n<p>\u4e0e\u4f20\u7edf\u7684\u53ea\u8bfb\u526f\u672c\u4e00\u6837\uff0c\u6570\u636e\u5e93\u5f15\u64ce\u4f1a\u5728\u4e3b\u8282\u70b9\u548c\u53ea\u8bfb\u526f\u672c\u4e4b\u95f4\u590d\u5236\u6570\u636e\u3002\u4e0e\u591a\u53ef\u7528\u533a\u5355\u5907\u7528\u90e8\u7f72\u9009\u9879\u7c7b\u4f3c\uff0c<a href=\"https:\/\/link.segmentfault.com\/?enc=iS0C%2FaMMx9GVvZ3ShgeGcw%3D%3D.oNmDPcoPjr2tbPtSQhVGanAUHW7k1xuCNXHtDC%2B7J2U%3D\" rel=\"nofollow\">RDS<\/a> \u4f1a\u81ea\u52a8\u68c0\u6d4b\u548c\u7ba1\u7406\u6545\u969c\u8f6c\u79fb\u4ee5\u5b9e\u73b0\u9ad8\u53ef\u7528\u6027\u3002<\/p>\n<p>\u60a8\u4e0d\u5fc5\u5728\u9ad8\u53ef\u7528\u6027\u6216\u53ef\u6269\u5c55\u6027\u4e4b\u95f4\u8fdb\u884c\u9009\u62e9\uff1b\u5177\u6709\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u526f\u672c\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u53ef\u540c\u65f6\u5b9e\u73b0\u4e24\u79cd\u7279\u8d28\u3002<\/p>\n<h3><strong>\u6709\u4ec0\u4e48\u76ca\u5904\uff1f<\/strong><\/h3>\n<p>\u4e0e\u4f20\u7edf\u7684\u591a\u53ef\u7528\u533a\u90e8\u7f72\u76f8\u6bd4\uff0c\u6b64\u65b0\u90e8\u7f72\u9009\u9879\u4e3a\u60a8\u5e26\u6765\u4e86\u56db\u5927\u4f18\u52bf\uff1a\u7ecf\u8fc7\u6539\u8fdb\u7684\u63d0\u4ea4\u5ef6\u8fdf\u3001\u66f4\u5feb\u7684\u6545\u969c\u8f6c\u79fb\u3001\u53ef\u8bfb\u7684\u5907\u7528\u5b9e\u4f8b\u548c\u5f97\u5230\u4f18\u5316\u7684\u590d\u5236\u3002<\/p>\n<p>\u9996\u5148\uff0c\u4f7f\u7528\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u65f6\uff0c<strong>\u5199\u5165\u64cd\u4f5c\u4f1a\u53d8\u5f97\u66f4\u5feb<\/strong>\u3002\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u5b9e\u4f8b\u5229\u7528 M6gd \u548c R6gd \u5b9e\u4f8b\u7c7b\u578b\u3002\u8fd9\u4e9b\u5b9e\u4f8b\u7531 <a href=\"https:\/\/link.segmentfault.com\/?enc=qFy3jQpcwEFP0Yf4q%2FUjTA%3D%3D.G1NwaRQKxxQbybNf4g6qISh0eitUr8HRllIqVnJZY1R0Ock96LS%2F89Fu9TBncow0\" rel=\"nofollow\">AWS Graviton2 \u5904\u7406\u5668<\/a>\u63d0\u4f9b\u652f\u6301\u3002\u5b83\u4eec\u914d\u5907\u4e86\u7528\u4e8e\u672c\u5730\u5b58\u50a8\u7684\u5feb\u901f <a href=\"https:\/\/link.segmentfault.com\/?enc=bUh65JKamqi17xtYAehOyA%3D%3D.TXeW%2FW1fGYVMQESTL2B50Wr%2FlvRYRV08YhE5jnwGxdePCHJ48FuByFqzsjTzq0Wp\" rel=\"nofollow\">NVMe<\/a> SSD\uff0c\u975e\u5e38\u9002\u5408\u9ad8\u901f\u548c\u4f4e\u5ef6\u8fdf\u5b58\u50a8\u8981\u6c42\u3002\u4e0e\u57fa\u4e8e x86 \u7684\u540c\u7c7b\u5b9e\u4f8b\u76f8\u6bd4\uff0c\u5b83\u4eec\u7684\u6027\u4ef7\u6bd4\u6700\u9ad8\u53ef\u63d0\u5347 40%\uff0c\u6bcf\u4e2a vCPU \u7684\u672c\u5730\u5b58\u50a8\u5bb9\u91cf\u53ef\u589e\u52a0 50%\u3002<\/p>\n<p>\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u5b9e\u4f8b\u4f7f\u7528 Amazon Elastic Block Store (EBS) \u6765\u5b58\u50a8\u6570\u636e\u548c\u4e8b\u52a1\u65e5\u5fd7\u3002\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u5b9e\u4f8b\u4f7f\u7528\u5b9e\u4f8b\u63d0\u4f9b\u7684\u672c\u5730\u5b58\u50a8\u6765\u5b58\u50a8\u4e8b\u52a1\u65e5\u5fd7\u3002\u672c\u5730\u5b58\u50a8\u7ecf\u8fc7\u4f18\u5316\uff0c\u53ef\u4e3a\u5e94\u7528\u7a0b\u5e8f\u63d0\u4f9b\u4f4e\u5ef6\u8fdf\uff0c\u5e76\u63d0\u9ad8\u6bcf\u79d2\u8f93\u5165\/\u8f93\u51fa\u64cd\u4f5c\u6570 (IOPS)\u3002\u5199\u5165\u64cd\u4f5c\u5c06\u9996\u5148\u5199\u5165\u672c\u5730\u5b58\u50a8\u4e8b\u52a1\u65e5\u5fd7\uff0c\u7136\u540e\u5237\u65b0\u5230\u6570\u636e\u5e93\u5b58\u50a8\u5377\u4e0a\u7684\u6c38\u4e45\u5b58\u50a8\u3002<\/p>\n<p>\u5176\u6b21\uff0c<strong>\u6545\u969c\u8f6c\u79fb\u64cd\u4f5c\u901a\u5e38\u4f1a\u6bd4\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u5b9e\u4f8b\u573a\u666f\u4e2d\u66f4\u5feb\u7684\u901f\u5ea6\u6267\u884c<\/strong>\u3002\u7531\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u521b\u5efa\u7684\u53ea\u8bfb\u526f\u672c\u662f\u6210\u719f\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u3002\u8be5\u7cfb\u7edf\u7684\u6545\u969c\u8f6c\u79fb\u7528\u65f6\u6700\u957f\u4e0d\u8d85\u8fc7 35 \u79d2\uff0c\u53e6\u5916\u8fd8\u9700\u52a0\u4e0a\u5e94\u7528\u4efb\u4f55\u5f85\u5904\u7406\u4e8b\u52a1\u65e5\u5fd7\u7684\u65f6\u95f4\u3002\u5982\u679c\u53d1\u751f\u6545\u969c\u8f6c\u79fb\uff0c\u7cfb\u7edf\u5c06\u5b8c\u5168\u81ea\u52a8\u5347\u7ea7\u65b0\u7684\u4e3b\u8282\u70b9\uff0c\u5e76\u5c06\u539f\u6709\u4e3b\u8282\u70b9\u91cd\u65b0\u914d\u7f6e\u4e3a\u65b0\u7684\u8bfb\u53d6\u5668\u5b9e\u4f8b\u3002<\/p>\n<p>\u7b2c\u4e09\uff0c<strong>\u4e24\u4e2a\u5907\u7528\u5b9e\u4f8b\u662f\u70ed\u5907\u7528\u5b9e\u4f8b<\/strong>\u3002\u60a8\u7684\u5e94\u7528\u7a0b\u5e8f\u53ef\u4ee5\u4f7f\u7528\u96c6\u7fa4\u8bfb\u53d6\u5668\u7ec8\u7aef\u8282\u70b9\u5c06\u5176\u8bfb\u53d6\u8bf7\u6c42 (<code>SELECT<\/code>) \u53d1\u9001\u5230\u8fd9\u4e9b\u5907\u7528\u5b9e\u4f8b\u3002\u5b83\u5141\u8bb8\u60a8\u7684\u5e94\u7528\u7a0b\u5e8f\u5728\u6570\u636e\u5e93\u96c6\u7fa4\u7684\u5b9e\u4f8b\u4e4b\u95f4\u5e73\u5747\u5206\u914d\u6570\u636e\u5e93\u8bfb\u53d6\u8d1f\u8f7d\u3002<\/p>\n<p>\u6700\u540e\uff0c<strong>\u5229\u7528\u672c\u5730\u5b58\u50a8\u5904\u7406\u4e8b\u52a1\u65e5\u5fd7\u53ef\u4ee5\u4f18\u5316\u590d\u5236\u64cd\u4f5c<\/strong>\u3002\u73b0\u6709\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u5b9e\u4f8b\u4f1a\u5728\u5b58\u50a8\u7ea7\u522b\u590d\u5236\u6240\u6709\u66f4\u6539\u3002\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u4ec5\u590d\u5236\u4e8b\u52a1\u65e5\u5fd7\uff0c\u5e76\u4f7f\u7528<a href=\"https:\/\/link.segmentfault.com\/?enc=PzO2kQjErKHRTDjoKbc8fQ%3D%3D.rcefAlWk5sIYJMDbLariUna%2BwqoHMxWjEyoYJrtdWybm6aGrERuvo1SPIw87N87lx7VyCVbpkqrbnO8%2FN3B2hA%3D%3D\" rel=\"nofollow\">\u4ef2\u88c1\u673a\u5236<\/a>)\u6765\u786e\u8ba4\u81f3\u5c11\u6709\u4e00\u4e2a\u5907\u7528\u5b9e\u4f8b\u8ba4\u53ef\u4e86\u66f4\u6539\u3002\u5f53\u5176\u4e2d\u4e00\u4e2a\u8f85\u52a9\u5b9e\u4f8b\u786e\u8ba4\u4e8b\u52a1\u65e5\u5fd7\u5df2\u5199\u5165\u5176\u672c\u5730\u78c1\u76d8\u65f6\uff0c\u6570\u636e\u5e93\u4e8b\u52a1\u5c06\u540c\u6b65\u63d0\u4ea4\u3002<\/p>\n<h3><strong>\u8fc1\u79fb\u73b0\u6709\u6570\u636e\u5e93<\/strong><\/h3>\n<p>\u5bf9\u4e8e\u90a3\u4e9b\u62e5\u6709\u73b0\u6709 RDS \u6570\u636e\u5e93\u5e76\u613f\u610f\u5229\u7528\u8fd9\u4e00\u65b0\u7684\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u90e8\u7f72\u9009\u9879\u7684\u7528\u6237\uff0c\u60a8\u53ef\u4ee5\u62cd<a href=\"https:\/\/link.segmentfault.com\/?enc=UvMFMheXOMk2vSa30rxmpQ%3D%3D.3s%2F7TK9nLpCSlyAND68XDCGXrGb2581chJz%2Fstf99gXG6G35RwPJF5TvxyT11RXPOcxNOmU52IU4rzA9XZMkRUcDv8hbt4WrGYGNViEp3Of8eCGVzDD6Yu08rK8hnnrH\" rel=\"nofollow\">\u6444\u6570\u636e\u5e93\u5feb\u7167<\/a>\uff0c\u4ee5\u521b\u5efa\u73b0\u6709\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u5b58\u50a8\u7ea7\u5907\u4efd\u3002\u5feb\u7167\u51c6\u5907\u5c31\u7eea\u540e\uff0c\u60a8\u53ef\u4ee5\u6839\u636e\u6b64\u5feb\u7167\u4f7f\u7528\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u90e8\u7f72\u9009\u9879\u521b\u5efa\u65b0\u7684\u6570\u636e\u5e93\u96c6\u7fa4\u3002\u60a8\u7684\u65b0\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u5c06\u662f\u73b0\u6709\u6570\u636e\u5e93\u7684\u5b8c\u7f8e\u526f\u672c\u3002<\/p>\n<h3><strong>\u6211\u4eec\u6765\u770b\u770b\u5b83\u7684\u5b9e\u9645\u64cd\u4f5c<\/strong><\/h3>\n<p>\u9996\u5148\uff0c\u6211\u5c06\u6d4f\u89c8\u5668\u6307\u5411 <a href=\"https:\/\/link.segmentfault.com\/?enc=dkEg7VAra02iZNDQ5gW0gw%3D%3D.FbzV8%2B0ebu3Z58RuNiqxV%2FOOlol9oGy8K%2Bacs3jl9L0%3D\" rel=\"nofollow\">AWS \u7ba1\u7406\u63a7\u5236\u53f0<\/a>\u5e76\u5bfc\u822a\u5230 <a href=\"https:\/\/link.segmentfault.com\/?enc=O4Is1OAI2CKZKAaYBacDyw%3D%3D.q3ZcZ6RVeugDONFpR2J667UkZgGcpEqErnNVREHrvjE%3D\" rel=\"nofollow\">RDS<\/a>\u3002\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u90e8\u7f72\u9009\u9879\u9002\u7528\u4e8e MySQL 8.0.28 \u6216\u66f4\u9ad8\u7248\u672c\u4ee5\u53ca PostgreSQL \u7248\u672c 13.4 R1 \u548c 13.5 R1\u3002\u6211\u9009\u62e9\u4efb\u4e00\u6570\u636e\u5e93\u5f15\u64ce\uff0c\u5e76\u786e\u4fdd\u7248\u672c\u7b26\u5408\u6700\u4f4e\u8981\u6c42\u3002\u8be5\u8fc7\u7a0b\u7684\u5176\u4f59\u90e8\u5206\u4e0e\u6807\u51c6 Amazon RDS \u6570\u636e\u5e93\u542f\u52a8\u7a0b\u5e8f\u76f8\u540c\u3002<\/p>\n<p>\u5728 Deployment options\uff08\u90e8\u7f72\u9009\u9879\uff09\u4e0b\uff0c\u6211\u9009\u62e9 PostgreSQL\uff0c\u7248\u672c 13.4 R1\uff0c\u5728Availability and Durability\uff08\u53ef\u7528\u6027\u548c\u6301\u4e45\u6027\uff09\u4e0b\uff0c\u9009\u62e9 Multi-AZ DB cluster\uff08\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\uff09\u3002<\/p>\n<p>\u4e0b\u56fe\u5c55\u793a\u4e86\u8fd9\u79cd\u90e8\u7f72\u670d\u52a1\uff1a<\/p>\n<p><img decoding=\"async\" referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/bVc2uWY\" alt=\"image.png\" title=\"image.png\" loading=\"lazy\"><\/p>\n<p>\u5982\u6709\u9700\u8981\uff0c\u6211\u8fd8\u53ef\u4ee5\u9009\u62e9 RDS \u7528\u4e8e\u96c6\u7fa4\u7684\u53ef\u7528\u533a\u96c6\u3002\u4e3a\u6b64\uff0c\u6211\u521b\u5efa\u4e86\u4e00\u4e2a<a href=\"https:\/\/link.segmentfault.com\/?enc=tidsu%2Fjv57ReEWksz%2BqIZw%3D%3D.0Mam55Ff9Knu2%2BSzUXwnDFngCSeeSsCR%2FcbiQpT0Iw1FdG30Gl1DPrHtzzW8Yb9QILtgY8kfQBDhRJT2ScFQ5C5IuScg23wGlYt806DbtFCnyfWWYKEHqy5CIt6nufmJ5p8R5xYWsTccHnoP37NZID5FDqscfTXxp5LntKEbCs0%3D\" rel=\"nofollow\">\u6570\u636e\u5e93\u5b50\u7f51\u7ec4<\/a>\u5e76\u5c06\u96c6\u7fa4\u5206\u914d\u7ed9\u8be5\u5b50\u7f51\u7ec4\u3002<\/p>\n<p>\u542f\u52a8\u540e\uff0c\u6211\u4f1a\u9a8c\u8bc1\u662f\u5426\u5df2\u521b\u5efa\u4e86\u4e09\u4e2a\u6570\u636e\u5e93\u5b9e\u4f8b\u3002\u6211\u8fd8\u6ce8\u610f\u5230 Amazon RDS \u63d0\u4f9b\u4e86\u4e24\u4e2a\u7aef\u70b9\uff1a\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u5b9e\u4f8b\u7684\u4e3b\u7aef\u70b9\u548c\u4e00\u4e2a\u8d1f\u8f7d\u5747\u8861\u7aef\u70b9\u3002<\/p>\n<p><img decoding=\"async\" referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/bVc2uW0\" alt=\"image.png\" title=\"image.png\" loading=\"lazy\"><\/p>\n<p>\u4e3a\u4e86\u6d4b\u8bd5\u65b0\u96c6\u7fa4\uff0c\u6211\u5728\u6570\u636e\u5e93\u6240\u5728\u540c\u4e00\u5b89\u5168\u7ec4\u4e2d\u7684\u540c\u4e00 VPC \u4e2d\u521b\u5efa\u4e86\u4e00\u4e2a Amazon Linux 2 EC2 \u5b9e\u4f8b\uff0c\u5e76\u786e\u4fdd\u6211\u9644\u52a0\u4e86\u4e00\u4e2a\u5305\u542b <a href=\"https:\/\/link.segmentfault.com\/?enc=UU7E6g8j3C1%2BGPm%2FUDDsEg%3D%3D.VQLSbdR0n1Vi9eMpMZi3AlhVU2VXP5BAk%2FMe93PEkbkdkQKP1SpgfrSQkfB5Y6Z7e7dCya4z9%2F2begJDeQt1MmhMSxhlEq%2FgF0PLsRfNOvRJ7%2BXjFeO3aCSSldqbV46cqPgEJA4OaRwu1cUJC9mrYxsTpSw1MYda5%2FIFOvG92jg%3D\" rel=\"nofollow\">AmazonSSMManagedInstanceCore<\/a> \u6258\u7ba1\u7b56\u7565\u7684 IAM \u89d2\u8272\u3002\u8fd9\u8ba9\u6211\u80fd\u591f<a href=\"https:\/\/link.segmentfault.com\/?enc=PrsOePh%2FtSeE18eUSkBA0g%3D%3D.gKctLl0br20OkMZHp0QOoP3OSMRlrWmZui8L0a9wtjGNy32zRGW6yDq8a9k%2FY1EvuTeCdxwX7%2B2j8NuB5MF%2BSZC4QNayTXK7pBg8fwJszSc%3D\" rel=\"nofollow\">\u4f7f\u7528 SSM \u800c\u975e SSH \u8fde\u63a5\u5b9e\u4f8b<\/a>\u3002<\/p>\n<p>\u5b9e\u4f8b\u542f\u52a8\u540e\uff0c\u6211\u5c06\u4f7f\u7528 SSM \u8fde\u63a5\u5230\u5b9e\u4f8b\u3002\u6211\u5b89\u88c5\u4e86 PostgreSQL \u5ba2\u6237\u7aef\u5de5\u5177\u3002<\/p>\n<p>Zsh<\/p>\n<pre><code>sudo amazon-linux-extras enable postgresql13\nsudo yum clean metadata\nsudo yum install postgresql<\/code><\/pre>\n<p>\u6211\u8fde\u63a5\u5230\u4e3b\u6570\u636e\u5e93\u3002\u6211\u521b\u5efa\u4e86\u4e00\u4e2a\u8868\u5e76\u63d2\u5165\u4e00\u6761\u8bb0\u5f55\u3002<\/p>\n<p>Zsh<\/p>\n<pre><code>psql -h awsnewsblog.cluster-c1234567890r.us-east-1.rds.amazonaws.com -U postgres\n\npostgres=&gt; create table awsnewsblogdemo (id int primary key, name varchar);\nCREATE TABLE\n\npostgres=&gt; insert into awsnewsblogdemo (id,name) values (1, 'seb');\nINSERT 0 1\n\npostgres=&gt; exit<\/code><\/pre>\n<p>\u4e3a\u4e86\u9a8c\u8bc1\u590d\u5236\u662f\u5426\u6309\u9884\u671f\u5de5\u4f5c\uff0c\u6211\u4f1a\u8fde\u63a5\u5230\u53ea\u8bfb\u526f\u672c\u3002\u8bf7\u6ce8\u610f\u7aef\u70b9\u540d\u79f0\u4e2d\u7684 -ro-\u3002\u6211\u68c0\u67e5\u4e86\u8868\u7ed3\u6784\u5e76\u8f93\u5165 SELECT \u8bed\u53e5\u4ee5\u786e\u8ba4\u6570\u636e\u5df2\u88ab\u590d\u5236\u3002<\/p>\n<p>Zsh<\/p>\n<pre><code>psql -h awsnewsblog.cluster-ro-c1234567890r.us-east-1.rds.amazonaws.com -U postgres\n\npostgres=&gt; \/dt\n\n              List of relations\n Schema |      Name       | Type  |  Owner\n--------+-----------------+-------+----------\n public | awsnewsblogdemo | table | postgres\n(1 row)\n\npostgres=&gt; select * from awsnewsblogdemo;\n id | name\n----+------\n  1 | seb\n(1 row)\n\npostgres=&gt; exit<\/code><\/pre>\n<p>\u5728\u6545\u969c\u8f6c\u79fb\u7684\u60c5\u51b5\u4e0b\uff0c\u5e94\u7528\u7a0b\u5e8f\u5c06\u65ad\u5f00\u4e0e\u4e3b\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u8fde\u63a5\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u5e94\u7528\u7a0b\u5e8f\u7ea7\u4ee3\u7801\u5c1d\u8bd5\u91cd\u65b0\u5efa\u7acb\u7f51\u7edc\u8fde\u63a5\u975e\u5e38\u91cd\u8981\u3002\u77ed\u65f6\u95f4\u8fc7\u540e\uff0c\u7aef\u70b9\u7684 DNS \u540d\u79f0\u5c06\u6307\u5411\u5907\u7528\u5b9e\u4f8b\uff0c\u60a8\u7684\u5e94\u7528\u7a0b\u5e8f\u5c06\u80fd\u591f\u91cd\u65b0\u8fde\u63a5\u3002<\/p>\n<p>\u8981\u4e86\u89e3\u6709\u5173\u591a\u53ef\u7528\u533a\u6570\u636e\u5e93\u96c6\u7fa4\u7684\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u6211\u4eec\u7684<a href=\"https:\/\/link.segmentfault.com\/?enc=JVnK2DH%2FS86HzMqkg2Lj1A%3D%3D.NJJTHxerLZ%2BS7ljftKizkpDNJ2RkvMrgzHY8EWZsOTUnmYH%2B8%2FwMffxiYQ0SN5PeieJLump4luduRZ60SwVJ%2B8cMT4IaOS2qA4BtrQ%2FeyktPpyFBA4INxobXX5JRx0S0\" rel=\"nofollow\">\u6587\u6863<\/a>\u3002<\/p>\n<h3><strong>\u5b9a\u4ef7\u548c\u53ef\u7528\u6027<\/strong><\/h3>\n<p>\u5177\u6709\u4e24\u4e2a\u53ef\u8bfb\u5907\u7528\u526f\u672c\u7684 Amazon RDS \u591a\u53ef\u7528\u533a\u90e8\u7f72\u901a\u5e38\u5728\u4ee5\u4e0b\u533a\u57df\u63d0\u4f9b\uff1a\u7f8e\u56fd\u4e1c\u90e8\uff08\u5f17\u5409\u5c3c\u4e9a\u5317\u90e8\uff09\u3001\u7f8e\u56fd\u897f\u90e8\uff08\u4fc4\u52d2\u5188\uff09\u548c\u6b27\u6d32\uff08\u7231\u5c14\u5170\uff09\u3002\u6211\u4eec\u5c06\u5728\u6b64\u5217\u8868\u4e2d\u6dfb\u52a0\u66f4\u591a\u533a\u57df\u3002<\/p>\n<p>\u60a8\u53ef\u4ee5\u5728 MySQL 8.0.28 \u6216\u66f4\u9ad8\u7248\u672c\u4ee5\u53ca PostgreSQL \u7248\u672c 13.4 R1 \u6216 13.5 R1 \u4e2d\u4f7f\u7528\u5b83\u3002<\/p>\n<p>\u5b9a\u4ef7\u53d6\u51b3\u4e8e\u5b9e\u4f8b\u7c7b\u578b\u3002\u5728\u7f8e\u56fd\u533a\u57df\uff0cM6gd \u5b9e\u4f8b\u7684\u6309\u9700\u5b9a\u4ef7\u8d77\u4ef7\u4e3a\u6bcf\u5c0f\u65f6 0.522 \u7f8e\u5143\uff0cR6gd \u5b9e\u4f8b\u7684\u6309\u9700\u5b9a\u4ef7\u4e3a\u6bcf\u5c0f\u65f6 0.722 \u7f8e\u5143\u3002\u4e0e\u5f80\u5e38\u4e00\u6837\uff0cAmazon RDS \u5b9a\u4ef7\u9875\u9762\u5305\u542b <a href=\"https:\/\/link.segmentfault.com\/?enc=hMaJt0ZWm0qUbVKZdw8A4g%3D%3D.qaVRNEomwK0RPlEGCEVefAo%2F%2BEUFkN%2FgwVNr4%2B0PG911FjJuWol43K9cTYNwuHN4mHa%2BiZKv8iU6ZkNLUY8yeg%3D%3D\" rel=\"nofollow\">MySQL<\/a> \u548c <a href=\"https:\/\/link.segmentfault.com\/?enc=jCApyyl9%2F7eWlb6HIGMjXA%3D%3D.lBQETQWEoCqiENAVhtKYaj9xLPFmDpf6Ktc7fExCk4pClRnC5SHmucgOLaacu6D6jkG2TLG5sKcPIlu%2FWCYu7w%3D%3D\" rel=\"nofollow\">PostgreSQL<\/a> \u7684\u8be6\u7ec6\u4fe1\u606f\u3002<\/p>\n<p><a href=\"https:\/\/link.segmentfault.com\/?enc=oaLvkwMZA3hZvwMbmSkXwg%3D%3D.ukQ8gxFpaXcdS4ILYwTwsU0WVHPbIGuk4bOgWU%2BhYczA7YHJ18k6ioptszAVI%2BLMq0GxnqyDBPDN%2B9vh58CUVgJIX%2BIJYPADVmaIrgiqYyodJqIT3eBpZI3JnjKb9eNylHgLZSldUyeiljAC7MLTzQ%3D%3D\" rel=\"nofollow\">\u60a8\u53ef\u4ee5\u7acb\u5373\u5f00\u59cb\u4f7f\u7528<\/a>\u3002<\/p>\n<p>\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u8bbf\u95ee\u94fe\u63a5\uff1a<a href=\"https:\/\/link.segmentfault.com\/?enc=qYcRKuCGJYCIVavzGGGu6Q%3D%3D.BPSEnOhfX9auoOqhZrQFwLwlR3ZoULlWX7ZpkDA8apM076w%2FSOqdC6S3PmYz3oGBvUz2YnFfqxj7mlbEbGpRUqTdT7ZkiAWaPrex2F0WQ1BR0MF2yYXNX4Vd%2FK%2FbnGNDjXk4Z8X1azUZBYZz887mO8dKqV00iQzCRRx11BJFKYXLtZ6dYclCw16wyAJgSa0G\" rel=\"nofollow\">https:\/\/aws.amazon.com\/cn\/get&#8230;<\/a><\/p>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000042502295\">https:\/\/segmentfault.com\/a\/1190000042502295<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u5929\uff0c\u6211\u4eec\u5ba3\u5e03\u63a8\u51fa\u5168\u65b0\u7684 Amazon Relational Database Service (RDS) \u591a [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-10006510","post","type-post","status-publish","format-standard","hentry"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10006510"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006510\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10006510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10006510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10006510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}