Question

System administrators are frequently called upon to set up and administrate MySQL databases. MySQL is the M in LAMP (Linux, Apache, MySQL, PHP/Perl/Python), an open-source enterprise software stack. Many programming languages provide an interface to MySQL, including C, PHP, and Perl.

• Select and discuss 2 features of MySQL.
• Explain how the features work and why you selected them.
• In addition, provide an example of an application that might use a MySQL database.

Answer 1

What MySQL means?

• MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). ... Although it can be used in a wide range of applications, MySQL is most often associated with web applications and online publishing.
• MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Flickr,MediaWiki, Twitter,and YouTube.

Select and discuss 2 features of MySQL.

Explain how the features work and why you selected them.

• Easy to use: MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements.
• It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.
• Compatibale on many operating systems: MySQL is compatible to run on many operating systems, like Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a facility that the clients can run on the same computer as the server or on another computer (communication via a local network or the Internet).

The above are the 3 features of MYSQL and how the features work

In addition, provide an example of an application that might use a MySQL database.

• The best example I can find to explain SQL and its ACID properties is a banking system. Let’s say I want to transfer funds from my own account to my wife’s. There will be a series of calls or queries made to send the money from one account to the other. All calls must be answered and completed in order for the transaction to be completed. If a call fails, the transaction will not be completed and we’ll both keep our money (atomic). The information in each of our account won’t be affected by the transaction (consistency). Each call made to the database will only be related to our transaction (isolation). Finally, once the transaction is successful, we won’t be able to cancel it (durability).
• Examples of SQL-based databases citizens use every day include banking systems, computerized medical records, and online shopping etc.