Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[feature] reshard single table to the partition table #436

Closed
andyli029 opened this issue Jul 15, 2019 · 3 comments
Closed

[feature] reshard single table to the partition table #436

andyli029 opened this issue Jul 15, 2019 · 3 comments
Assignees
@andyli029
Labels
P0 High priority type: feature
Milestone
v1.0.8

Comments

@andyli029
Copy link
Contributor

andyli029 commented Jul 15, 2019 •
edited

Summary

reshard single table to the partition table

  • migrate data from single table to the partition table;

Syntax:

  • RADON RESHARD tbl_name TO new_tbl_name
@andyli029
Copy link
Contributor Author

andyli029 commented Jul 15, 2019 •
edited

Related Links about: single table, partition table table type

@andyli029 andyli029 changed the title [feature] reshard SINGLE table to the partition table [feature] reshard single table to the partition table Jul 15, 2019
andyli029 added a commit to andyli029/radon that referenced this issue Jul 15, 2019
@andyli029
go-mysqlstack, proxy: add reshard sqlparser radondb#436
cdf0e04
BohuTANG pushed a commit that referenced this issue Jul 15, 2019
@andyli029 @BohuTANG
go-mysqlstack, proxy: add reshard sqlparser #436
b6abb8a
@andyli029 andyli029 self-assigned this Jul 16, 2019
@andyli029 andyli029 added P0 High priority type: feature labels Jul 16, 2019
@andyli029 andyli029 added this to the v1.0.8 milestone Jul 30, 2019
This was referenced Jul 30, 2019
Closed
Closed
andyli029 added a commit to andyli029/radon that referenced this issue Aug 9, 2019
@andyli029
go-mysqlstack: reshard add new tablename sqlparser radondb#436
dd05245
andyli029 added a commit to andyli029/radon that referenced this issue Aug 9, 2019
@andyli029
go-mysqlstack: reshard add new tablename sqlparser radondb#436
1790da0
BohuTANG pushed a commit that referenced this issue Aug 9, 2019
@andyli029 @BohuTANG
go-mysqlstack: reshard add new tablename sqlparser #436
a94777a
andyli029 added a commit to andyli029/radon that referenced this issue Aug 16, 2019
@andyli029
go-mysqlstack: reshard add new tablename sqlparser radondb#436
5bc240f
andyli029 added a commit to andyli029/radon that referenced this issue Aug 16, 2019
@andyli029
proxy: add reshard handle radondb#436
0a3d583
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy: add reshard handle radondb#436
b1e457a 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy: add reshard handle radondb#436
a11411f 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy,router: add reshard handle radondb#436
5258618 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy,router: add reshard handle radondb#436
4418cc8 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy,router: add reshard handle radondb#436
54c495c 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 4, 2019
@andyli029
proxy,router: add reshard handle radondb#436
ffc5870 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 6, 2019
@andyli029
proxy,router: add reshard handle radondb#436
3f7df21 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 6, 2019
@andyli029
proxy,router: add reshard handle radondb#436
115d4b4 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 6, 2019
@andyli029
proxy,router: add reshard handle radondb#436
bd7d904 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 6, 2019
@andyli029
proxy,router: add reshard handle radondb#436
189fe5f 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 6, 2019
@andyli029
proxy,router: add reshard handle radondb#436
9752a21 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 10, 2019
@andyli029
proxy,router: add reshard handle radondb#436
2bd7a96 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 10, 2019
@andyli029
proxy,router: add reshard handle radondb#436
884b10a 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 10, 2019
@andyli029
proxy,router: add reshard handle radondb#436
1490985 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 10, 2019
@andyli029
proxy,router: add reshard handle radondb#436
21f9ab1 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
andyli029 added a commit to andyli029/radon that referenced this issue Sep 10, 2019
@andyli029
proxy,router: add reshard handle radondb#436
049d39c 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
BohuTANG pushed a commit that referenced this issue Sep 11, 2019
@andyli029 @BohuTANG
proxy,router: add reshard handle #436
a5de2d1 
[summary]

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go
src/proxy/admin_shift_test.go
src/router/frm_test.go

[patch codecov]
src/proxy/admin_reshard.go: 98.4%
src/proxy/admin_shift.go: 81.8%
src/router/frm.go: 100%
@andyli029
Copy link
Contributor Author

Finished.

@andyli029 andyli029 reopened this Nov 20, 2019
@andyli029
Copy link
Contributor Author

andyli029 commented Nov 20, 2019 •
edited

Syntax:
RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table
to another PARTITION table, the cmd execute the shift cmd and
will return immediately, the shift will run in background on
other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface
RADON RESHARD

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andyli029 andyli029

Labels
P0 High priority type: feature
Projects
None yet
Milestone
v1.0.8
Development

No branches or pull requests
1 participant
@andyli029