Starting from which version does TiFlash support creating database-level replicas instead of creating replicas for each table?

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

Original topic: 请问哪个版本开始tiflash支持创建库级别的副本,而不要每个表去创建

| username: Christophe

Which version of TiFlash started supporting the creation of database-level replicas instead of creating them for each table? Thank you!

| username: tidb菜鸟一只 | Original post link

6.0

| username: Christophe | Original post link

Thank you!

| username: TiDBer_小阿飞 | Original post link

V6.0

Build TiFlash Replicas by Database

Similar to building TiFlash replicas by table, you can send DDL commands from the MySQL client to TiDB to create TiFlash replicas for all tables in a specified database:

ALTER DATABASE db_name SET TIFLASH REPLICA count;

In this command, count represents the number of TiFlash replicas. Setting the count value to 0 means deleting the existing TiFlash replicas.

Command examples:

Execute the following command to create 2 TiFlash replicas for all tables in the tpch50 database.

ALTER DATABASE `tpch50` SET TIFLASH REPLICA 2;

Execute the following command to delete the TiFlash replicas created for the tpch50 database:

ALTER DATABASE `tpch50` SET TIFLASH REPLICA 0;
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.