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

feat(shannon): Multi-layer Storage Hierarchy #224

Open
ShannonBase opened this issue Aug 27, 2024 · 0 comments
Open

feat(shannon): Multi-layer Storage Hierarchy #224

ShannonBase opened this issue Aug 27, 2024 · 0 comments
Labels
feature it will be implemented as a new feature

Comments

@ShannonBase
Copy link
Contributor

ShannonBase commented Aug 27, 2024

Summary

Description for this feature.

Using multi-layer storage hierarchy strategy to keep the balance between data volumn and performance.

layer 0                     layer 1                 layer 2
------------            ---------------        ---------------
  memory     <--->      high speed          <-->    disk
                               disk
------------           ----------------       ---------------

The warm data can be offloaded to layer 1 disk or loaded from layer 1 disk.

for example,we can create a tablespace for warm data, which located on layer1 disk. Due to layer1 is high speed disk(NVME, etc.), we will achieve a bettern performance.

CREATE TABLESPACE ts1 ADD DATAFILE ts1.ibd '/path/to/high-speed-disk/../ts1.ibd';
@ShannonBase ShannonBase added the feature it will be implemented as a new feature label Aug 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature it will be implemented as a new feature
Projects
None yet
Development

No branches or pull requests

1 participant