In this section we will read about what is MySQL, MySQL distribution, MySQL features, MySQL architecture etc.
MySQL unofficially, pronounced as My Sequel is a Relational Database Management System that allows for accessing the database. The development, distribution, and support of MySQL is done by the Oracle corporation. Initially MySQL's development, distribution, and support authority was in under the MySQLAB later, undertaken by Oracle corporation. MySQL is mostly used in the web applications. Popularly MySQL is used with the platforms like "LINUX", "APACHE", "PERL", "PYTHON","PHP".
MySQL is a database management system. Database Management System is a software that manages your data. These data can be anything like a picture gallery, single shopping list etc. DBMS plays an important role in computing, standalone utilities, or as parts of other application.
MySQL database is a relational. In a Relational database data is stores into a table. In the relational database, logical model provides a flexible programming environment using the various objects like tables, views, rows, columns. You can specify the various relationship rules between different data fields e.g. one-to-one, one-to-many, unique, required or optional etc.
MySQL is an open source i.e. it is available as free to use and modify. It is distributed under the GPL (GNU General Public License) licensing. However, it is also available as commercial version, you would have to pay for this. Commercially available product of MySQL may contains some additional features.
MySQL server can be run on different architecture with no or little requirements. It can run on web server, desktop, laptop etc. Other Features of MySQL are listed below :
- Easy To Use
MySQL is suitable for accessing the database on the internet due to its connectivity, speed, and security.
MySQL is based on the client/server architecture. It provides the APIs, administrative tools, various different libraries etc. MySQL composes the multi-threaded SQL server that allows different backends.