Hi,
I set up a small mysql-cluster configuration with two ndbd/API machines
- so there is ndbd and mysqld running on both of them. But I am not able
to find a way how to change a way the mysqld process communicates with
ndbd - it seems, that the machines are sending request to remote ndbd
(not local), so even not much complex queries take a long time (one
simple query with "order by" statement takes about 15 second and the
table has only about twenty thousand rows). When I kill one of the ndbd
processes, the query takes only 0,2 sec on the machine with both ndbd
and mysqld running and still 15 seconds on the other machine. When I
start it up again, both machines have again the response time about 15
seconds.
So my question is - is there a way, how to tell mysqld, that it should
use only local ndb daemon for querying? Or will this issue be resolved,
if I start using indexing everywhere I could?
Thanks in advance
Lukas Pecha