A relational database like SQL is a collection of data items organized in tables. ACID is a set of properties of relational database transactions.
There are many techniques to scale a relational database: master-slave replication, master-master replication, federation, sharding, denormalization, and SQL tuning.
To learn more, visit the following links: