zheap
clickhouse-operator
zheap | clickhouse-operator | |
---|---|---|
3 | 5 | |
88 | 1,730 | |
- | 1.8% | |
10.0 | 9.8 | |
over 3 years ago | 7 days ago | |
HTML | Go | |
- | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
zheap
-
Tracking down high CPU Utilization on Amazon Aurora PostgreSQL
Hoping something like the zheap storage engine initiative should help us get past these bottlenecks in the future. Until then we may not be able to prevent the bloat but could certainly minimize the impact.
-
Building an interface (even if there's only one implementation) is always right
Hey, OP here -- it is a bit odd and also possibly immature to be so harsh on MySQL apropos of nothing. That said, I intended more to be pro-Postgres rather than anti-MySQL (it's a great piece of software, other DBs and Postgres learn from it all the time, zheap[0] exists to replicate what they've built, for example).
I also have to admit that I definitely want postgres every time I see MySQL. Maybe I need to read more on just how easy and amazing MySQL can be. Links welcome!
[0]: https://cybertec-postgresql.github.io/zheap/
-
Databases in 2021: A Year in Review
Postgres's dominance is well deserved, of course. My only concerns with it, both are actively worked on, are bloat management (significant for update heavy workloads and programmers used to the MySQL model of rollback segments) and the scaling of concurrency (going over 500 connections). Bloat was taken over by Cybertec[1] after stalling for a bit and is funded (yay), while concurrency was also enhanced out of Microsoft [2]. All in all, an excellent future for our beloved Postgres.
[1] https://github.com/cybertec-postgresql/zheap
clickhouse-operator
-
ClickHouse Cloud is now in Public Beta
but this pricing looks excessive.
A single node instance with a fast disk is more than sufficient for most needs: https://hub.docker.com/r/clickhouse/clickhouse-server
If you need a cluster, https://github.com/Altinity/clickhouse-operator makes things easy
-
Databases in 2021: A Year in Review
Altinity is doing a good job of this with Clickhouse. They offer some decent open source guides for self hosting[0] and offer a hosted option. The hosted option is as self serve as I'd like (you have to get "approved").
0 - https://github.com/Altinity/clickhouse-operator and
-
Show HN: Distributed Tracing Using OpenTelemetry and ClickHouse
Where is the clickhouse data stored, in the Docker container?
For reference, here's what I'm using: https://github.com/Altinity/clickhouse-operator/blob/master/...
-
What's New in ClickHouse 21.12
ClickHouse works great on Kubernetes. Check out the ClickHouse Operator for Kubernetes. [0] We just added a UI to it, blog article out shortly.
[0] https://github.com/Altinity/clickhouse-operator
Disclaimer: I work at Altinity.
-
What is ClickHouse how it compares to PostgreSQL and TimescaleDB for time series
Don't use helm. The ClickHouse Kubernetes Operator is the way to go. Here's the project: https://github.com/Altinity/clickhouse-operator
This is generally true for most databases these days. Use an operator if it's available. Helm can't handle the dynamic management required to run databases properly.
What are some alternatives?
sysbench - Scriptable database and system performance benchmark
jaeger-clickhouse - Jaeger ClickHouse storage plugin implementation
dbdb.io - The On-line Database of Databases
uptrace - Open source APM: OpenTelemetry traces, metrics, and logs
zombodb - Making Postgres and Elasticsearch work together like it's 2023
django-simple-history - Store model history and view/revert changes from admin site.
signoz - SigNoz is an open-source observability platform native to OpenTelemetry with logs, traces and metrics in a single application. An open-source alternative to DataDog, NewRelic, etc. 🔥 🖥. 👉 Open source Application Performance Monitoring (APM) & Observability tool
pev2 - Postgres Explain Visualizer 2
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
dbt-clickhouse - The Clickhouse plugin for dbt (data build tool)