Features of MySQL
- MySQL is a relational database management system (RDBMS): It is a collection of many programs and makes relations with many other programs.
- Easy to use MySQL database: MySQL is very easy to use and user-friendly hence easily install and manipulate.
- MySQL database is fully secure: MySQL has a very strong data security layer to protect sensitive data like password, sensitive information, etc. from intruders. Passwords are encrypted in the MySQL database.
- MySQL follows a client and server architecture: MySQL works on client-server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server by query data, save data, changes in data, etc.
- Open source and free do download: MySQL is free to download means there is no cost to pay for downloading. You can download it from its official website.
- MySQL is scalable: MySQL can handle generally any amount of data, up as much as 50 million rows or more. The default size limit is about 4GB. You can increase this limit up to the theoretical limit of 8TB of data.
- MySQL database is compatible with many operating systems: MySQL compatible to run with many operating systems, like Windows, Linux, many verities of UNIX Such as Sun* Solaris*, AIX, and DEC* UNIX Novell Netware.
- MySQL allows roll-back: MySQL allows the transaction to roll back, commit and crash recovery.
- MySQL is faster: MySQL is faster, and more reliable and cheaper because of its unique storage system.
- MySQL is also highly flexible: MySQL is embedded with a large number of applications which makes MySQL very flexible.
- MySQL has high productivity: MySQL delivers developers high productivity because MySQL triggers store procedures and views.
Disadvantage or Drawback of MySQL
Few disadvantages of MySQL are as follow:
- MySQL does not support large database size much effectively.
- MySQL does not handle translation much effectively and it is prone to data corruption.
- MySQL does not support SQL check constraints.
- MySQL version less than 5.0 does not support ROLE, COMMIT and Stored Procedure.
- MySQL does not have a good developing and debugging tool compared to paid databases.