MySQL is an open source relational database system that's used by websites such as Facebook, Flickr, Twitter, and YouTube because it supports stored procedures, cursors, triggers, and all the SQL database features.
Advantages of MySQL
- Simple and easy to use
- Good performance with a wide range of queries and primary keys
- Effectively processes data that's GBs to a few TBs in size, with a limited level schema complexity
- Follows the ACID methodology accurately
- Follows the schema-on-write methodology where it pre-validates the records during insertion
Disadvantages of MySQL
- Difficult to scale MySQL after a certain level.
- Designed to run on a single machine, which means a single point of failure and lesser availability.
- Being a part of the relational database system focuses on normalization and data duplication, which results in multiple joins. After a while, when data grows exponentially, this leads to a massive...