Manesh,
>> When running a large SELECT from a thick client node, could data be
>> fetched from the backup instead of primary partitions?
readFromBackup=true affects only cache operations, it doesn't work with SQL
queries.
>> in a two server system, if readFromBackup = False for a cache, and if
1. Reads mostly go to the primary but yes, in some circumstances it’ll read
from the backup with that configuration set to true
2. No. It’ll “rebalance,” which means backup partitions would be promoted to
primaries. Your client would still get a response
3. Yes — though in practice the window
Hi,
Can you please give some feedback on the below?
From: Mahesh Renduchintala
Sent: Tuesday, November 3, 2020 8:20 AM
To: user@ignite.apache.org
Subject: ReadFromBackup, Primary_SYNC, Backups
Hi
I have a large SQL table (12 million records) in cacheMode
Hi
I have a large SQL table (12 million records) in cacheMode partitioned.
This table is distributed over two server nodes
-1-
When running a large SELECT from a thick client node, could data be fetched
from the backup instead of primary partitions?
Below is the configuration.
/>