Manticoresearch
Easy to use open source fast database for search | Good alternative to Elasticsearch | Drop-in replacement for E in the ELK stack
Install / Use
/learn @manticoresoftware/ManticoresearchREADME
Introduction
❗Read recent blog post about Manticore vs Elasticsearch❗
What distinguishes it from other solutions is:
- It's very fast and therefore more cost-efficient than alternatives, for example Manticore is:
- 182x faster than MySQL for small data (reproducible❗)
- 29x faster than Elasticsearch for log analytics (reproducible❗)
- 15x faster than Elasticsearch for small dataset (reproducible❗)
- 5x faster than Elasticsearch for medium-size data (reproducible❗)
- 4x faster than Elasticsearch for big data (reproducible❗)
- up to 2x faster max throughput than Elasticsearch's for data ingestion on a single server (reproducible❗)
- With its modern multithreading architecture and efficient query parallelization capabilities, Manticore is able to fully utilize all your CPU cores to achieve the quickest response times possible.
- The powerful and speedy full-text search works seamlessly with both small and large datasets.
- Row-wise storage for small, medium and big size datasets.
- For even larger datasets, Manticore offers columnar storage support through the Manticore Columnar Library, capable of handling datasets too big to fit in RAM.
- Performant secondary indexes are automatically created using the PGM-index (Piecewise Geometric Model index), which provides efficient mapping between indexed keys and their memory locations.
- The cost-based query optimizer uses statistical data about indexed data to evaluate and determine the most efficient execution plan.
- Manticore is SQL-first, utilizing SQL as its native syntax, and offers compatibility with the MySQL protocol, allowing you to use your preferred MySQL client.
- With clients available in PHP, Python, Python asyncio JavaScript, Typescript, Java, Elixir, Go, and Rust, integration with Manticore Search becomes easy.
- Manticore also provides a programmatic HTTP JSON protocol for more versatile data and schema management, with Elasticsearch-compatible writes support.
- Built in C++, Manticore Search starts quickly and uses minimal RAM (around 40MB RSS for an empty instance), with low-level optimizations contributing to its impressive performance.
- With real-time inserts, newly added or updated documents are immediately accessible.
- Interactive courses are available through Interactive courses to make learning a breeze.
- Manticore also boasts built-in virtually synchronous multi-master replication using the Galera library and load balancing capabilities.
- Data can be synced from sources such as MySQL, PostgreSQL, ODBC, xml, and csv with ease.
- While not fully ACID-compliant, Manticore supports isolated transactions and binary logging for safe writes.
- Effortless data backup and recovery with built-in tools like manticore-backup and SQL BACKUP command
Craigslist, Socialgist, PubChem, Rozetka and many others use Manticore for efficient searching and stream filtering.
Manticore Search was forked from Sphinx 2.3.2 in 2017.
More features
- Full-text search and relevance:
- Over 20 full-text operators and over 20 ranking factors
- Custom ranking
- Other search capabilities:
- Rich filtering functionality
- Fuzzy search
- Faceted search
- Geo-spatial search
- Vector search
- Joining tables
- Spelling correction
- Autocomplete
- A wide range of functions for filtering and data manipulation
- Natural language processing (NLP):
- Stream filtering:
- High-availability:
- Data can be distributed across servers and data-centers
- Synchronous replication
- Built-in load balancing
- Security:
- https support
- [read-
Related Skills
gh-issues
339.1kFetch GitHub issues, spawn sub-agents to implement fixes and open PRs, then monitor and address PR review comments. Usage: /gh-issues [owner/repo] [--label bug] [--limit 5] [--milestone v1.0] [--assignee @me] [--fork user/repo] [--watch] [--interval 5] [--reviews-only] [--cron] [--dry-run] [--model glm-5] [--notify-channel -1002381931352]
oracle
339.1kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
tmux
339.1kRemote-control tmux sessions for interactive CLIs by sending keystrokes and scraping pane output.
xurl
339.1kA CLI tool for making authenticated requests to the X (Twitter) API. Use this skill when you need to post tweets, reply, quote, search, read posts, manage followers, send DMs, upload media, or interact with any X API v2 endpoint.
