issues
search
AnalogJ
/
thesparktree-blog
github pages.
https://blog.thesparktree.com
0
stars
1
forks
source link
Database Architecture Questions
#102
Open
AnalogJ
opened
4 years ago
AnalogJ
commented
4 years ago
Database Architecture Questions
General Architecture
High-Level Architecture diagram (Service focused, with instance numbers/sizes)
High-Level Database cluster diagram
Do you use dedicated servers in AWS
Region(s) you're deployed in
High Availablity design
Disaster Recovery design
Configuration Management
Do you use a configuration management system
Ingress IOPS to API
Database
Is the database sharded
Do you have long running queries, what are they for
Do you store binary data in Cassandra
What are the different types of structured/partially-structured data you store in Cassandara
What unstructured/raw data do you store in Cassandra
Query types:
% of queries that are aggregation of metrics/data
% of queries that require (near-)realtime data
% of queries that access historical data
query frame for each (last x minutes/hours/days)
query interval for each (run daily, weekly, monthly)
Database storage ingress rate (mb/gb/tb per second) for each type of data
Database storage lifecycle
how long does your stuctured and unstructured data need to be accessible
under what conditions can it be deleted
Are there other Cassandra specific features you require. Can you use dynamically scalable Aurora or RDS?
Database Architecture Questions
General Architecture
Configuration Management
Database