Database Sharding
One way or another, a situation arises when, over time, you have to work with huge tables on the database server. This may be due to your application suddenly becoming popular. Traffic and data is…
A common sense approach in designing most critical systems
The availability of any application depends on the health of its components. Making an application accessible is ensuring that all components are accessible. At the physical level, this is reducing the dependence of the application…
Some Notes on Why to Use Clickhouse
In this post I try to justify with my reasons why one should use Clickhouse as a their main OLTP Database for massive analytics work loads with millisecond latency on scanning billions of rows. In…
How to install Clickhouse on AWS EC2 Linux 2 AMI
ClickHouse on AMAZON Linux AMI-2
Collecting and Analysing Data from Facebook API – Part1
Marketing analytics is research and measurement of marketing activity in quantitative indicators. At that, most often, the aim of these actions is to evaluate the efficiency of marketing, calculate the return on marketing investments in the company.Marketing analytics helps to find answers to the following questions: How efficiently the marketing budget is…
Clickhouse Cluster setup and Replication Configuration Part-2
In the previous post we discussed about basic background of clickhouse sharding and replication process, in this blog post I will discuss in detail about designing and running queries against the cluster. Cluster Setup Let us build…
Clickhouse Cluster setup and Replication Configuration Part-1
ClickHouse was specifically designed to work in clusters located in different data centers. The DBMS can be scaled linearly(Horizontal Scaling) to hundreds of nodes. This is mainly to address the scaling issues that arise with an increase…
Filter by Column MySQL vs Clickhouse
Filter by column was a typical business case requirement for reporting or creating analytical dashboards. Even though there are many OLAP databases available in market . In this blog post i will delve deep in…
Indexes in MySQL
Indexes in MySQL (Mysql indexes) are a great tool for optimizing SQL queries. To understand how they work, let’s look at working with data without them. Reading data from disk Files are stored in hard drive…
TPC-DS Benchmark On Clickhouse Part 2
Loading data Into Clickhouse In the previous post I discussed about TPCDS Data generation you can find details here The dataset I’m working with is broken up into 121 .dat files. The data generated by…