Manticore Search: OSS fast database for search - alternative for Elasticsearch
-
Website • Downloads • Docs • Blog • Courses • Forum • Slack • Telegram (En) • Telegram (Ru) • Twitter User feedback
Introduction
Read recent blog post about Manticore vs ElasticsearchManticore Search is an easy to use open source fast database for search. Good alternative for 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)
- 182x faster than MySQL for small data (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, saving you time and effort.
- The cost-based query optimizer optimizes search queries for optimal performance.
- 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, JavaScript, Java, Elixir, and Go, integration with Manticore Search becomes easy.
- Manticore also provides a programmatic HTTP JSON protocol for more versatile data and schema management.
- Built in C++, Manticore Search starts quickly and uses minimal RAM, with low-level optimizations contributing to its impressive performance.
- With real-time inserts, newly added documents are immediately accessible.
- Interactive courses are available through Interactive courses to make learning a breeze.
- Manticore also boasts built-in replication and load balancing for added reliability.
- Data can be synced from sources such as MySQL, PostgreSQL, ODBC, xml, and csv with ease.
- While not fully ACID-compliant, Manticore still supports transactions and binlog to ensure safe writes.
- Effortless data backup and recovery with built-in tools and SQL commands
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
- Faceted search
- Geo-spatial search
- Spelling correction
- Autocomplete
- A wide range of functions for filtering and data manipulation
- Natural language processing (NLP):
- Stream filtering using a "percolate" table
- High-availability:
- Data can be distributed across servers and data-centers
- Synchronous replication
- Built-in load balancing
- Security:
- Data safety:
- manticore-backup tool and SQL command BACKUP to back up and restore your data
- Data storages:
- row-wise - requires more RAM, provides faster performance
- columnar - requires less RAM, still provides decent performance, but lower than the row-wise storage for some kinds of queries
- docstore - doesn't require RAM at all, but allows only fetching original value, not sorting/grouping/filtering
- Performance optimizations:
- Secondary indexes
- Cost-based optimizer determines the most efficient execution plan of a search query
- Data types:
- full-text field - inverted index
- int, bigint and float numeric fields in row-wise and columnar fashion
- multi-value attributes (array)
- string and JSON
- on-disk "stored" for key-value purpose
- Integrations:
--
@staff consider this for email and other Cloudron services in need of search.
- It's very fast and therefore more cost-efficient than alternatives, for example Manticore is:
-
L LoudLemur referenced this topic on
-
9.2.14 is the latest Manticore version.
https://github.com/manticoresoftware/manticoresearch/releases/tag/9.2.14Here are the improvements since Manticore was first requested:
https://github.com/manticoresoftware/manticoresearch/compare/9.2.14...6.0.4 -
Looks good! Is this something that needs to be integrated to Cloudron itself, or as a separate app?
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login