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

Features of MySQL

1.Client/ Server Architecture: MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc

2. Compatible  on various operating systems: MySQL is compatible to run on many operating systems Windows, Linux, many varieties of UNIX and others. MySQL also provides a facility that the clients can run on the same computer as the server or on another computer via a local network or the Internet.

How above mentioned feature works:

1. There is no need for the client to be running on the same computer system as the server. Instead, requests can be sent by the client over a network or internet connections to the server on a remote host This makes the database available to greater numbers of users than a shared-file DBMS offers.

2. MySQL work with various operating systems. It can be downloaded and installed on avail all features of MySQL with SQL compatibility rich user interface and fast processing speed.

Application Using MySQL:

phpMyAdmin : It  is a browser-based MySQL database administration tool written in PHP. It provide personal graphical interface administration tool with ease of use and big list of features. You can easily export database for backup and migrate into other server. It also give import import database easily and effortlessly.