add parameter to decide some rows to put in specific tikv instance.

[zhuboshuai]

Feature Request

Is your feature request related to a problem? Please describe:

some data are historical data and are rarely accessed , I hope put them to specific tikv instance based on HDD.
Describe the feature you'd like:

give a condition for exampe "t1.ts1 > 1546071291 = tikv11", the data in table t1 satisfying ts1 > 1546071291 can store in tikv11 instance.
Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

put some data in slow performance disks. improve the data govermance ability.

[jackysp]

Good suggestion, @zhuboshuai !
We already have plans to do something similar.

[zhuboshuai]

Good suggestion, @zhuboshuai !
We already have plans to do something similar.

thanks!

[zz-jason]

@nolouch Can we achieve this by placement rules?

[nolouch]

Yes, maybe you can use partition and move the partition to the HDD. something similar we are doing now, you can check it in #18030. @zhuboshuai

[zz-jason]

I'm going to close this issue:

• TiDB 4.0 supports placement rule in PD. you can follow the user document to manually place code data to HDD disks.
• For usability improvement, defining placement rule with SQL is scheduled to be delivered in TiDB 5.0. It's a P0 priority feature, you can trace the progress in Define the placement of data by SQL statements #18030