Please enable JavaScript.
Coggle requires JavaScript to display documents.
distributed database - Coggle Diagram
distributed database
why
not possible to store them in 1 machine
data has grown so much
scaling relational db
scaling up
there are 3 drawbacks
cost
increases exponentially with new hardware
availability
growth
migration to powerful hardware is inevitable
scaling out
read replica
primary database is for writting
multiple secondary DB
used for reading
can be located in different location
partitioning data
splitting the table
horizontal partition
split table into multiple physical partition
vertical partition
problems
joins become slow
join across multiple partition is expensive
solutions
Google Cloud Spanner
Oracle RAC