February 29, 2020 at 10:43 am
Hi guys and gals. forgive me if this questions is in the wrong place, new to the forum and sql development in general.
what I am wondering is how the design of a database schema (logical design of tables and queries) is affected by horizontal scaling given the constraint that the data being stored is unique. what i mean by this is that each server is not a mirror of a master server. an example would be a database like facebook.
thanks for taking the time to read, looking forward to your replies!!
February 29, 2020 at 12:51 pm
...how the design of a database schema (logical design of tables and queries) is affected by horizontal scaling...
Primarily through indexing. Indexes are logical objects which exist for purely physical reasons. They're the gerunds of the data world. The physical model uses partitioning and other techniques. There are a whole bunch of recipes.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
March 2, 2020 at 12:14 pm
This sounds like a NoSQL situation - basically "eventual consistency" across many nodes????
am I correct ?
MVDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply