New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
NoSQL support #2592
Comments
Reopening as there is a lot of interest from the community to build a Nosql version of Piwik! |
two years ago we have discussed this topic in the past Nosql for Piwik for a GSoC proposal: https://github.com/piwik/piwik/wiki/GSoC-2013#project-gsoc1-multiple-database-support-implement-mongodb-adapter |
Well, it doesn't have to be completely No SQL. You may look into ClickHouse - the column-oriented DBMS used by Yandex for its own web analytics. It even has SQL syntax, so it doesn't require a complete rewrite of Piwik. |
Yes, clickhouse would be a really nice backend! |
We have just contacted Piwik's team in order to check the viability to integrate SlicingDice as a backend for Piwik. Let's see how it goes. |
What about Cassandra? |
FYI Clickhouse would be the more likely candidate we would look into eventually, as it's SQL compatible |
Benchmark looks good: https://clickhouse.yandex/benchmark.html#[%2210000000%22,[%22ClickHouse%22,%22MySQL%22],[%220%22]] @mattab what kind of feature you are missing? https://clickhouse.yandex/docs/en/introduction/distinctive_features/#sql-support |
While it has SQL support you need to look into some details. Eg does it support delete/update and if supported, is it fast. Does it support eg 10 to 20 joins, does it support all kind of alter table statements etc. |
Closing this issue as a duplicate of #7526 |
Hi,what need to do if i wanna to use clickhouse as backend of matomo? |
@flyonce Afaik we don't have supporting any other database backend on our roadmap, as it would require to much work. |
Using Mongodb, Hadoop, Tokudb, Piwik could scale to greater limits.
This ticket is an invitation to the community to comment and discuss the Nosql support of Piwik!
References:
The text was updated successfully, but these errors were encountered: