manticoresearch

Manticore Search is an easy to use open source fast database for search. Modern MPP architecture and smart query parallelization capabilities allow to fully utilize all your CPU cores to lower response time as much as possible, when needed. Powerful and fast full-text searching which works fine for small and big datasets. Columnar storage support via the Manticore Columnar Library for bigger datasets (much bigger than can fit in RAM). SQL-first: Manticore's native syntax is SQL. It speaks SQL over HTTP and uses the MySQL protocol (you can use your preferred MySQL client). JSON over HTTP: to provide a more programmatic way to manage your data and schemas, Manticore provides a HTTP JSON protocol. Written fully in C++: starts fast, doesn't take much RAM, and low-level optimizations provide good performance. Can sync from MySQL/PostgreSQL/ODBC/xml/csv out of the box. Not fully ACID-compliant, but supports transactions and binlog for safe writes.