An Open-Source MySQL HTAP Database for OLTP, Real-Time Analytics

Hacker News

After the release of StoneDB V1.0 on GitHub, we have received lots of feedback from our community members and users. As shown in the TPC-H test reports, StoneDB V1.0 provides 10 to 100 times higher performance than MySQL, with only one tenth the total cost of ownership (TCO). Though StoneDB V1.0 provides inspiring performance, it still has some drawbacks that are rooted in its design, including long execution time for TPC-H query 16, unsatisfying performance in processing transactional workloads, and comparatively long latency in populating latest changes to analytics workloads. Therefore, we are redesigning StoneDB to eliminate these problems in our next version — StoneDB V2.0. StoneDB V2.0 will be based on MySQL 8.0. It aims to achieve at least 10 times higher query performance on TPC-H than that of V1.0, with a more concise architecture and a query optimizer that can intelligently offload query workloads to corresponding storage engines. The design philosophy of StoneDB V2.0 is modularity and performance-cost balance. The following outlines the new features that will be implemented in StoneDB V2.0. To learn details about each feature, see the relevant chapter. StoneDB V2.0 will still be an open source project, which is a counterpart of close source service, MySQL Heatwave. At first, an in-memory column-based engine (IMCE) will be used. Secondly, a cost-based query engine will be developed to automatically offload transactional and analytics workloads. Thirdly, StoneDB V2.0 will provide a vectorized execution engine and support massive parallel processing. In this way, the execution performance of StoneDB V2.0 will be at least ten times as that of StoneDB V1.0. StoneDB will load the data into memory from InnoDB, just the same as MySQL Heatwave.

Visit product View on Hacker NewsDec 14, 2022

Share card

Actual performance

1points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: user, new, open · Missing: mac, agents, macos

89%89% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Indie HackersFits the IH revenue-focused audience · Strong signals: para, including · Missing: supports, reddit linkedin, podcasting

87%87% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Hacker NewsMay not resonate with HN audience · Strong signals: open source, ide, io · Missing: https docs, excited, just released

49%49% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

TrustMRRLess likely to generate early MRR · Strong signals: users, way, para · Missing: mobile apps, ios, personal

36%36% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

AppSumoMay struggle as an AppSumo deal · Strong signals: users · Missing: plus, platform, intuitive

30%30% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

15%15% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

FlyData24%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Real-time database replication to Redshift (for analytics)

Indie Hackerscommitment-full-time

Open-source and real-time orchestrator for distributed architectures70%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Open-source and real-time orchestrator for distributed architectures

Hacker News10

Memento – Mnesia Real-time Distributed Database in Elixir81%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Memento – Mnesia Real-time Distributed Database in Elixir

Hacker News5

Memento – Real-Time Distributed Database (Mnesia) in Elixir81%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Memento – Real-Time Distributed Database (Mnesia) in Elixir

Hacker News2

Crux, an open-source bitemporal Datalog database79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Crux, an open-source bitemporal Datalog database

Hacker News18

OSV, Database for open source vulnerabilities75%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

OSV, Database for open source vulnerabilities

Hacker News5

Undb open source nocode database79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Undb open source nocode database

Hacker News2

An open-source OLAP Multidimensional Database79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

An open-source OLAP Multidimensional Database

Hacker News5

Open Source Database Schemas79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Open Source Database Schemas

Hacker News3

HertzBeat – An open-source, real-time monitoring system52%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

HertzBeat – An open-source, real-time monitoring system

Hacker News3

Browse all products Analyze your launch