The chart below aims to give you a really basic understanding of how the capability of a DBMS is increased to handle a growing amount of load.
visual Guide 
by Jean Michel Eid
by Jean Michel EidScaling Databases
Learn the ups and downs of different database scaling strategies