{"id":592,"date":"2020-09-04T00:00:00","date_gmt":"2020-09-04T00:00:00","guid":{"rendered":"https:\/\/en.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/"},"modified":"2024-05-10T06:42:11","modified_gmt":"2024-05-10T13:42:11","slug":"how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/","title":{"rendered":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud"},"content":{"rendered":"<p><strong>Author:<\/strong> <a href=\"https:\/\/github.com\/handlerww\">Yiwen Chen<\/a><\/p>\n<p><strong>Transcreator:<\/strong> <a href=\"https:\/\/github.com\/CaitinChen\">Caitin Chen<\/a>; <strong>Editor:<\/strong> Tom Dewan<\/p>\n<p><a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/overview\">TiDB<\/a> is an open-source, distributed SQL database that supports <a href=\"https:\/\/en.wikipedia.org\/wiki\/HTAP\">Hybrid Transactional\/Analytical Processing<\/a> (HTAP) workloads. TiDB Cloud is a fully-managed TiDB service delivered by <a href=\"https:\/\/www.pingcap.com\/\">PingCAP<\/a> and is the easiest, most economical, and most resilient way to unlock the full power of TiDB in the cloud.<\/p>\n<p>You can smoothly migrate data to TiDB from any MySQL-compatible database. In this article, we&#8217;ll show you how to migrate your data from Amazon Aurora MySQL to <a href=\"https:\/\/www.pingcap.com\/tidb-dedicated\/\">TiDB Cloud<\/a> using the open-source <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dumpling-overview\">Dumpling<\/a> and <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tidb-lightning-overview\">TiDB Lightning<\/a> tools. Dumpling <em>exports<\/em> data from any MySQL-compatible database, and TiDB Lightning <em>imports<\/em> it into TiDB.<\/p>\n<p>To migrate data, do the following:<\/p>\n<ol>\n<li>Make sure your environment meets the <a href=\"#migration-prerequisites\">migration prerequisites<\/a>.<\/li>\n<li><a href=\"#prepare-the-working-environment-for-data-migration\">Prepare your working environment<\/a>.<\/li>\n<li>Create an Amazon&#8217;s Elastic Compute Cloud (EC2) instance in which to run the migration tools.<\/li>\n<li>Use Dumpling to export the data from Amazon Aurora.<\/li>\n<li>Use TiDB to import the data to TiDB Cloud.<\/li>\n<\/ol>\n<p><em><strong>Note: <\/strong>Because TiDB is highly compatible with MySQL databases, you can use any MySQL-native tool to perform the migration. For example, you can use the MySQL command-line client to import the output of <code>mysqldump<\/code> into TiDB; however, this approach performs considerably worse than the one we use in this article.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Migration_prerequisites\"><\/span>Migration prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Amazon Aurora MySQL database requirements<\/h3>\n<p>Confirm whether TiDB supports the collations of the tables you want to migrate. The default character set in TiDB is <code>utf8mb4<\/code>, which matches the default in MySQL 8.0 and above. TiDB differs from MySQL and defaults to using a binary collation. This binary collation uses a case-insensitive collation. Currently, TiDB supports the following character sets:<\/p>\n<ul>\n<li><code>utf8<\/code><\/li>\n<li><code>utf8mb4<\/code><\/li>\n<li><code>ASCII<\/code><\/li>\n<li><code>latin1<\/code><\/li>\n<li><code>binary<\/code><\/li>\n<\/ul>\n<p>TiDB supports the following collations:<\/p>\n<ul>\n<li><code>ascii_bin<\/code><\/li>\n<li><code>binary<\/code><\/li>\n<li><code>latin1_bin<\/code><\/li>\n<li><code>utf8mb4_general_bin<\/code><\/li>\n<li><code>utf8_general_bin<\/code><\/li>\n<\/ul>\n<p>You can learn more about <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/character-set-and-collation\">Character Sets and Collations<\/a> in the TiDB documentation. To verify which character set you&#8217;re using, follow the steps in <a href=\"#check-the-database-collation-settings\">Check the database character set settings<\/a>.<\/p>\n<h3>Stop writing data while exporting data to the Aurora database<\/h3>\n<p>To keep data consistency, you must stop writing data to Aurora. This is because Amazon Aurora does not support <code>GLOBAL READ LOCK<\/code>. The easiest way is to avoid writing data while you are exporting it. For more details, see this <a href=\"https:\/\/aws.amazon.com\/premiumsupport\/knowledge-center\/mysqldump-error-rds-mysql-mariadb\/?nc1=h_ls\">Amazon support article<\/a>.<\/p>\n<h3>TiDB Cloud cluster requirements<\/h3>\n<p>When you use TiDB Cloud, we recommend that you use the T1.standard cluster type or above. Otherwise, the data import may fail.<\/p>\n<h3>EC2 instance to run tools for migration<\/h3>\n<p>You will be running the migration tools in an EC2 instance that is in the same cloud region as Aurora and TiDB Cloud. Make sure the instance meets the following requirements:<\/p>\n<ul>\n<li>Network access\n<ul>\n<li>Launch the instance in the same Virtual Private Cloud (VPC) as your Amazon Aurora service.<\/li>\n<li>Set up VPC peering between TiDB Cloud and the VPC of your EC2 instance. For details, refer to <a href=\"https:\/\/docs.pingcap.com\/tidbcloud\/set-up-vpc-peering-connections\">Set Up VPC Peering Connections<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>Storage\n<ul>\n<li>Based on the size of your database, specify the Elastic Block Store (EBS) capacity. The backup files are temporarily stored on a storage volume. The free disk of the volume should be larger than the size of the database.<\/li>\n<\/ul>\n<\/li>\n<li>Computing resources\n<ul>\n<li>In this article, we use a <a href=\"https:\/\/aws.amazon.com\/ec2\/instance-types\/t2\/\">t2.large<\/a> instance and a Red Hat\u00ae Enterprise Linux\u00ae (RHEL) image. You&#8217;ll do all the operations described in this document on this AWS EC2 machine. If you need to migrate large quantities of data and you are concerned about performance, you may choose a better-performing EC2 instance.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Prepare_the_working_environment_for_data_migration\"><\/span>Prepare the working environment for data migration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Ensure Amazon Aurora is accessible<\/h3>\n<p>From the same VPC as your Amazon Aurora instance, launch the EC2 instance. You will use the endpoint that Amazon Aurora provides. You can get the access information from the <strong>Aurora MySQL Connectivity &amp; security<\/strong> page.<\/p>\n<h3>Launch the EC2 instance<\/h3>\n<p>In this section, we&#8217;ll prepare an EC2 instance to run the migration tools. You need to pay attention to two issues:<\/p>\n<ul>\n<li>The instance should be in the same VPC as your Amazon Aurora service. This helps you smoothly connect to Amazon Aurora.<\/li>\n<li>Ensure that the free disk space is larger than the size of your data.<\/li>\n<\/ul>\n<p>If you are familiar with these operations, you can skip this section, and continue with &#8220;<a href=\"#check-the-connectivity-with-the-amazon-aurora-database\">Check the connectivity with the Amazon Aurora database<\/a>.&#8221;<\/p>\n<p>Based on the <a href=\"https:\/\/docs.aws.amazon.com\/AWSEC2\/latest\/UserGuide\/EC2_GetStarted.html\">Amazon User Guide for Linux Instances<\/a>, the process to launch an instance includes these steps:<\/p>\n<ol>\n<li>Open the <a href=\"https:\/\/console.aws.amazon.com\/ec2\/\">Amazon EC2 console<\/a>. Choose <strong>Launch Instances<\/strong>.<\/li>\n<li>Choose an Amazon Machine Image (AMI). In this procedure, we use the AMI named Red Hat Enterprise Linux 8 (HVM), SSD Volume Type.<img loading=\"lazy\" decoding=\"async\" width=\"1498\" height=\"205\" class=\"wp-image-593\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/choose-amazon-machine-image.png\" alt=\"Choose an Amazon Machine Image\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/choose-amazon-machine-image.png 1498w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-amazon-machine-image-300x41.png 300w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-amazon-machine-image-1024x140.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-amazon-machine-image-768x105.png 768w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-amazon-machine-image-1440x197.png 1440w\" sizes=\"auto, (max-width: 1498px) 100vw, 1498px\" \/><\/li>\n<li>On the <strong>Choose an Instance Type<\/strong> page, choose t2.large.<img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"62\" class=\"wp-image-594\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/choose-t2-large-aurora-alternative.png\" alt=\"Choose t2.large\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative.png 1600w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative-300x12.png 300w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative-1024x40.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative-768x30.png 768w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative-1536x60.png 1536w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-t2-large-aurora-alternative-1440x56.png 1440w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><\/li>\n<li>Configure the instance details. Based on the network details of your Amazon Aurora service, choose the network and subnet.<img loading=\"lazy\" decoding=\"async\" width=\"1349\" height=\"494\" class=\"wp-image-595\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/choose-network-and-subnet.png\" alt=\"Choose network and subnet\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/choose-network-and-subnet.png 1349w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-network-and-subnet-300x110.png 300w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-network-and-subnet-1024x375.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/09\/choose-network-and-subnet-768x281.png 768w\" sizes=\"auto, (max-width: 1349px) 100vw, 1349px\" \/><\/li>\n<li>On the <strong>Add storage<\/strong> page, we need to set the size of the volume. The size of the storage should be larger than the size of your source database. The Amazon Aurora dashboard displays the amount of used space on the volume.<img loading=\"lazy\" decoding=\"async\" width=\"1031\" height=\"1037\" class=\"wp-image-596\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/set-size-of-volume.png\" alt=\"Set the size of the volume\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/set-size-of-volume.png 1031w, https:\/\/static.pingcap.com\/files\/2020\/09\/set-size-of-volume-298x300.png 298w, https:\/\/static.pingcap.com\/files\/2020\/09\/set-size-of-volume-1018x1024.png 1018w, https:\/\/static.pingcap.com\/files\/2020\/09\/set-size-of-volume-150x150.png 150w, https:\/\/static.pingcap.com\/files\/2020\/09\/set-size-of-volume-768x772.png 768w\" sizes=\"auto, (max-width: 1031px) 100vw, 1031px\" \/>Based on this information, specify the total size of your storage. If you do not have enough free space, the data export may fail.<img loading=\"lazy\" decoding=\"async\" width=\"1353\" height=\"214\" class=\"wp-image-597\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/specify-total-storage-size.png\" alt=\"Specify the total size of your storage\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/specify-total-storage-size.png 1353w, https:\/\/static.pingcap.com\/files\/2020\/09\/specify-total-storage-size-300x47.png 300w, https:\/\/static.pingcap.com\/files\/2020\/09\/specify-total-storage-size-1024x162.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/09\/specify-total-storage-size-768x121.png 768w\" sizes=\"auto, (max-width: 1353px) 100vw, 1353px\" \/><\/li>\n<li>Click <strong>Review and Launch<\/strong>.<\/li>\n<li>On the <strong>Review<\/strong> page, click <strong>Launch<\/strong>.<\/li>\n<li>On the <strong>Select an existing key pair or create a new key pair<\/strong> dialog box, choose <strong>Create a new key pair<\/strong> or <strong>Choose an existing key pair<\/strong> and click <strong>Launch Instances<\/strong>. If you choose <strong>Create a new key pair<\/strong>, click <strong>Download Key Pair<\/strong> and make sure that the key is accessible.<\/li>\n<\/ol>\n<p>For more details on how to launch an EC2 instance, see <a href=\"https:\/\/docs.aws.amazon.com\/AWSEC2\/latest\/UserGuide\/EC2_GetStarted.html\">AWS EC2 Get Started Guide<\/a>.<\/p>\n<h3>Check the connectivity with the Amazon Aurora database<\/h3>\n<p>After you launch the instance, connect it to the Amazon Aurora database. To check the connectivity with Aurora, first install the MySQL client:<\/p>\n<p>{{&lt; copyable &#8220;shell-regular&#8221; &gt;}}<\/p>\n<pre><code class=\"language-shell\">sudo yum install -y mysql\n# Replace the endpoint with your Aurora database endpoint\nmysql -h database-1-instance-1.cbrlnigpiufa.us-west-2.rds.amazonaws.com -u admin -p --ssl-mode=DISABLED\n<\/code><\/pre>\n<p>A MySQL terminal is displayed. In the output, the welcome message indicates that you are connected to the Amazon Aurora database.<\/p>\n<pre><code class=\"language-shell\">[ec2-user@ip-172-30-1-86 ~]$ mysql -h database-1-instance-1.cbrlnigpiufa.us-west-2.rds.amazonaws.com -u admin -p --ssl-mode=DISABLED\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or g.\nYour MySQL connection id is 24\nServer version: 5.6.10 MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nmysql&gt;\n<\/code><\/pre>\n<h3>Check the database collation settings<\/h3>\n<p>For your convenience, we need to verify the collation settings of the database. You can execute these commands in the MySQL terminal to your Amazon Aurora instance.<\/p>\n<p>{{&lt; copyable &#8220;sql&#8221; &gt;}}<\/p>\n<pre><code class=\"language-sql\">select * from ((select table_schema, table_name, column_name, collation_name from information_schema.columns where character_set_name is not null) union all (select table_schema, table_name, null, table_collation from information_schema.tables)) x where table_schema not in ('performance_schema', 'mysql', 'information_schema') and collation_name not in ('utf8_bin', 'utf8mb4_bin', 'ascii_bin', 'latin1_bin', 'binary', 'utf8_general_ci', 'utf8mb4_general_ci');\n<\/code><\/pre>\n<p>The result shows an <code>Empty set<\/code>, which means the database is suitable to migrate to TiDB.<\/p>\n<pre><code class=\"language-shell\">Empty set (0.04 sec)\n<\/code><\/pre>\n<p>If TiDB doesn&#8217;t support the collations that you&#8217;re using, convert your collations to supported types. For more information on collation settings, see <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/character-set-and-collation\">Character Sets and Collations<\/a>.<\/p>\n<h3>Set up VPC peering for network access to TiDB Cloud<\/h3>\n<p>For security purposes, you need to add VPC peering to connect your network and TiDB Cloud. If you have not done this, see <a href=\"https:\/\/docs.pingcap.com\/tidbcloud\/set-up-vpc-peering-connections\">Set Up VPC Peering Connections<\/a>.<\/p>\n<p>When you complete the steps above, VPC peering is activated. You can connect to the TiDB cluster with the information below.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"1338\" height=\"704\" class=\"wp-image-598\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2020\/09\/connection-info-about-your-cluster.png\" alt=\"Connection information about your cluster on TiDB Cloud Dashboard\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/09\/connection-info-about-your-cluster.png 1338w, https:\/\/static.pingcap.com\/files\/2020\/09\/connection-info-about-your-cluster-300x158.png 300w, https:\/\/static.pingcap.com\/files\/2020\/09\/connection-info-about-your-cluster-1024x539.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/09\/connection-info-about-your-cluster-768x404.png 768w\" sizes=\"auto, (max-width: 1338px) 100vw, 1338px\" \/>\n<p>{{&lt; copyable &#8220;shell-regular&#8221; &gt;}}<\/p>\n<pre><code class=\"language-shell\">mysql -h tidb.265f3598.23110bc6.us-west-2.prod.aws.tidbcloud.com -P 4000 -p\n<\/code><\/pre>\n<p>After you connect successfully, you can start the migration process.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Migrate_data_from_Amazon_Aurora_to_TiDB_Cloud\"><\/span>Migrate data from Amazon Aurora to TiDB Cloud<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Export data from the source database<\/h3>\n<p>The TiDB Toolkit package includes Dumpling and TiDB Lighting.<\/p>\n<ol>\n<li>Download the TiDB Toolkit using the following commands.{{&lt; copyable &#8220;shell-regular&#8221; &gt;}}\n<pre><code class=\"language-shell\">mkdir tidb-toolkit-latest-linux-amd64 &amp;&amp; \nwget -qO- https:\/\/download.pingcap.org\/tidb-toolkit-latest-linux-amd64.tar.gz|tar -xzv -C tidb-toolkit-latest-linux-amd64 --strip-components 1\n<\/code><\/pre>\n<\/li>\n<li>Use Dumpling to export the data from Amazon Aurora. Based on your environment, replace the content in angle brackets (<code>&lt;&gt;<\/code>), and then execute the following commands.{{&lt; copyable &#8220;shell-regular&#8221; &gt;}}\n<pre><code class=\"language-shell\">export_username=&lt;Aurora username&gt;\nexport_password=&lt;Aurora password&gt;\nexport_endpoint=&lt;the endpoint for Amazon Aurora MySQL&gt;\nbackup_dir=&lt;backup directory&gt;\n\n.\/tidb-toolkit-latest-linux-amd64\/bin\/dumpling \n  -u \"$export_username\" \n  -p \"$export_password\" \n  -P 3306 \n  -h \"$export_endpoint\" \n  --filetype sql \n  --threads 8 \n  -o \"$backup_dir\" \n  -f \"*.*\" -f '!\/^(mysql|INFORMATION_SCHEMA|PERFORMANCE_SCHEMA|METRICS_SCHEMA|INSPECTION_SCHEMA)$\/.*' \n  --consistency=\"none\" \n  -F 256MiB\n<\/code><\/pre>\n<\/li>\n<\/ol>\n<h3>Import data into TiDB Cloud<\/h3>\n<p>To import data into TiDB Cloud, replace the content included in angle brackets based on your TiDB Cloud cluster settings, and execute the following commands. If the size of your data is too large, you could use <code>tmux<\/code> or <code>nohup<\/code> to keep the TiDB Lightning process up.<\/p>\n<p>For security purposes, the TiKV backend isn&#8217;t exposed to the customer. For now, we use TiDB Lightning&#8217;s TiDB-backend mode to import data.<\/p>\n<p>{{&lt; copyable &#8220;shell-regular&#8221; &gt;}}<\/p>\n<pre><code class=\"language-shell\">backup_dir=&lt;backup directory&gt;\ntidb_endpoint=&lt;endpoint of the cluster in TiDB Cloud&gt;\ntidb_username=&lt;TiDB username&gt;\ntidb_password=&lt;TiDB password&gt;\ntidb_port=&lt;TiDB port&gt;\n\n.\/tidb-toolkit-latest-linux-amd64\/bin\/tidb-lightning --backend tidb -check-requirements=false \n-d=$backup_dir \n-server-mode=false \n-tidb-host=\"$tidb_endpoint\" \n-tidb-port=\"$tidb_port\" \n-tidb-user=\"$tidb_username\" \n-tidb-password=\"$tidb_password\"\n<\/code><\/pre>\n<p><em><strong>Note:<\/strong><\/em><\/p>\n<p><em>If you manually interrupt TiDB Lightning, a checkpoint will be created to help to identify where to resume the restore process. If you encounter any problems that cannot be fixed automatically, refer to <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tidb-lightning-checkpoints\">TiDB Lightning Checkpoints<\/a>.<\/em><\/p>\n<p>When the <code>tidb-lightning<\/code> process completes, The TiDB cluster on TiDB Cloud will have the same structure and data as the Aurora source cluster.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this article, we showed how to do a full-data migration from Amazon Aurora to TiDB Cloud using Dumpling and TiDB Lightning. After the migration, the data and structure is the same on both TiDB Cloud and in the Aurora source cluster. Full-data migration is especially useful if you want to verify TiDB Cloud&#8217;s features using a copy of your Amazon Aurora data. We sincerely hope you found this article helpful.<\/p>\n<p>And stay tuned. In a future article, we&#8217;ll be discussing <em>incremental replication<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.<\/p>","protected":false},"author":67,"featured_media":600,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[69,54,153,31,29],"class_list":["post-592","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-amazon-aurora","tag-data-migration","tag-how-to","tag-tidb-cloud","tag-tutorial"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","author_info":{"display_name":"Yiwen Chen","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/yiwen-chen\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB<\/title>\n<meta name=\"description\" content=\"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.\" \/>\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.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB\" \/>\n<meta property=\"og:description\" content=\"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-04T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-10T13:42:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"534\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yiwen Chen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yiwen Chen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\"},\"author\":{\"name\":\"Yiwen Chen\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/5e8e0624ab59c4f01eb367e8c9869ab2\"},\"headline\":\"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud\",\"datePublished\":\"2020-09-04T00:00:00+00:00\",\"dateModified\":\"2024-05-10T13:42:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\"},\"wordCount\":1411,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\",\"keywords\":[\"Amazon Aurora\",\"Data Migration\",\"How-to\",\"TiDB Cloud\",\"Tutorial\"],\"articleSection\":[\"Product\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\",\"name\":\"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\",\"datePublished\":\"2020-09-04T00:00:00+00:00\",\"dateModified\":\"2024-05-10T13:42:11+00:00\",\"description\":\"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\",\"width\":1600,\"height\":534},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/5e8e0624ab59c4f01eb367e8c9869ab2\",\"name\":\"Yiwen Chen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Yiwen Chen\"},\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/yiwen-chen\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB","description":"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.","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.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/","og_locale":"ko_KR","og_type":"article","og_title":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB","og_description":"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2020-09-04T00:00:00+00:00","article_modified_time":"2024-05-10T13:42:11+00:00","og_image":[{"width":1600,"height":534,"url":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","type":"image\/png"}],"author":"Yiwen Chen","twitter_card":"summary_large_image","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Yiwen Chen","Est. reading time":"9\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/"},"author":{"name":"Yiwen Chen","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/5e8e0624ab59c4f01eb367e8c9869ab2"},"headline":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud","datePublished":"2020-09-04T00:00:00+00:00","dateModified":"2024-05-10T13:42:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/"},"wordCount":1411,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","keywords":["Amazon Aurora","Data Migration","How-to","TiDB Cloud","Tutorial"],"articleSection":["Product"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/","url":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/","name":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","datePublished":"2020-09-04T00:00:00+00:00","dateModified":"2024-05-10T13:42:11+00:00","description":"This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png","width":1600,"height":534},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/5e8e0624ab59c4f01eb367e8c9869ab2","name":"Yiwen Chen","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Yiwen Chen"},"url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/yiwen-chen\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/how-to-migrate-data-from-amazon-aurora-mysql-to-tidb-cloud\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"aurora-alternative-tidb-cloud.jpg\" src=\"https:\/\/static.pingcap.com\/files\/2020\/09\/aurora-alternative-tidb-cloud.png\" loading=\"lazy\" width=1600 height=534 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Product<\/div><\/div><h5 class=\"card-resource__title\">How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/592","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=592"}],"version-history":[{"count":6,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/592\/revisions"}],"predecessor-version":[{"id":16707,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/592\/revisions\/16707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/600"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}