{"id":44396,"date":"2023-02-14T18:55:27","date_gmt":"2023-06-15T08:22:35","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/"},"modified":"2024-04-29T14:38:12","modified_gmt":"2024-04-29T06:38:12","slug":"%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/","title":{"rendered":"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u5728\u5c06\u5b58\u50a8\u5728AWS\u4e0a\u7684MySQL\u6570\u636e\u5e93\u8fc1\u79fb\u81f3OCI\u7684MySQL DB\u7cfb\u7edf\u65f6\uff0c\u6211\u4eec\u9a8c\u8bc1\u4e86\u5728\u4e0d\u79fb\u52a8\u5b58\u5728\u4e8eS3\u4e0a\u7684\u5907\u4efd\u6570\u636e\u7684\u60c5\u51b5\u4e0b\uff0c\u76f4\u63a5\u5c06\u5176\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u7684\u6b65\u9aa4\u3002<\/p>\n<p>\u8fd9\u6b21\u6211\u4eec\u5728Oracle Autonomous Linux 7.9\u7684Compute\u5b9e\u4f8b\u4e0a\u5b89\u88c5\u5e76\u4f7f\u7528\u4e86&#8221;goofys&#8221;\uff0c\u53ef\u4ee5\u5c06S3\u4f5c\u4e3a\u6587\u4ef6\u7cfb\u7edf\u8fdb\u884c\u6302\u8f7d\u3002<\/p>\n<h1>1. \u5b89\u88c5Goofys<\/h1>\n<p>\u7531\u4e8egoofys\u9700\u8981\u4f7f\u7528Go\u548cfuse\uff0c\u56e0\u6b64\u9700\u8981\u4f7f\u7528yum\u547d\u4ee4\u5b89\u88c5golang\u548cfuse\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo yum install -y golang fuse\r\nLoaded plugins: langpacks, ulninfo\r\nResolving Dependencies\r\n--&gt; Running transaction check\r\n---&gt; Package fuse.x86_64 0:2.9.4-1.0.9.el7 will be installed\r\n---&gt; Package golang.x86_64 0:1.9.4-1.el7 will be installed\r\n--&gt; Processing Dependency: golang-bin = 1.9.4-1.el7 for package: golang-1.9.4-1.el7.x86_64\r\n--&gt; Processing Dependency: golang-src = 1.9.4-1.el7 for package: golang-1.9.4-1.el7.x86_64\r\n--&gt; Running transaction check\r\n---&gt; Package golang-bin.x86_64 0:1.9.4-1.el7 will be installed\r\n---&gt; Package golang-src.noarch 0:1.9.4-1.el7 will be installed\r\n--&gt; Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n===================================================================================================================\r\n Package                 Arch                Version                        Repository                        Size\r\n===================================================================================================================\r\nInstalling:\r\n fuse                    x86_64              2.9.4-1.0.9.el7                ol7_latest                        88 k\r\n golang                  x86_64              1.9.4-1.el7                    ol7_optional_latest              610 k\r\nInstalling for dependencies:\r\n golang-bin              x86_64              1.9.4-1.el7                    ol7_optional_latest               48 M\r\n golang-src              noarch              1.9.4-1.el7                    ol7_optional_latest              5.1 M\r\n\r\nTransaction Summary\r\n===================================================================================================================\r\nInstall  2 Packages (+2 Dependent packages)\r\n\r\nTotal download size: 54 M\r\nInstalled size: 222 M\r\nDownloading packages:\r\n(1\/4): fuse-2.9.4-1.0.9.el7.x86_64.rpm                                                      |  88 kB  00:00:01     \r\n(2\/4): golang-1.9.4-1.el7.x86_64.rpm                                                        | 610 kB  00:00:01     \r\n(3\/4): golang-src-1.9.4-1.el7.noarch.rpm                                                    | 5.1 MB  00:00:00     \r\n(4\/4): golang-bin-1.9.4-1.el7.x86_64.rpm                                                    |  48 MB  00:00:02     \r\n-------------------------------------------------------------------------------------------------------------------\r\nTotal                                                                               20 MB\/s |  54 MB  00:00:02     \r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n  Installing : golang-src-1.9.4-1.el7.noarch                                                                   1\/4 \r\n  Installing : golang-1.9.4-1.el7.x86_64                                                                       2\/4 \r\n  Installing : golang-bin-1.9.4-1.el7.x86_64                                                                   3\/4 \r\n  Installing : fuse-2.9.4-1.0.9.el7.x86_64                                                                     4\/4 \r\n  Verifying  : golang-bin-1.9.4-1.el7.x86_64                                                                   1\/4 \r\n  Verifying  : golang-1.9.4-1.el7.x86_64                                                                       2\/4 \r\n  Verifying  : fuse-2.9.4-1.0.9.el7.x86_64                                                                     3\/4 \r\n  Verifying  : golang-src-1.9.4-1.el7.noarch                                                                   4\/4 \r\n\r\nInstalled:\r\n  fuse.x86_64 0:2.9.4-1.0.9.el7                             golang.x86_64 0:1.9.4-1.el7                            \r\n\r\nDependency Installed:\r\n  golang-bin.x86_64 0:1.9.4-1.el7                          golang-src.noarch 0:1.9.4-1.el7                         \r\n\r\nComplete!\r\n[opc@compute1 ~]$ \r\n<\/code><\/pre>\n<p>\u4f7f\u7528wget\u547d\u4ee4\u4eceGitHub\u4e0b\u8f7dgoofys\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ wget https:\/\/github.com\/kahing\/goofys\/releases\/latest\/download\/goofys\r\n--2022-02-24 01:01:15--  https:\/\/github.com\/kahing\/goofys\/releases\/latest\/download\/goofys\r\nResolving github.com (github.com)... 13.114.40.48\r\nConnecting to github.com (github.com)|13.114.40.48|:443... connected.\r\nHTTP request sent, awaiting response... 302 Found\r\nLocation: https:\/\/github.com\/kahing\/goofys\/releases\/download\/v0.24.0\/goofys [following]\r\n--2022-02-24 01:01:15--  https:\/\/github.com\/kahing\/goofys\/releases\/download\/v0.24.0\/goofys\r\nReusing existing connection to github.com:443.\r\nHTTP request sent, awaiting response... 302 Found\r\nLocation: https:\/\/objects.githubusercontent.com\/github-production-release-asset-2e65be\/42475296\/92e1ec00-768c-11ea-82dd-825b7e124210?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20220224%2Fus-east-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20220224T010115Z&amp;X-Amz-Expires=300&amp;X-Amz-Signature=8b8605da0670a0357a9d53da81ee05fbb010ae9b74465bf64dbfe51cef9b5f53&amp;X-Amz-SignedHeaders=host&amp;actor_id=0&amp;key_id=0&amp;repo_id=42475296&amp;response-content-disposition=attachment%3B%20filename%3Dgoofys&amp;response-content-type=application%2Foctet-stream [following]\r\n--2022-02-24 01:01:15--  https:\/\/objects.githubusercontent.com\/github-production-release-asset-2e65be\/42475296\/92e1ec00-768c-11ea-82dd-825b7e124210?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20220224%2Fus-east-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20220224T010115Z&amp;X-Amz-Expires=300&amp;X-Amz-Signature=8b8605da0670a0357a9d53da81ee05fbb010ae9b74465bf64dbfe51cef9b5f53&amp;X-Amz-SignedHeaders=host&amp;actor_id=0&amp;key_id=0&amp;repo_id=42475296&amp;response-content-disposition=attachment%3B%20filename%3Dgoofys&amp;response-content-type=application%2Foctet-stream\r\nResolving objects.githubusercontent.com (objects.githubusercontent.com)... 185.199.108.133, 185.199.109.133, 185.199.110.133, ...\r\nConnecting to objects.githubusercontent.com (objects.githubusercontent.com)|185.199.108.133|:443... connected.\r\nHTTP request sent, awaiting response... 200 OK\r\nLength: 23296633 (22M) [application\/octet-stream]\r\nSaving to: \u2018goofys\u2019\r\n\r\n100%[=========================================================================&gt;] 23,296,633  7.01MB\/s   in 3.2s   \r\n\r\n2022-02-24 01:01:19 (7.01 MB\/s) - \u2018goofys\u2019 saved [23296633\/23296633]\r\n\r\n[opc@compute1 ~]$ ls -l\r\ntotal 22752\r\n-rw-rw-r--. 1 opc opc 23296633 Dec  8 02:48 goofys\r\n<\/code><\/pre>\n<p>\u5c06\u4e0b\u8f7d\u7684goofys\u79fb\u52a8\u5230\u4e00\u4e2a\u8def\u5f84\u6b63\u786e\u7684\u76ee\u5f55\uff08\u8fd9\u6b21\u662f\/usr\/local\/bin\uff09\uff0c\u7136\u540e\u66f4\u6539\u6240\u6709\u8005\u548c\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo mv goofys \/usr\/local\/bin\r\n[opc@compute1 ~]$ sudo chown root:root \/usr\/local\/bin\/goofys\r\n[opc@compute1 ~]$ sudo chmod 775 \/usr\/local\/bin\/goofys\r\n<\/code><\/pre>\n<h1>\u521b\u5efa\u7528\u4e8eS3\u8bbf\u95ee\u7684\u51ed\u8bc1\u6587\u4ef6\u3002<\/h1>\n<p>\u521b\u5efa\u7528\u4e8eS3\u8bbf\u95ee\u7684\u51ed\u636e\u6587\u4ef6&#8221;\/root\/.aws\/credentials&#8221;\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo vi \/root\/.aws\/credentials\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[aws]\r\naws_access_key_id = S3\u30d0\u30b1\u30c3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u306a\u30e6\u30fc\u30b6\u306e\u30a2\u30af\u30bb\u30b9\u30ad\u30fc\r\naws_secret_access_key = S3\u30d0\u30b1\u30c3\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u306a\u30e6\u30fc\u30b6\u306e\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u30ad\u30fc\r\n<\/code><\/pre>\n<h1>3. S3\u5b58\u50a8\u6876\u7684\u6302\u8f7d<\/h1>\n<p>\u521b\u5efa\u5c06S3\u5b58\u50a8\u6876\u4f5c\u4e3a\u6587\u4ef6\u7cfb\u7edf\u6302\u8f7d\u7684\u6302\u8f7d\u70b9\u3002\u8fd9\u6b21\u9009\u62e9\u4e86&#8221;\/mnt_s3&#8243;\u4f5c\u4e3a\u6302\u8f7d\u70b9\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo mkdir -p \/mnt_s3\r\n<\/code><\/pre>\n<p>\u5728\/etc\/fstab\u4e2d\uff0c\u6dfb\u52a0\u7528\u4e8e\u4f7f\u7528goofys\u6302\u8f7dS3\u5b58\u50a8\u6876\u7684\u6761\u76ee\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo vi \/etc\/fstab\r\n<\/code><\/pre>\n<p>\u5c06\u4ee5\u4e0b\u5185\u5bb9\u6dfb\u52a0\u8fdb\u53bb\u3002<br \/>\n\u8fd9\u6b21\u5c06\u540d\u4e3a&#8221;s3bucketformds&#8221;\u7684S3\u5b58\u50a8\u6876\u6302\u8f7d\u5230&#8221;\/mnt_s3&#8243;\u3002<\/p>\n<pre class=\"post-pre\"><code>goofys#s3bucketformds \/mnt_s3 fuse _netdev,allow_other,--file-mode=0644,--uid=0,--gid=0,--region=ap-northeast-1,--profile=aws 0 0\r\n<\/code><\/pre>\n<p>\u4f7f\u7528\u201cmount -a\u201d\u547d\u4ee4\u5c06\u6587\u4ef6\u7cfb\u7edf\u6302\u8f7d\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo mount -a\r\n<\/code><\/pre>\n<p>\u6211\u5c06\u786e\u8ba4\u80fd\u5426\u5728S3\u7684\u6302\u8f7d\u70b9\u4e0a\u521b\u5efa\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 mnt]$ cd \/mnt_s3\r\n[opc@compute1 mnt_s3]$ sudo touch test.txt\r\n[opc@compute1 mnt_s3]$ ls -l\r\ntotal 0\r\n-rw-r--r--. 1 root root 0 Feb 24 01:18 test.txt\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d58c137434c4406ce17e1\/25-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2022-02-24 12.07.34.png\" \/><\/div>\n<h1>4. \u5b89\u88c5MySQL\u5ba2\u6237\u7aef<\/h1>\n<p>\u4f7f\u7528yum\u547d\u4ee4\u6765\u8bbe\u7f6e\u4ed3\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo yum install -y https:\/\/dev.mysql.com\/get\/mysql80-community-release-el7-5.noarch.rpm\r\n<\/code><\/pre>\n<p>\u4f7f\u7528yum\u547d\u4ee4\u5b89\u88c5MySQL\u5ba2\u6237\u7aef\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ sudo yum install -y mysql-community-client\r\n<\/code><\/pre>\n<h1>5. \u4f7f\u7528MySQL\u5ba2\u6237\u7aef\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\u7cfb\u7edf<\/h1>\n<p>\u4f7f\u7528mysql\u547d\u4ee4\u4ee5admin\u7528\u6237\u8eab\u4efd\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\u7cfb\u7edf\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ mysql -u admin -p -h mysqlds1.subnet1.vcn1.oraclevcn.com\r\nEnter password: \r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 11\r\nServer version: 8.0.28-u1-cloud MySQL Enterprise - Cloud\r\n\r\nCopyright (c) 2000, 2022, Oracle and\/or its affiliates.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u521b\u5efa\u540d\u4e3aemployees\u7684\u6570\u636e\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; CREATE DATABASE employees;\r\nQuery OK, 1 row affected (0.01 sec)\r\n\r\nmysql&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| employees          |\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n+--------------------+\r\n5 rows in set (0.00 sec)\r\n\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u5173\u95edmysql\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; exit\r\nBye\r\n[opc@compute1 ~]$\r\n<\/code><\/pre>\n<h1>\u5907\u4efd\u6587\u4ef6\u51c6\u5907<\/h1>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d58c137434c4406ce17e1\/39-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2022-02-24 14.34.43.png\" \/><\/div>\n<p>\u786e\u8ba4S3\u6302\u8f7d\u70b9\u7684\u5185\u5bb9\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ ls -l \/mnt_s3\/\r\ntotal 164430\r\n-rw-r--r--. 1 root root 168375940 Feb 24 05:32 employees.dmp\r\n-rw-r--r--. 1 root root         0 Feb 24 01:18 test.txt\r\n[opc@compute1 ~]$\r\n<\/code><\/pre>\n<p>\u786e\u8ba4\u4e86\u5b58\u5728 employees.dmp\u3002<\/p>\n<h1>7. \u6062\u590d\u5b58\u653e\u5728 S3 \u5b58\u50a8\u6876\u4e2d\u7684\u5907\u4efd\u6587\u4ef6\u3002<\/h1>\n<p>\u4f7f\u7528mysql\u547d\u4ee4\u5c06\/mnt_s3\u4e2d\u7684employees.dmp\u6587\u4ef6\u6062\u590d\u5230MySQL\u6570\u636e\u5e93\u7cfb\u7edf\u4e2d\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ time mysql -u admin -p -h mysqlds1.subnet1.vcn1.oraclevcn.com -t employees &lt; \/mnt_s3\/employees.dmp\r\nEnter password: \r\n\r\nreal\t1m9.092s\r\nuser\t0m2.026s\r\nsys\t0m0.167s\r\n[opc@compute1 ~]$\r\n<\/code><\/pre>\n<p>\u4f7f\u7528mysql\u547d\u4ee4\u4ee5admin\u7528\u6237\u8eab\u4efd\u8fde\u63a5\u5230MySQL DB\u7cfb\u7edf\uff0c\u5e76\u786e\u8ba4\u5907\u4efd\u6587\u4ef6\u5df2\u6b63\u786e\u6062\u590d\u3002<\/p>\n<pre class=\"post-pre\"><code>[opc@compute1 ~]$ mysql -u admin -p -h mysqlds1.subnet1.vcn1.oraclevcn.com\r\nEnter password: \r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 11\r\nServer version: 8.0.28-u1-cloud MySQL Enterprise - Cloud\r\n\r\nCopyright (c) 2000, 2022, Oracle and\/or its affiliates.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u5c06\u6570\u636e\u5e93\u5207\u6362\u4e3a\u5458\u5de5\u6570\u636e\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; use employees;\r\nDatabase changed\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u6211\u8981\u68c0\u67e5\u6570\u636e\u5e93\u4e2demployees\u8868\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; show tables;\r\n+----------------------+\r\n| Tables_in_employees  |\r\n+----------------------+\r\n| current_dept_emp     |\r\n| departments          |\r\n| dept_emp             |\r\n| dept_emp_latest_date |\r\n| dept_manager         |\r\n| employees            |\r\n| salaries             |\r\n| titles               |\r\n+----------------------+\r\n8 rows in set (0.00 sec)\r\n\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u6211\u4f1a\u68c0\u67e5\u8868\u683c\u5185\u7684\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; SELECT COUNT(*) FROM employees;\r\n+----------+\r\n| COUNT(*) |\r\n+----------+\r\n|   300024 |\r\n+----------+\r\n1 row in set (0.02 sec)\r\n\r\nmysql&gt; SELECT COUNT(*) FROM departments;\r\n+----------+\r\n| COUNT(*) |\r\n+----------+\r\n|        9 |\r\n+----------+\r\n1 row in set (0.01 sec)\r\n\r\nmysql&gt;\r\n<\/code><\/pre>\n<p>\u6211\u8981\u5173\u95edMySQL\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; exit\r\nBye\r\n[opc@compute1 ~]$\r\n<\/code><\/pre>\n<p>\u4f7f\u7528Goofys\u5c06S3\u5b58\u50a8\u6876\u6302\u8f7d\u5230\u6587\u4ef6\u7cfb\u7edf\uff0c\u5e76\u76f4\u63a5\u4eceS3\u5b58\u50a8\u6876\u4e2d\u6062\u590d\u5907\u4efd\u6587\u4ef6\u5230MySQL\u6570\u636e\u5e93\u7cfb\u7edf\u3002<\/p>\n<h1>\u8bf7\u53c2\u8003\u4ee5\u4e0b\u4fe1\u606f<\/h1>\n<p>\u50bb\u50bb\u7684<br \/>\nMySQL\u5ba2\u6237\u7aef\u547d\u4ee4<br \/>\nmysqldump &#8211; \u6570\u636e\u5e93\u5907\u4efd\u7a0b\u5e8f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5728\u5c06\u5b58\u50a8\u5728AWS\u4e0a\u7684MySQL\u6570\u636e\u5e93\u8fc1\u79fb\u81f3OCI\u7684MySQL DB\u7cfb\u7edf\u65f6\uff0c\u6211\u4eec\u9a8c\u8bc1\u4e86\u5728\u4e0d\u79fb\u52a8\u5b58\u5728\u4e8eS3\u4e0a [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-44396","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d - 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\/\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728aws-s3\u4e0a\u7684mysql\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230mysql-db\u7cfb\u7edf\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728\u5c06\u5b58\u50a8\u5728AWS\u4e0a\u7684MySQL\u6570\u636e\u5e93\u8fc1\u79fb\u81f3OCI\u7684MySQL DB\u7cfb\u7edf\u65f6\uff0c\u6211\u4eec\u9a8c\u8bc1\u4e86\u5728\u4e0d\u79fb\u52a8\u5b58\u5728\u4e8eS3\u4e0a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728aws-s3\u4e0a\u7684mysql\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230mysql-db\u7cfb\u7edf\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-15T08:22:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T06:38:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d58c137434c4406ce17e1\/25-0.png\" \/>\n<meta name=\"author\" content=\"\u79d1, \u96c5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u96c5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \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\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/\",\"name\":\"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-06-15T08:22:35+00:00\",\"dateModified\":\"2024-04-29T06:38:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d\"}]},{\"@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\/41e222757cdd2a3365361328bd79970a\",\"name\":\"\u79d1, \u96c5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u96c5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d - 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\/\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728aws-s3\u4e0a\u7684mysql\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230mysql-db\u7cfb\u7edf\/","og_locale":"zh_CN","og_type":"article","og_title":"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d","og_description":"\u9996\u5148 \u5728\u5c06\u5b58\u50a8\u5728AWS\u4e0a\u7684MySQL\u6570\u636e\u5e93\u8fc1\u79fb\u81f3OCI\u7684MySQL DB\u7cfb\u7edf\u65f6\uff0c\u6211\u4eec\u9a8c\u8bc1\u4e86\u5728\u4e0d\u79fb\u52a8\u5b58\u5728\u4e8eS3\u4e0a [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728aws-s3\u4e0a\u7684mysql\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230mysql-db\u7cfb\u7edf\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-06-15T08:22:35+00:00","article_modified_time":"2024-04-29T06:38:12+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d58c137434c4406ce17e1\/25-0.png"}],"author":"\u79d1, \u96c5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u96c5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/","name":"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-06-15T08:22:35+00:00","dateModified":"2024-04-29T06:38:12+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u6211\u5c1d\u8bd5\u5c06\u5b58\u50a8\u5728AWS S3\u4e0a\u7684MySQL\u5907\u4efd\u6587\u4ef6\u76f4\u63a5\u6062\u590d\u5230MySQL DB\u7cfb\u7edf\u4e2d"}]},{"@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\/41e222757cdd2a3365361328bd79970a","name":"\u79d1, \u96c5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","caption":"\u79d1, \u96c5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e5%b0%86%e5%ad%98%e5%82%a8%e5%9c%a8aws-s3%e4%b8%8a%e7%9a%84mysql%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6%e7%9b%b4%e6%8e%a5%e6%81%a2%e5%a4%8d%e5%88%b0mysql-db%e7%b3%bb%e7%bb%9f\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44396","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=44396"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44396\/revisions"}],"predecessor-version":[{"id":85868,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44396\/revisions\/85868"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=44396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=44396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=44396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}