TiFlash High Availability Consultation

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

Original topic: TiFlash 高可用咨询。

| username: Billmay表妹

I started 2 TiFlash instances using tiup and configured 2 TiFlash replicas.

When using TiDB and specifying the use of the TiFlash engine with the hint syntax /*+ read_from_storage(tiflash[t]) */:

  1. What are the specific rules for reading from which TiFlash replica?

  2. If one TiFlash goes down during the reading process, can it successfully switch to the other TiFlash and complete the read successfully?

| username: Billmay表妹 | Original post link

  1. The rule is to choose TiFlash that can read continuous regions as much as possible. For details, see Better read plan of region peer between TiFlash nodes - Google Docs
  2. For MPP, it will not succeed and will report an error. For cop and batchCop, it will try to read from another TiFlash.
| username: Billmay表妹 | Original post link

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