Research & Documentation 04 Mysql

4R - MySQL

MySQL Documentation

The relational database management system known as MySQL is used to store and manage data along with many other uses. The uses include storing data in tables that will be organized into physical files and to manage data by allowing users of this RDBMS to create, update, delete, retrieve, and insert tables. A major part of MySQL is supporting web applications as MySQL is apart of the LAMP Stack (Linux, Apache, MySQL, Perl/Python/PHP). It is also a top choice for many open source apps such as, WordPress, Drupal, Joomla, and Magneto.

MySQL vs Other Databases

MySQL is similar to other databases for multiple reasons starting with the most obvious one, storing data in tables and rows. Another being that many other databases use SQL structured query language to access the data within, these other databases being PostgreSQL, Oracle, and Microsoft SQL Server. Other certain databases will use what is called NoSQL, which is a database that stores data in a non-relational format. These are known for being flexible and easy to develop. Using data structures, like documents, graphs databases, and key-value stores to store and retrieve data. Systems that use NoSQL are MongoDB, Cassandra, Redis, and Amazon DynamoDB.

Usage of MySQL worldwide

MySQL is one of the top database management systems in the open source category, known for its reliability, performance, scalability and smooth workflow. MySQL is used in high-traffic applications that you may use such as Facebook, Netflix, Uber, Airbnb, Shopify, and Booking.com. MySQL is the second most popular DMS in the world, after Oracle taking the top spot. MySQL however, is a popular choice for many developers.

Summary

Overall, MySQL is a great choice for a Database Management system for various reasons such as it is easy to use, prioritizes data security with access privilege system and user account management, high performance, is open source, scalable, and is highly efficient. It is ranked number second in the world for most used DMS's for a reason.