Live data from Hacker News

Ask HN: Why are there no easy-to-use highly-available open source databases?

news.ycombinator.com

41–42 of 42 posts

Re: Ask HN: Why are there no easy-to-use highly-available open source databases?

#42
Manticore Search is not in the list:

* 100% open source (GPLv2)

* Easy replication:

  - node 1: CREATE CLUSTER c; ALTER CLUSTER c ADD tbl; 

  - node 2: JOIN CLUSTER c AT 'host:port'
* Easy HA: CREATE TABLE dist TYPE='distributed' agent='...' agent='...'

* Real alternative to Elasticsearch in terms of built-in full-text search capabilities, but easier to use.

* Works fine with small and large data volumes: - with in-memory storage for smaller data - with columnar storage (separate library, Apache2 license) for big data that doesn't fit into RAM

* Does analytical queries well

* Not fully ACID-compliant (as well as Elasticsearch, Clickhouse others)

Post reply on HN