Introduction

A relational database management system (RDBMS) is an essential tool in many environments, from traditional uses in business, research, and educational contexts, to applications such as powering search engines on the Internet. However, despite the importance of a good database system for managing and accessing information resources, many organizations have found them to be out of reach of their financial resources. Historically, database systems have been an expensive proposition, with vendors charging healthy fees both for software and for support. Also, because database engines often had substantial hardware requirements to run with any reasonable performance, the cost was even greater.

MySQL is an open source database, a SQL client/server relational database management system originating from Scandinavia. MySQL includes an SQL server, client programs for accessing the server, administrative tools, and a programming interface for writing your own programs. Initially, MySQL became widely popular because of its speed and simplicity. But there was criticism, too, because it lacked features such as transactions and foreign key support. MySQL continued to develop, adding not only those features but others such as replication, subqueries, stored procedures, views, and triggers. These capabilities take MySQL into the realm of enterprise applications. As a result, people who once would have considered only “big iron” database systems for their applications now give serious consideration to MySQL.

MySQL is portable and runs on commercial operating systems (such as Mac OS X, HP-UX, and Windows) and on hardware all the way up to enterprise servers. Furthermore, its performance rivals any database system you care to put up against it, and it can handle large databases with billions of rows. In the business world, MySQL’s presence continues to increase as companies discover it to be capable of handling their database needs at a fraction of what they are used to paying for commercial licensing and support.

Why Choose MySQL?

If you’re looking for a free or low-cost database management system, several are available from which to choose, such as MySQL, PostgreSQL, or SQLite.When you compare MySQL with other database systems, think about what’s most important to you. Performance, support, features (such as SQL conformance or extensions), licensing conditions and restrictions, and price all are factors to take into account. Given these considerations, MySQL has many attractive features to offer:

1) Speed. MySQL is fast. Its developers contend that MySQL is about the fastest database system you can get.You can investigate this claim by visiting http://www.mysql.com/why-mysql/benchmarks/, a performance-comparison page on the MySQL Web site.

2) Ease of use. MySQL is a high-performance but relatively simple database system and is much less complex to set up and administer than larger systems.

3) Query language support. MySQL understands SQL (Structured Query Language), the standard language of choice for all modern database systems.

4) Capability. The MySQL server is multi-threaded, so many clients can connect to it at the same time. Each client can use multiple databases simultaneously.You can access MySQL interactively using several interfaces that let you enter queries and view the results: command-line clients, Web browsers, or GUI clients. In addition, programming interfaces are available for many languages, such as C, Perl, Java, PHP, Python, and Ruby.You can also access MySQL using applications that support ODBC and .NET (protocols developed by Microsoft).This gives you the choice of using prepackaged client software or writing your own for custom applications.

5) Connectivity and security. MySQL is fully networked, and databases can be accessed from anywhere on the Internet, so you can share your data with anyone, anywhere. But MySQL has access control so that one person who shouldn’t see another’s data cannot.To provide additional security, MySQL supports encrypted connections using the Secure Sockets Layer (SSL) protocol.

6) Portability. MySQL runs on many varieties of Unix and Linux, as well as on other systems such as Windows and NetWare. MySQL runs on hardware from high-end servers down to small personal computers (even palmtop devices).

7) Small size. MySQL has a modest distribution size, especially compared to the huge disk space footprint of certain other database systems.

8) Availability and cost. MySQL is an Open Source project available under multiple licensing terms. First, it is available under the terms of the GNU General Public License (GPL).This means that MySQL is available without cost for most in-house uses. Second, for organizations that prefer or require formal arrangements or that do not want to be bound by the conditions of the GPL, commercial licenses are available.

9) Open distribution and source code. MySQL is easy to obtain; just use your Web browser. If you don’t understand how something works, are curious about an algorithm, or want to perform a security audit, you can get the source code and

Tools Provided with MySQL

MySQL distributions include the following tools:

1) An SQL server. This is the engine that powers MySQL and provides access to your databases.

2) Client and utility programs. These include an interactive client program that enables you to enter queries directly and view the results.Also available are several administrative and utility programs that help you run your site: One allows you to monitor and control the server; others let you import data, perform backups, check tables for problems, and more.

3) A client library for writing your own programs.You can write client programs in C because the library is in C, but the library also can be linked into other language processors such as Perl, PHP, or Ruby to provide the basis for MySQL interfaces in those languages. In addition to the software provided with MySQL itself, MySQL is used by many talented and capable people who like writing software to enhance their productivity and who are willing to share that software.The result is that you have access to a variety of third-party tools that make MySQL easier to use or that extend its reach into areas such as Web site development.

From Where to get the software.:- http://www.dev.mysql.com