Tuning MySQL Cluster storage nodes
In this recipe, we will cover some simple techniques to get the most performance out of storage nodes in a MySQL Cluster.
This recipe assumes that your cluster is already working and configured, and discusses specific and simple tips to improve performance.
How to do it...
MySQL Cluster supports a conditional pushdown feature, which allows for a significant reduction in the amount of data sent between SQL and storage nodes during the execution of a query. In typical storage engines, a WHERE query is executed at a higher level than the storage engine. Typically, this is a relatively cheap operation as the data is being moved around in memory on the same node. However, with MySQL Cluster, this effectively involves ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
