Can relational database scale horizontally in mysql?

Question

Can relational database be horizontal scaling? Will it be somehow based on NoSQL database?

Do someone have any real world example?

How can I manage sql requests, transactions, and so on in such database?

Answer 1

Answer will be ‘YES’, Relational database or RDBMS databases are vertically Scalable When load increase on RDBMS database then we scale database by increasing server hardware power ,need to by expensive and bigger servers and NoSQL databases are designed to expand horizontally and in Horizontal scaling means that you scale by adding more machines into your pool of resources.

Curious about how does data is stored and manipulated? Want to learn about it? Here is the Database Course provided by Intellipaat.

The important here  is as we can see tables in SQL databases are normalized into multiple tables of related data. In order to shard data of such tables on multiple machines, you would need to shard related normalized data accordingly which in turn would increase maintenance efforts.