Re:NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak
by elchief on Friday November 02, 2012 @07:40PM
(#4735301)
MyISAM is fast at reads. You can use innodb for the transactional, writeable master, and replicate to MyISAM for read-only slaves. This also gives you full-text search.
[ Parent
| on HN ]
Re:NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak
by HarrisonFisk on Friday November 02, 2012 @07:47PM
(#4735327)
Then your slaves will lag really badly while the replication thread keeps stalling on table level locks.
InnoDB is faster at reads for most workloads on modern hardware. MyISAM has horrible scalability across multiple CPUs. MariaDB recently improved in MyISAM with the segmented key cache, but I haven't seen any results of head-to-head benchmarks since then.