Databases Archive

Migration from MongoDB to TokuMX – Big performance gain

Benchmark About a month ago I’ve done some benchmarking. I’ve compared TokuMX, TokuMXse, MongoDB 2.6, MongoDB 3.0 and WiredTiger. My use case is mainly based on constant selects and updates, all at the same time. Inserts were made before actual select/update test. Here are my results: As you can see, TokuMX performed best. This benchmark

Tips for optimizing disk performance on Linux

Forespeech Lately I’ve been dealing mostly with storage and disk performance. We have several MySQL / MongoDB databases, which can be very I/O consuming. Usually people benchmark storage when they setup server, but running a real service on it, will actually show how really optimized the server is. Tips for optimizing your disk storage I’ll

Howto: Memcached replication = Repcached

Intro Implementation of replicated memcached is fairly easy. Even though memcache isn’t suppose to be used in this manner and should be used as violatile service, there is alternative, which can replicate data from one memcached to another. It’s called Repcached. As long as one repcached server is up, you will keep all your data

Converting your InnoDB MySQL server to TokuDB (how we did it)

What is TokuDB? TokuDB is a storage engine for MySQL and MariaDB that dramatically improves the performance of large databases (typically 50 GBs or larger). By replacing 40-year-old B-tree technology with patented Fractal TreeĀ® technology, TokuDB speeds indexing by 10x or more, and reducing the size of the database by upt o 90%. Because of

Importing large MySQL tables from command line

As you may think this is a trivial thing, it actually isn’t. You can try and import 100GB .sql file and you will fail trying (Assuming you use default MySQL configuration). Recently I had some issues importing really large databases/tables, so I decided to share some of my settings that helped me import faster and