My SQL

My SQL is a freely available open source relational database management system (RDBMS) that uses structured query language (SQL). It is downloadable from www.mysql.org in a MySQL database, information is stored in tables. A single my SQL database can contain many tables at once and store thousands of individual records. MySQL provides you with rich set of features that support a secure environment for storing, maintaining and accessing data. MySQL is a fast, reliable, scaleable alternative too many of the commercial RDBMS available today. There are many editions of MySQL available.

MySQL was created and is supported by MySQL AB, a company based in Sweden (www.mysql.com). This company is now a subsidiary of Sun Micro-systems, which holds the copyright to most of the codebase. On April 20th, 2009 Oracle Corporation, develops and sells the proprietary Oracle database, announced a deal to acquire Sun Microsystems.

the Chief inventor of MySQL was Michael Widenius(a.k.a Monty). MySQL has been named after Monty’s daughter My. The logo of MySQL the dolphin is named as “Sakila”.

MySQL database system refers to the combination of a MySQL server instance and MySQL database. MySQL operates sync client/server architecture in which the server runs on the machine containing the databases and clients connect to the server over a network. The server operating systems is usually a Linux (like Redhat 9.0 etc.) or Windows operating system. Typically MySQL is supported on Windows XP, Windows Server 2003, Red Hat Fedora Linux and Debian Linux, and others. As With any other client/server application, MySQL is multi user database system, meaning several users can access the database simultaneously.

  • Server: The server (MySQL server) listens for client requests coming in over the network and accesses database contents according to those requests and provides that to the clients.
  • Clients: Clients are programs that connected to the database server and issue queries in a per-specified format. My SQL is compatible with the standards based SQL (structured query language). The client program may contact the server programmatically (meaning of program call the server during execution) or manually. For example, when you are issuing commands over a session to a MySQL server, you are issuing the requests to the server by typing commands at your command prompt manually. On the other hand, if you have input some data (say your credit card information on the Internet towards purchase of some goods) in a form, and the form is processed by using a server side program, then the MySQL server is contacted programmatically. This is often the case in credit card approvals, member subscriptions etc.