Tenant Isolation with CockroachDB

TPC-C schema
partition all tables via w_id ( warehouse id ) where id 0 to 33, 33 to 66 and 66 to 100 are 3 distinct tenants
Setting data placement and replication attributes for data ranges
CPU utilization
writes to range replicas on N5 and N9 which contain mirrors from N1
QPS per nodes N1,N5 and N9
Nodes n4, n8 and n12 host D tenants
Client average latency is 14 ms
  • Segregation of data with table / index partitioning, schema [ not used in this writeup] or databases
  • node locality settings to identify nodes
  • Zone configurations to map data to nodes
  • JDBC connection strings to specific nodes from application

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

THE LANDLORDS — Vol. 004

Lem-in: Finding all the paths and deciding which are worth it.

Installing PHP with NGINX on AWS LightSail Cloud Server

KuChain Biweekly Report (26/12/2020–08/01/2021)

Flutter — 5 reasons why you may love it

How I Created My First Application…

How to create and maintain an AWS serverless infrastructure with Troposphere and CodePipeline.

Code Review Methodology

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Andrew Deally

Andrew Deally

More from Medium

Compare two searching algorithms

Structural shifts in V?

CS373 Spring 2022: William Eng

HackerRank: Sum vs XOR