Hi all,
what will happen if we still to set query_cache_size >0 (everywhere query_cache_size =0 is viewed as mandatory) ?
Sergey
Hi all,
what will happen if we still to set query_cache_size >0 (everywhere query_cache_size =0 is viewed as mandatory) ?
Sergey
Hi.
It depends on your load balancing method, I think.
cashing may be done within each node, so If you don’t balance read traffic with session persitency(ex. simple round robin),
cost to create cash may increase and cash hit rate would be down.
Please also be aware that there is read consistency(wsrep_causal_reads) problem.
Hmm,
so if I’m using a couple of additional nodes only for backup
(I mean that I use Galera with 3 nodes - 1 for all transactions, 2 for replications)
thank you for reply.
this is my opinion.
Performance Issue
this is the same as mysql cluster (p.40)
[url]http://www.slideshare.net/matkeep/mysql-cluster-performance-best-practices[/url]
so query cache effect would be much worse than single node, eventual performance would be worse for most of the cases.
Consistency Issue(use safety)
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.