Currently, our cluster is hosting several databases. One of the
databases is growing and growing and growing ... and the nodes are
starting to swap memory to disk.
So, we want to take out that database from the cluster.
But, I want to know if I can just change the table engine to innodb and
this will take the tables off memory and the data will be always stored
Yes, I know that the innodb engine will not be propagated over the
cluster, but I can deal with this because the client can connect
directly to the IP of the node that host that disk-based database
instead of the load balancer.
Will this work ? If I change tables to use innodb instead of ndb will
take out the tables from the memory ?