Update Aurora MySQL dumpling command #6847

fengou1 · 2021-08-12T03:29:13Z

First-time contributors' checklist

I've signed Contributor License Agreement that's required for repo owners to accept my contribution.

What is changed, added or deleted? (Required)

Which TiDB version(s) do your changes apply to? (Required)

Tips for choosing the affected version(s):

By default, CHOOSE MASTER ONLY so your changes will be applied to the next TiDB major or minor releases. If your PR involves a product feature behavior change or a compatibility change, CHOOSE THE AFFECTED RELEASE BRANCH(ES) AND MASTER.

For details, see tips for choosing the affected versions (in Chinese).

What is the related PR or file link(s)?

This PR is translated from:
Other reference link(s):

Do your changes match any of the following descriptions?

Delete files
Change aliases
Need modification after applied to another branch
Might cause conflicts after applied to another branch

ti-chi-bot · 2021-08-12T03:29:14Z

[REVIEW NOTIFICATION]

This pull request has been approved by:

TomShawn
lichunzhu

To complete the pull request process, please ask the reviewers in the list to review by filling /cc @reviewer in the comment.
After your PR has acquired the required number of LGTMs, you can assign this pull request to the committer in the list by filling /assign @committer in the comment to help you merge this pull request.

The full list of commands accepted by this bot can be found here.

Reviewer can indicate their review by submitting an approval review.
Reviewer can cancel approval by submitting a request changes review.

fengou1 · 2021-08-12T03:30:12Z

/review @lichunzhu

lichunzhu · 2021-08-12T03:39:21Z

migrate-from-aurora-using-lightning.md

@@ -79,12 +79,12 @@ summary: 了解如何使用 TiDB Lightning 从 Amazon Aurora MySQL 迁移全量
 1. 使用 Dumpling 导出表结构文件：

    ```
-    ./dumpling --host 127.0.0.1 --port 4000 --user root --password password --no-data --output ./schema --filter "mydb.*"
+    ./dumpling --host database-1.cedtft9htlae.us-west-2.rds.amazonaws.com --port 3306 --user root --password password --consistency none --no-data --output ./schema --filter "mydb.*"


I think locking these tables for a short while is better.

Suggested change

./dumpling --host database-1.cedtft9htlae.us-west-2.rds.amazonaws.com --port 3306 --user root --password password --consistency none --no-data --output ./schema --filter "mydb.*"

./dumpling --host database-1.cedtft9htlae.us-west-2.rds.amazonaws.com --port 3306 --user root --password password --consistency lock --no-data --output ./schema --filter "mydb.*"

Tried the command with --consistency lock, it works. To keep doc identify with TiDB Cloud https://docs.pingcap.com/tidbcloud/public-preview/migrate-from-aurora-bulk-import, shall we keep none?

lichunzhu

LGTM

fengou1 · 2021-08-12T03:40:58Z

Aurora MySQL does not support SUPR privileges allow to local table (consistent) so that we need --consistency none
Aurora MySQL use port 3306

lichunzhu · 2021-08-12T03:42:46Z

Aurora MySQL does not support SUPR privileges allow to local table (consistent) so that we need --consistency none

Aurora MySQL use port 3306

But we can lock tables in Aurora MySQL.

fengou1 · 2021-08-12T03:49:15Z

Aurora MySQL does not support SUPR privileges allow to local table (consistent) so that we need --consistency none

Aurora MySQL use port 3306

But we can lock tables in Aurora MySQL.

Just check the privileges of Aurora MySQL, and you are right, we are able to lock the table.

fengou1 · 2021-08-12T03:53:16Z

/review @IANTHEREAL

TomShawn · 2021-08-24T11:33:20Z

/merge

ti-chi-bot · 2021-08-24T11:33:22Z

This pull request has been accepted and is ready to merge.

Commit hash: ece090a

TomShawn · 2021-08-25T08:54:19Z

/rebase

TomShawn · 2021-08-30T02:20:03Z

/merge

ti-chi-bot · 2021-08-30T02:20:06Z

This pull request has been accepted and is ready to merge.

Commit hash: 904faa7

ti-chi-bot · 2021-08-30T02:22:58Z

In response to a cherrypick label: new pull request created: #7013.

ti-chi-bot · 2021-08-30T02:23:34Z

In response to a cherrypick label: new pull request created: #7014.

ti-chi-bot · 2021-08-30T02:24:10Z

In response to a cherrypick label: new pull request created: #7015.

fengou1 and others added 17 commits June 23, 2021 15:46

add command to check tikv user

0f3ca57

fix comment from teammate

835ddbe

update details for elaborating the user case.

38b294c

reprase case

faaf02e

fix lint error

58d4b3d

lint error

7f843a0

lint error

499f070

remove read

6cd0fbc

rephrase the info, modified user info

dd8eb34

linter error

44dc6f1

fix lint error

bdec7d5

fix lint error Trailing punctuation in heading

fcf7b06

Merge branch 'pingcap:master' into master

8fb7232

Update br/backup-and-restore-faq.md

997429c

fetch upstream

834ae5f

Merge branch 'master' of https://github.com/pingcap/docs-cn

9d8e1f2

update command with correct parameter

3551abe

ti-chi-bot requested a review from TomShawn August 12, 2021 03:29

ti-chi-bot added missing-translation-status This PR does not have translation status info. size/XS Denotes a PR that changes 0-9 lines, ignoring generated files. labels Aug 12, 2021

update for ci failure

6f8708f

lichunzhu reviewed Aug 12, 2021

View reviewed changes

lichunzhu approved these changes Aug 12, 2021

View reviewed changes

ti-chi-bot added the status/LGT1 Indicates that a PR has LGTM 1. label Aug 12, 2021

ti-chi-bot added the status/LGT2 Indicates that a PR has LGTM 2. label Aug 24, 2021

ti-chi-bot added the status/can-merge Indicates a PR has been approved by a committer. label Aug 24, 2021

TomShawn added the needs-cherry-pick-release-5.2 label Aug 25, 2021

Merge branch 'master' into pr/6847

904faa7

ti-chi-bot removed the status/can-merge Indicates a PR has been approved by a committer. label Aug 30, 2021

ti-chi-bot added the status/can-merge Indicates a PR has been approved by a committer. label Aug 30, 2021

ti-chi-bot merged commit 93903cb into pingcap:master Aug 30, 2021

ti-chi-bot mentioned this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) #7013

Merged

12 tasks

ti-chi-bot mentioned this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) #7014

Merged

12 tasks

ti-chi-bot pushed a commit to ti-chi-bot/docs-cn that referenced this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (pingcap#6847)

30456b0

ti-chi-bot mentioned this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) #7015

Merged

12 tasks

ti-chi-bot added a commit that referenced this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) (#7013)

8781ba2

ti-chi-bot added a commit that referenced this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) (#7015)

db51e91

ti-chi-bot added a commit that referenced this pull request Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) (#7014)

3eb2f51

This was referenced Aug 30, 2021

Update Aurora MySQL dumpling command (#6847) (#7014) #7017

Closed

Update Aurora MySQL dumpling command (#6847) (#7014) #7018

Closed

en-jin19 added translation/done This PR has been translated from English into Chinese and updated to pingcap/docs-cn in a PR. and removed translation/doing This PR’s assignee is translating this PR. labels Aug 30, 2021

en-jin19 mentioned this pull request Aug 30, 2021

Migrate from Aurora: update Aurora MySQL dumpling command pingcap/docs#6335

Merged

12 tasks

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Update Aurora MySQL dumpling command #6847

Update Aurora MySQL dumpling command #6847

fengou1 commented Aug 12, 2021 •

edited

Loading

ti-chi-bot commented Aug 12, 2021 •

edited

Loading

fengou1 commented Aug 12, 2021

lichunzhu Aug 12, 2021

fengou1 Aug 12, 2021

lichunzhu left a comment

fengou1 commented Aug 12, 2021

lichunzhu commented Aug 12, 2021

fengou1 commented Aug 12, 2021

fengou1 commented Aug 12, 2021

TomShawn commented Aug 24, 2021

ti-chi-bot commented Aug 24, 2021

TomShawn commented Aug 25, 2021

TomShawn commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

	./dumpling --host database-1.cedtft9htlae.us-west-2.rds.amazonaws.com --port 3306 --user root --password password --consistency none --no-data --output ./schema --filter "mydb.*"
	./dumpling --host database-1.cedtft9htlae.us-west-2.rds.amazonaws.com --port 3306 --user root --password password --consistency lock --no-data --output ./schema --filter "mydb.*"

Update Aurora MySQL dumpling command #6847

Update Aurora MySQL dumpling command #6847

Conversation

fengou1 commented Aug 12, 2021 • edited Loading

First-time contributors' checklist

What is changed, added or deleted? (Required)

Which TiDB version(s) do your changes apply to? (Required)

What is the related PR or file link(s)?

Do your changes match any of the following descriptions?

ti-chi-bot commented Aug 12, 2021 • edited Loading

fengou1 commented Aug 12, 2021

lichunzhu Aug 12, 2021

Choose a reason for hiding this comment

fengou1 Aug 12, 2021

Choose a reason for hiding this comment

lichunzhu left a comment

Choose a reason for hiding this comment

fengou1 commented Aug 12, 2021

lichunzhu commented Aug 12, 2021

fengou1 commented Aug 12, 2021

fengou1 commented Aug 12, 2021

TomShawn commented Aug 24, 2021

ti-chi-bot commented Aug 24, 2021

TomShawn commented Aug 25, 2021

TomShawn commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

ti-chi-bot commented Aug 30, 2021

fengou1 commented Aug 12, 2021 •

edited

Loading

ti-chi-bot commented Aug 12, 2021 •

edited

Loading