My current MySQL NDB Cluster
configuration:
- Server 1 - management node
- Server 2 - huge machine running both
ndbd
andmysqld
- Server 3 - huge machine running both
ndbd
andmysqld
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?