I’m currently working on a project involving storing data with simple relationships among tables (no complex join required). Although it is desirable to have somewhat strong fault tolerant attributes. Some tables could have records in the order of say 100M~200M. I’m currently using cockroach db. The ease of deployment and the level of community support really help me expedite the development. The ease of deploying/administrating the cluster is also a great feature.
However, some colleague of mine were complaining that we can only get 1000 qps with cockroach db. And due to it’s intrinsic design of not being ‘column based’ it cannot be our long term solution. And they are suggesting using something like kudu. Not knowing the internal design of cockroach db I cannot really say if they are making a good assertion or not. I’ll be very appreciated if anyone can provide me with some insights.