If the schema of a table in the TiFlash side gets broken for some reason, there could be a less costly approach for rebuilding that table:
- Apply
alter table <table_name> set tiflash replica 0 on TiDB and wait till all regions of that table get removed from TiFlash
- Use
drop table db_<db_id>.t_<table_id> through TiFlash HTTP API to drop that table in TiFlash side
- Trigger the sync schema through TiFlash HTTP API to fetch and rebuild that table schema
- Apply
alter table <table_name> set tiflash replica <num> on TiDB to rebuild TiFlash regions data
If the schema of a table in the TiFlash side gets broken for some reason, there could be a less costly approach for rebuilding that table:
alter table <table_name> set tiflash replica 0on TiDB and wait till all regions of that table get removed from TiFlashdrop table db_<db_id>.t_<table_id>through TiFlash HTTP API to drop that table in TiFlash sidealter table <table_name> set tiflash replica <num>on TiDB to rebuild TiFlash regions data