Is it possible to run two TiKV nodes, one SSD node, and one HDD node on the same ECS instance?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 同一个ecs实例是是否支持运行两个Tikv节点,一个SSD节点,一个HDD节点?

| username: xiaoxiaozuofang

TiDB version: TiDB 6.1.0
Is it possible to run two TiKV nodes on the same ECS instance, one SSD node, and one HDD node?

| username: h5n1 | Original post link

Different TiKV instances can use different disks, which can affect performance. TiKV generally requires at least three instances; if two out of three fail, the system will mostly become unusable.

| username: xiaoxiaozuofang | Original post link

Running two TiKV instances on a single ECS, one using an SSD disk and the other using an HDD disk, and creating a data placement policy, can this achieve hot and cold data separation? Is it feasible to do this?

| username: h5n1 | Original post link

You can search for “placement rules in SQL” on TUG, there are many related articles.

| username: forever | Original post link

It is a copy of the data, if the data on the SSD is deleted, it will also be gone from the HDD.

| username: alfred | Original post link

It can be created, but it is not recommended to use it this way in a production environment.