Does TiDB Serverless support TiFlash for analytical jobs (OLAP) just like TiDB?

73 Views Asked by At

In TiDB, I can configure and deploy TiFlash, which can be used for columnar based storage to perform OLAP tasks. In TiDB Serverless, I can see the same columnar storage is available on the dashboard. I want to use TiFlash too in TiDB Serverless.

But when I tried to run ALTER TABLE table_name SET TIFLASH REPLICA count; to create the TiFlash replica, it did not work. Are there other configurations I have to run through to enable it in the TiDB Serverless?

I tried command: ALTER TABLE table_name SET TIFLASH REPLICA count; It's not working.

2

There are 2 best solutions below

1
On

Really?I remember it's support , what's the error message?

0
On

This indeed should work. Could you check if you get any warnings for the ALTER TABLE... SET TIFLASH REPLICA... statement?

What does TABLE information_schema.tiflash_replica; return?

See also: https://docs.pingcap.com/tidbcloud/create-tiflash-replicas#check-replication-progress