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.

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

[Subtask]: change sys tenant restore normal tenant to normal tenant syntax #16180

Closed
YANGGMM opened this issue May 16, 2024 · 4 comments
Closed
Assignees
Labels
kind/subtask priority/p0 Critical feature that should be implemented in this version
Milestone

Comments

@YANGGMM
Copy link
Contributor

YANGGMM commented May 16, 2024

Parent Issue

14784

Detail of Subtask

change sys tenant restore normal tenant to normal tenant syntax

  1. remove to account
  2. default according to the snapshot

Describe implementation you've considered

No response

Additional information

No response

@YANGGMM YANGGMM added priority/p0 Critical feature that should be implemented in this version kind/subtask labels May 16, 2024
@ck89119 ck89119 added this to the 1.2.0 milestone May 16, 2024
@ck89119
Copy link
Contributor

ck89119 commented May 16, 2024

之前已经改了

@ck89119 ck89119 assigned YANGGMM and unassigned ck89119 May 16, 2024
@YANGGMM
Copy link
Contributor Author

YANGGMM commented May 16, 2024

test has passed

@Ariznawlll
Copy link
Contributor

testing

@Ariznawlll
Copy link
Contributor

Ariznawlll commented May 17, 2024

系统租户恢复普通租户到普通租户:
数据量10w
测试步骤:

连接mo:
mysql -h 127.0.0.1 -P 6001 -udump -p111
create account acc01 admin_name = 'test_account' identified by '111';
acc01连接mo:
mysql -h 127.0.0.1 -P 6001 -uacc01:test_account -p111
create database sysbench_db;

git clone https://github.com/matrixorigin/mo-sysbench.git
cd mo-sysbench
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=acc01:test_account --mysql-password=111 oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=1000 --time=30 --report-interval=10 cleanup
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=acc01:test_account --mysql-password=111 oltp_point_select.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=1000 --time=30 --report-interval=10 --auto_inc=off prepare

cd mo-backup
./mo_br snapshot restore --host "127.0.0.1" --port 6001 --user "dump" --password "111" --account "acc01" --sname "sp01"

mysql -h 127.0.0.1 -P 6001 -uacc01:test_account -p111
drop table sbtest2;
drop table sbtest5;
truncate sbtest7;
delete from sbtest9 where id > 50000;
image

执行恢复之后,验证数据正确性。

测试结论:系统租户恢复普通租户到普通租户命令 成功,可以正常使用

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/subtask priority/p0 Critical feature that should be implemented in this version
Projects
None yet
Development

No branches or pull requests

5 participants