Author: Igor Donchovski

How to fix error when MySQL client fails to load SQL file with Blob data

In one of my latest database restore jobs, I was helping a MySQL client with issues related to mysqlbinlog and I wanted to share it here. In case you didn’t know, MySQL is a simple SQL shell with input line…

Read More >

Text index usage within MongoDB

Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The db.showIndexes() command shows an index on a text field, but explain() shows COLLSCAN and the query is…

Read More >

Priority in MongoDB replica sets

I had interesting use case with a MongoDB replica set I’d like to share. When the replica set consists of four nodes and the Primary goes down, no new node is elected to become the new Primary. The replica set…

Read More >

MongoDB Europe 2017 recap

It’s November, time for MongoDB Europe event. For the second consecutive year, London hosted all the MongoDB experts to share what is new and exciting about the most popular NoSQL database in the world. After I missed the event last…

Read More >

Exploring the operations log in MongoDB

Igor Donchovski, Database Consultant at Pythian, explains the MongoDB Operations log. Discover how the replication window compares to MySQL, how to change the oplog size, and what is improved in MongoDB 3.0 wiredTiger engine.

Read More >