Databases Archive

AWS RDS Proxy review

RDS Proxy has just recently became generally available and IĀ decided to make a small test, since our company needs connection pooling and is very zero downtime oriented. We were thinking of running our own EC2 instances with SQL Proxy in the past, but now that this service became available on AWS it was a no-brainer

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