MyIsam vs NDB On Inserts
I'm considering ways to increase performance of our persistence layer. We want to achieve as many inserts per second as we can and we don't need any transactions at the moment. What I want to know is what MySQL engine faster: standard MyIsam or single-node NDB cluster which will be accessed via ClusterJPA/ClusterJ? P.S. This guy has got a benchm开发者_C百科ark which shows that ClusterJ access to NDB is ~10 times faster than jdbc driver access: http://www.clusterdb.com/mysql-cluster/using-clusterjpa-part-of-mysql-cluster-connector-for-java-%E2%80%93-a-tutorial/
Since NDB is memory based it should perform faster. Also the data is written to the files in a back-end process whereas MyISAM does this on file at the same time.
The performance also depends on how many nodes you have i.e., do you have more than one NDB nodes or just one. As in the later case you don't get any parallelism.
精彩评论