With more backups the cluster has the worse writing performance since data will be copied by multiple times. But the reading performance should be increased since each node answers the request from local backup.
Thanks Gesendet mit der Telekom Mail App <http://www.t-online.de/service/redir/emailmobilapp_ios_smartphone_footerlink.htm> -----Original-Nachricht----- Von: Maximiliano Gazquez <maximiliano....@gmail.com <mailto:maximiliano....@gmail.com> > Betreff: [2.8.1] Having more backups make SQL queries slower. Datum: 01.12.2021, 00:12 Uhr An: <user@ignite.apache.org <mailto:user@ignite.apache.org> > Hello everyone. We are doing some testing in a 10 node cluster which we use as a distributed database with persistence enabled. Each node has 6gb region size + 5gb heap. All caches are partitioned, and I connect to the cluster using the thin client. I’ve found a performance issue: * With 2 backups, the performance is pretty great. * With 4 backups the performance is really bad. So I wanted to ask why would this happen. I assumed that queries are distributed and each node answers the query only with its primary partitions and adding backups wouldn’t affect performance. Thanks everyone!
