Sample Header Ad - 728x90

MySQL NDB Cluster settings to prefer data node on localhost than remote

0 votes
2 answers
280 views
My current MySQL NDB Cluster configuration: - Server 1 - management node - Server 2 - huge machine running both ndbd and mysqld - Server 3 - huge machine running both ndbd and mysqld - NoOfReplicas = 1 So server 2 has exact copy of server 3 data During setup evaluation I discovered that mysqld on server 2 is sending about 50% queries to ndbd running on server 3. With greater number of nodes this would be OK to provide load-balancing, but with my specific configuration (both nodes have same dataset) I'd like to get max performance by telling mysqld on each server to PREFER connecting to ndbd process running on localhost, and only connect ndbd on remote host only if local is not available (ie restart) I've read something about server access cost table that should contain information for query optimizer about latency between nodes, but I can't find this blog post right now. Any help?
Asked by Matthias (149 rep)
Nov 9, 2016, 03:00 PM
Last activity: May 13, 2025, 12:00 PM