| MySQL | |
|---|---|
| Developed by | Sun Microsystems |
| Initial release | May 23, 1995 |
| Stable release | 5.0.51b (Community Server) (April 24, 2008) [+/−] |
| Preview release | 5.1.25-rc (June 8, 2008) [+/−] |
| Written in | C, C++ |
| OS | Cross-platform |
| Available in | English |
| Genre | Relational database management system |
| License | GNU General Public License or proprietary EULA |
| Website | http://www.mysql.com/ |
MySQL is a relational database management system (RDBMS)[1] which has more than 11 million installations. A software developer is a person or organization concerned with facets of the software development process wider than design and coding a somewhat broader scope of Sun Microsystems Inc ( is a multinational vendor of Computers computer components Computer software, and Information technology services Events 1430 - Siege of Compiègne: Joan of Arc is captured by the Burgundians while leading an army to relieve Compiègne Year 1995 ( MCMXCV) was a Common year starting on Sunday. Events of 1995 A software release is the distribution whether public or private of an initial or new and upgraded version of a Computer software product Events 1479 BC - Thutmose III ascends to the throne of Egypt, although power effectively shifts to Hatshepsut (according to 2008 ( MMVIII) is the current year in accordance with the Gregorian calendar, a Leap year that started on Tuesday of the Common A software release is the distribution whether public or private of an initial or new and upgraded version of a Computer software product Events 68 - The Roman Senate accepts emperor Galba. 536 - St Silverius becomes Pope (probable 2008 ( MMVIII) is the current year in accordance with the Gregorian calendar, a Leap year that started on Tuesday of the Common A programming language is an Artificial language that can be used to write programs which control the behavior of a machine particularly a Computer. tags please moot on the talk page first! --> In Computing, C is a general-purpose cross-platform block structured C++ (" C Plus Plus " ˌsiːˌplʌsˈplʌs is a general-purpose Programming language. An operating system (commonly abbreviated OS and O/S) is the software component of a Computer system that is responsible for the management and coordination In computing cross-platform (also known as multi-platform) is a term used to refer to Computer software or computing methods and concepts that are implemented A language is a dynamic set of visual auditory or tactile Symbols of Communication and the elements used to manipulate them Computer software can be organized into categories based on common function type or field of use A Relational database management system (RDBMS is a Database management system (DBMS that is based on the Relational model as introduced by E A software license (or software licence in commonwealth usage is a Legal instrument governing the usage or redistribution of copyright protected software A website (alternatively web site or Web site, a back-construction from the Proper noun World Wide Web) is a collection of Web pages A Relational database management system (RDBMS is a Database management system (DBMS that is based on the Relational model as introduced by E [2] The program runs as a server providing multi-user access to a number of databases.
MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems,[3][4] which holds the copyright to most of the codebase. A business (also called firm or an enterprise) is a legally recognized organizational entity designed to provide goods and/or services to "Sverige" redirects here For other uses see Sweden (disambiguation and Sverige (disambiguation. MySQL AB (founded 1995 acquired by Sun Microsystems 2008 was dual headquartered in Uppsala, Sweden and Cupertino, California A subsidiary, in business matters is an entity that is controlled by a bigger and more powerful entity Sun Microsystems Inc ( is a multinational vendor of Computers computer components Computer software, and Information technology services The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements. In Computer science, source code (commonly just source or code) is any sequence of statements or declarations written in some Human-readable Proprietary software is Computer software on which the producer has set restrictions on use private modification copying, or republishing.
"MySQL" is officially pronounced /maɪˌɛskjuːˈɛl/[5], not "My sequel" /maɪˈsiːkwəl/. This adheres to the official ANSI pronunciation; SEQUEL was an earlier IBM database language, a predecessor to the SQL language. Query languages are Computer languages used to make queries into Databases and Information systems Broadly query languages can be classified [6] The company does not take issue with the pronunciation "My sequel" or other local variations.
Contents |
MySQL is popular for web applications and acts as the database component of the LAMP, BAMP, MAMP, and WAMP platforms (Linux/BSD/Mac/Windows-Apache-MySQL-PHP/Perl/Python), and for open-source bug tracking tools like Bugzilla. In Software engineering, a web application or webapp is an application that is accessed via Web browser over a network such as the Internet The Acronym LAMP refers to a Solution stack of software usually Free and open source software, used to run dynamic Web sites or servers Open source is a development methodology which offers practical accessibility to a product's source (goods and knowledge Bug report redirects here To report bugs with the MediaWiki software that powers Wikipedia see WikipediaBug reports. Bugzilla is a Web -based general-purpose Bugtracker tool originally developed and used by the Mozilla project and licensed under the Its popularity for use with web applications is closely tied to the popularity of PHP and Ruby on Rails, which are often combined with MySQL. PHP is a computer Scripting language. Originally designed for producing Dynamic web pages it has evolved to include a Command line interface capability Ruby on Rails is an Open source Web application framework for the Ruby programming language. PHP and MySQL are essential components for running popular content management systems such as Drupal, e107, Joomla!, WordPress and some BitTorrent trackers. PHP is a computer Scripting language. Originally designed for producing Dynamic web pages it has evolved to include a Command line interface capability A content management system ( CMS) is a computer application used to create edit manage and publish content in a consistently organized fashion Drupal (ˈdɹuːpʰəl is a free and Open source modular framework and Content management system (CMS written in the programming language Joomla! is a free open source Content management system for publishing content on the World Wide Web and Intranets The system includes WordPress is an Open source blog publishing application. WordPress is the official successor of b2\cafelog, developed by Michel Valdrighi A BitTorrent tracker is a server which assists in the communication between peers using the BitTorrent protocol. Wikipedia runs on MediaWiki software, which is written in PHP and uses a MySQL database. ***************************************************************************************** * * MediaWiki is a web-based Wiki software application used by all projects of the Wikimedia Foundation, all wikis hosted by Wikia, and
MySQL is written in C and C++. tags please moot on the talk page first! --> In Computing, C is a general-purpose cross-platform block structured C++ (" C Plus Plus " ˌsiːˌplʌsˈplʌs is a general-purpose Programming language. The SQL parser uses yacc and home-brewed lexer. The Computer program yacc is a Parser generator developed by Stephen C In Computer science, lex is a program that generates lexical analyzers ("scanners" or "lexers" [7]
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, eComStation , OS/2 Warp, QNX, IRIX, Solaris, SunOS, SCO OpenServer, SCO UnixWare, Tru64, Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, and the 32-bit version of Windows Vista (but not the 64-bit version). In Computing, a platform describes some sort of Hardware architecture or Software framework (including Application frameworks, that allows BSD/OS (originally called BSD/386 and sometimes known as BSDi) was a proprietary version of the BSD Unix Operating system developed by Berkeley FreeBSD is a Unix-like free Operating system descended from AT&T UNIX via the Berkeley Software Distribution (BSD branch through HP-UX (Hewlett Packard UniX is Hewlett-Packard 's proprietary implementation of the Unix Operating system, based on System V (initially IBM i is an Operating system used on IBM Power Systems, a unified server platform from the former IBM System i and IBM System p servers Linux (commonly pronounced ˈlɪnəks Mac OS X (mæk oʊ ɛs tɛn is a line of computer Operating systems developed marketed and sold by Apple Inc, the latest of which is pre-loaded on all currently NetBSD is a freely redistributable Open source version of the Unix -derivative Berkeley Software Distribution (BSD Computer Operating NetWare is a Network operating system developed by Novell Inc OpenBSD is a Unix-like computer Operating system descended from Berkeley Software Distribution (BSD a Unix derivative developed at the eComStation is a PC Operating system based on OS/2, published by Serenity Systems, USA OS/2 is a computer Operating system, initially created by Microsoft and IBM, then later developed by IBM exclusively QNX (pronounced either Q-N-X or Q-nix is a commercial Unix-like Real-time operating system, aimed primarily at the Embedded systems market IRIX is a computer Operating system developed by Silicon Graphics Inc Solaris is a Unix -based Operating system introduced by Sun Microsystems in 1992 as the successor to SunOS. SunOS is a version of the Unix Operating system developed by Sun Microsystems for their Workstation and server Computer SCO OpenServer, previously SCO UNIX and SCO Open Desktop ( SCO ODT) is a closed source version of the Unix computer Operating system UnixWare is a Unix Operating system maintained by The SCO Group (SCO Tru64 UNIX is a 64-bit UNIX Operating system for the Alpha Microprocessor architecture currently owned by Hewlett-Packard Windows 95 is a consumer-oriented Graphical user interface -based Operating system. Windows 98 ( codenamed Memphis) is a graphical Operating system released on 25 June 1998 by Microsoft and the successor to Windows 95 Windows Millennium Edition, or Windows Me (IPA pronunciation, iː is a hybrid 16-bit / 32-bit graphical Operating system released on 14 September Windows NT is a family of Operating systems produced by Microsoft, the first version of which was released in July 1993 Windows 2000 (also referred to as Win2K) is a preemptive, interruptible graphical and business-oriented Operating system designed to work with Windows XP is a family of 32-bit and 64-bit Operating systems produced by Microsoft for use on Personal computers including home and A 32-bit application is Software that runs in a 32-bit flat Address space (a Flat memory model) Windows Vista (ˈvɪstə is a line of Operating systems developed by Microsoft for use on Personal computers including home and business desktops '64-bit' CPUs have existed in Supercomputers since the 1960s and in RISC -based workstations and servers since the early 1990s. A port of MySQL to OpenVMS is also available. Open Virtual Memory System ( OpenVMS) initially known just as Virtual Memory System ( VMS) is the name of a High-end Computer server [8]
Libraries for accessing MySQL databases are available in all major programming languages with language-specific APIs. In Computer science, a library is a collection of Subroutines used to develop Software. A programming language is an Artificial language that can be used to write programs which control the behavior of a machine particularly a Computer. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. In Computing, Open Database Connectivity ( ODBC) provides a standard Software API method for using Database management systems (DBMS MyODBC is an ODBC interface and allows Programming languages that support the ODBC interface to communicate with a MySQL database In Computing, Open Database Connectivity ( ODBC) provides a standard Software API method for using Database management systems (DBMS Active Server Pages ( ASP) is Microsoft 's first server-side script engine for dynamically-generated web pages This article is about the computer programming language For the nuclear reactions see Cold fusion. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++. ANSI C is the standard published by the American National Standards Institute (ANSI for the C programming language.
To administer MySQL databases one can use the included command-line tool (commands: mysql and mysqladmin). Also downloadable from the MySQL site are GUI administration tools: MySQL Administrator and MySQL Query Browser. Both of the GUI tools are now included in one package called tools/5. 0. html MySQL GUI Tools.
In addition to the above mentioned tools developed by MySQL AB, there are several other commercial and non-commercial tools available. A non-commercial enterprise is work that values other considerations above and beyond that of making a profit phpMyAdmin is a free software webbased administration interface implemented in PHP. phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the Internet. PHP is a computer Scripting language. Originally designed for producing Dynamic web pages it has evolved to include a Command line interface capability
As of August 2007, MySQL offers MySQL 5. August 2007 is the eighth month of that year It began on a Wednesday and 31 days later ended on a Friday. 0 in two different variants: the MySQL Community Server and Enterprise Server. MySQL Enterprise is a subscription-based service produced by MySQL AB and targeted toward the commercial market They have a common code base and include the following features:
The MySQL Enterprise Server is released once per month and the sources can be obtained either from MySQL's customer-only Enterprise site or from MySQL's BitKeeper repository, both under the GPL license. In Computing, Unicode is an Industry standard allowing Computers to consistently represent and manipulate text expressed in most of the world's UTF-8 (8- Bit UCS / Unicode Transformation Format) is a variable-length Character encoding for Unicode. In Computing, UTF-16 (16- Bit Unicode Transformation Format is a variable-length Character encoding for Unicode, capable of encoding See also Mapping of Unicode characters The Unicode characters can be categorized in many different ways Unicode code points can be logically divided into 17 In Computer science, ACID ( Atomicity Consistency Isolation Durability) is a set of properties that guarantee that Database transactions are Berkeley DB (BDB is a Computer software library that provides a high-performance embedded Database, with bindings in C, MySQL Cluster is a technology which provides shared-nothing clustering capabilities for the MySQL Database management system. BitKeeper is a Software tool for Distributed revision control ( Configuration management, SCM, etc The MySQL Community Server is published on an unspecified schedule under the GPL and contains all bug fixes that were shipped with the last MySQL Enterprise Server release. Binaries are no longer provided by MySQL for every release of the Community Server. [9][10]
The following features are implemented by MySQL but not by some other RDBMS software:
There are 3 types of MySQL Server Compilations for Enterprise and Community users:
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. [11]
Milestones in MySQL development include:
The MySQL 5. 1 roadmap outlines support for:
Support for parallelization is also part of the roadmap for future versions. A partition is a division of a logical Database or its constituting elements into distinct independent parts Parallel computing is a form of computation in which many instructions are carried out simultaneously operating on the principle that large problems can often [13]
Foreign key support for all storage engines is targeted for release in MySQL 6. In the context of Relational databases a foreign key is a referential constraint between two tables 1 (although it has been present since version 3. 23. 44 for InnoDB). InnoDB is a storage engine for MySQL, included as standard in all current Binaries distributed by MySQL AB.
The current MySQL 5. 1 development release is 5. 1. 25-rc.
A new storage engine is also in the works, called Falcon. Falcon is a new transactional Storage engine for the MySQL Relational database management system. A preview of Falcon is already available on MySQL's website.
Via MySQL Enterprise MySQL AB offers support itself, including a 24/7 service with 30-minute response time, the support team has direct access to the developers as necessary to handle problems. 24/7 is an Abbreviation which stands for "24 hours a day 7 days a week" usually referring to business opening hours or the availability of a service In addition it hosts forums and mailing lists, employees and other users are often available in several IRC channels providing assistance. A mailing list is a collection of names and addresses used by an individual or an organization to send material to multiple recipients
Buyers of MySQL Enterprise enjoy access to binaries and software that is certified for their particular operating system, and access to monthly binary updates with the latest bug fixes. Several levels of Enterprise membership are available, with varying response times and features ranging from how to and emergency support through server performance tuning and system architecture advice. Performance tuning is the improvement of System Performance. This is typically a computer application but the same methods can be applied to economic markets bureaucracies A system architecture or systems architecture is the conceptual design that defines the Structure and/or Behavior of a System The MySQL Network Monitoring and Advisory Service monitoring tool for database servers is available only to MySQL Enterprise customers. The term network monitoring describes the use of a system that constantly monitors a Computer network for slow or failing components and that notifies the Network administrator A database server is a Computer program that provides Database services to other computer programs or Computers as defined by the Client-server
MySQL Server is available as free software under the GNU General Public License (GPL), but MySQL Enterprise subscriptions are offered for business users and dual-licensing under traditional proprietary licensing arrangements is available for cases where the intended use is incompatible with the GPL. Free software or software libre is Software that can be used studied and modified without restriction and which can be copied and redistributed in modified or unmodified MySQL Enterprise is a subscription-based service produced by MySQL AB and targeted toward the commercial market Dual-licensing is the practice of distributing Software under two different sets of terms and conditions Proprietary software is Computer software on which the producer has set restrictions on use private modification copying, or republishing.
Both the MySQL server software itself and the client libraries are distributed under a dual-licensing format. Users may choose the GPL,[14] which MySQL has extended with a FLOSS License Exception. Alternative terms for free software have been a controversial issue among Free software users from the late 1990s onwards It allows Software licensed under other OSI-compliant Open Source licenses, which are not compatible to the GPL, to link against the MySQL client libraries. The Open Source Initiative is an organization dedicated to promoting Open-source software. An open source license is a copyright License for Computer software that makes the source code available under terms that allow for modification and redistribution [15]
Customers that do not wish to be bound to the terms of the GPL may choose to purchase a proprietary license. [16]
Like many open-source programs, the name "MySQL" is trademarked and may only be used with the trademark holder's permission. This is a list of free / open source packages whose names are covered by Trademarks A trademark or trade mark, represented by the symbols ™ and ®, or mark is a distinctive sign or indicator used by an individual
Some users have independently continued to develop earlier versions of the client libraries, which was distributed under the less-restrictive GNU Lesser General Public License (LGPL). The GNU Lesser General Public License (formerly the GNU Library General Public License) or LGPL is a Free software license published by the Free Software [17]
There has been some controversy regarding the distribution of GPL licensed MySQL library files with other open source applications. The biggest controversy arose with PHP, which has a license incompatible with the GPL. PHP is a computer Scripting language. Originally designed for producing Dynamic web pages it has evolved to include a Command line interface capability This was later resolved when MySQL created a license exception that explicitly allows the inclusion of the MySQL client library in open source projects that are licensed under a number of OSI-compliant Open Source licenses, including the PHP License. The PHP License is the Software license under which the PHP programming language is released [18]
In September 2005, MySQL AB and SCO forged a partnership for "joint certification, marketing, sales, training and business development work for a commercial version of the database for SCO's new OpenServer 6 version of Unix". The SCO Group Inc ( TSG, informally SCO;) is a software company formerly called Caldera Systems and Caldera International. Business development Specialist, comprises a number of techniques designed to create new customers and penetrate existing SCO raised controversy beginning in 2003 with a number of high-profile lawsuits related to the Linux Operating System. The SCO-Linux controversies are a series of legal and public disputes between the Software company SCO Group (SCO and various Linux vendors and users In law a lawsuit is a civil action brought before a Court in which the party commencing the action the Plaintiff, seeks a legal or equitable remedy Linux (commonly pronounced ˈlɪnəks An operating system (commonly abbreviated OS and O/S) is the software component of a Computer system that is responsible for the management and coordination Various MySQL employees expressed that the company was committed to serving its end users, regardless of their operating system choice, that the company would leave it to the courts to resolve the SCO licensing controversy, and that other common open source databases have also been ported to, and support, SCO OpenServer. SCO OpenServer, previously SCO UNIX and SCO Open Desktop ( SCO ODT) is a closed source version of the Unix computer Operating system
In October 2005, Oracle Corporation acquired Innobase OY, the Finnish company that developed the InnoDB storage engine that allows MySQL to provide such functionality as transactions and foreign keys. Oracle Corporation ( specializes in developing and marketing Enterprise software products — particularly Database management systems In 2007 Oracle ranked Finland, officially the Republic of Finland ( is a Nordic country situated in the Fennoscandian region of northern Europe. InnoDB is a storage engine for MySQL, included as standard in all current Binaries distributed by MySQL AB. In the context of Relational databases a foreign key is a referential constraint between two tables A press release by Oracle that was issued after the acquisition,[19] mentioned that the contracts that make the company's software available to MySQL AB come up for renewal (and presumably renegotiation) some time in 2006. A news release, media release, press release or press statement is a written or recorded Communication directed at members of the News MySQL AB (founded 1995 acquired by Sun Microsystems 2008 was dual headquartered in Uppsala, Sweden and Cupertino, California During the MySQL Users Conference in April 2006, MySQL issued a press release which confirmed that MySQL and Innobase OY agreed to a multi-year extension of their licensing agreement. [20]
In February 2006, Oracle Corporation acquired Sleepycat Software,[21] makers of the Berkeley DB, a database engine onto which another MySQL storage engine was built. Sleepycat Software Inc was the commercial entity behind the Berkeley DB, a widely used Free software developer database with over 200 million deployments worldwide Berkeley DB (BDB is a Computer software library that provides a high-performance embedded Database, with bindings in C,
MySQL's divergence from the SQL standard on the subject of treatment of NULL values and default values has been criticized. Its handling of dates in versions prior to 5. 0 allows storing a date with a day beyond the last day of a month with fewer than 31 days, and arithmetic operations are vulnerable to either integer overflow or floating point truncation. In Computer programming, an integer overflow occurs when an Arithmetic operation attempts to create a numeric value that is larger than can be represented within the In Computing, floating point describes a system for numerical representation in which a string of digits (or Bits represents a Real number. [22] Since version 5 of the server, the treatment of illegal values varies according to use of the "SQL Mode" set in the server, which is by default set to the unusually tolerant state that critics dislike. [23]
When the beta version of MySQL 5. A software release is the distribution whether public or private of an initial or new and upgraded version of a Computer software product 0 was released in March 2005, David Axmark, a co-founder of MySQL, said that "People have been criticizing MySQL since we started for not having stored procedures, triggers and views," and "We're fixing 10 years of criticism in one release. David Axmark is one of the founders of MySQL AB and a developer of the Free Software database server MySQL. "[24] MySQL 5. 0's 13 October build 5. Events 54 - Nero ascends to the Roman throne 409 - Vandals and Alans crossed the Pyrenees 0. 15 was released for production use on 24 October 2005, after more than two million downloads in the 5. Events 69 - Second Battle of Bedriacum, forces under Antonius Primus the commander of the Danube armies loyal to Vespasian, defeat Year 2005 ( MMV) was a Common year starting on Saturday (link displays full calendar of the Gregorian calendar. 0 beta cycle.