Company
Date Published
Author
Alec Powell
Word count
963
Language
English
Hacker News points
None

Summary

SingleStore is an Enterprise Cloud database that delivers the requirements for a multi-tenant platform through its rich analytical and transactional capabilities, scalability to hundreds of nodes in a cluster leveraging shared nothing commodity hardware, and extreme data ingestion. The key to implementing multi-tenancy is selecting one of three architectural patterns: Separated Database, Separate Schema, or Shared Schema. Each pattern has its benefits and drawbacks, such as increased maintenance costs for the Separated Database model, cost savings with reduced hardware resources in the Separate Schema model, and painless schema changes with the Shared Schema model. SingleStore supports these models through features like Role-Based Access Control (RBAC) and Row-Level Security (RLS), allowing developers to choose the best approach for their multi-tenant application needs.