Saturday, November 15, 2008

Using Open Source RDBMS : MySQL

MySQL is written in C and C++. The SQL parser uses yacc and a home-brewed lexer, sql_lex.cc. MySQL is one of the best RDBMS being used for developing web based software applications. It is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications. It is an Open Source Relational SQL database management system.
There are 3 types of MySQL Server Compilations for Enterprise and Community users:
Standard: The MySQL-Standard binaries are recommended for most users, and include the InnoDB storage engine.
Max: (not MaxDB, which is a cooperation with SAP AG) is mysqld-max Extended MySQL Server. The MySQL-Max binaries include additional features that may not have been as extensively tested or are not required for general usage.
MySQL-Debug binaries: These have been compiled with extra debug information, and are not intended for production use, because the included debugging code may cause reduced performance.
Beginning with MySQL 5.1, MySQL AB has stopped providing these different package variants. There will only be one MySQL server package, which includes a mysqld binary with all functionality and storage engines enabled. Instead of providing a separate debug package, a server binary with extended debugging information is also included in the standard package.
MySQL is used in web applications and acts as the database component of the LAMP software stack. Its popularity for use with web applications is closely tied to the popularity of PHP, which is often combined with MySQL. Several popular and high-traffic web sites including Flickr, Facebook, Wikipedia, Google, Nokia, Auctionmarts and YouTube use MySQL for data storage and logging of user data.
MySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes.
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64 and Microsoft Windows. A port of MySQL to OpenVMS is also available
Before you begin with MySQL it will be an added advantage if you posses the basic knowledge and information on PHP and HTML Scripts.

0 comments:

Post a Comment