Outline of MySQL: Difference between revisions

Revision as of 16:40, 10 September 2021

Latest revision as of 02:32, 11 August 2025

(13 intermediate revisions by 11 users not shown)

Line 2:

<!--... Attention: THIS IS AN OUTLINE

part of the set of 740830+ outlines listed at

[[PortalWikipedia:Contents/Outlines]].

Wikipedia outlines are

Line 10:

content navigation systems

See [[Wikipedia: Outlines]] and

[[Wikipedia:WikiProject Outlines]] for more details.

Further improvements

to this outline are on the way

Line 28:

** [[Solution stack]] component &ndash; one of the pieces of a solution stack, which is a set of software subsystems or components needed to create a complete platform such that no additional software is needed to support applications. Applications are said to "run on" or "run on top of" the resulting platform. Some definitions of a platform overlap with what is known as system software.

*** [[List of Apache–MySQL–PHP packages|AMP-stack]] component &ndash; MySQL is the "M" component of Apache-MySQL-Perl/PHP/Python solution stacks (which, by the way, are available across all computer platforms). AMP software bundles are used to run dynamic Web sites or servers.

*It supports php, perl, c, c++, java etc.

** Component of [[LAMP (software bundle)|LAMP]] &ndash; Linux version of AMP

** Component of [[WAMP]] &ndash; Windows version of AMP

Line 56:

* [[Navicat]]{{snd}} a series of proprietary graphical database management applications, developed for Windows, Macintosh and Linux

* [[OpenOffice.org]]{{snd}} freely available [[OpenOffice.org Base]] can manage MySQL databases if the entire suite is installed

* [[phpMyAdmin]]{{snd}} a free Web-based front-end, widely installed<ref>{{cite web |title=Download Statistics: phpMyAdmin|url=httphttps://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/stats/timeline}}</ref> by [[web hosting service]]s since it is developed in PHP and included in the LAMP stack, and [[MAMP]], [[XAMPP]] and [[WAMP (software bundle)|WAMP]] software bundle installers

* [[SQLBuddy]]{{snd}} a free Web-based front end, developed in PHP

* [[SQLyog]]{{snd}} proprietary, but there is also a free 'community' edition available

Line 70:

** CassandraSE –

** CONNECT (storage engine) –

** [[Falcon (storage engine)|Falcon]] – was<ref>http://www.eweek.com/c/a/Database/Oracle-Discusses-MySQL-Database-Plans-854185/ {{Dead link|date=February 2022}}</ref> a [[database transaction|transactional]] [[storage engine]] being developed for the [[MySQL]] [[relational database management system]]. Development was stopped after Oracle purchased MySQL.<ref>{{Cite web|url=http://www.databasejournal.com/features/mysql/article.php/3876206/Oracle-Commits-to-MySQL-with-InnoDB.htm|title=Oracle Commits to MySQL with InnoDB|date=13 April 2010}}</ref> It was based on the [[Netfrastructure]] database engine. Falcon was designed to take advantage of Sun's [[zfs]] file system.

** FederatedX –

** [[InfiniDB]] – scalable, software-only columnar database management system<ref>{{Cite web|url=http://www.cmswire.com/cms/enterprise-cms/infinidb-20-supports-big-data-analytics-009089.php|title = InfiniDB 2.0 Supports Big Data, Analytics}}</ref> for analytic applications.<ref>{{Cite web|url=http://www.enterpriseirregulars.com/28857/calpont%E2%80%99s-infinidb-%E2%80%93-another-adbms-insurgent-arises/|title = Calpont's InfiniDB – Another ADBMS Insurgent Arises|date = 8 November 2010}}</ref> However, on 1 October 2014 InfiniDB ceased operations and filed for bankruptcy protection in US Bankruptcy Court in the Eastern District of Texas. Existing customers may be able to receive support from other companies, notably MariaDB.

** [[InnoDB]] – storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity).

** mroonga –

Line 103:

== Forks of MySQL ==

* [[Drizzle (database server)|Drizzle]] &ndash; free software/open source relational database management system (DBMS) that was forked from the now-defunct 6.0 development branch of the MySQL DBMS.<ref>http{{Cite web|url=https://www.zdnet.com/articlehome-and-office/networking/mysql-fork-drizzle-gets-general-release/|title=MySQL fork Drizzle gets general release|website=[[ZDNet]]}}</ref>

* [[MariaDB]] is a community-developed fork of MySQL intended to remain free under the GNU GPL, being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.<ref>{{cite web|url=http://www.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/ |title=Dead database walking: MySQL's creator on why the future belongs to MariaDB - MariaDB, open source, mysql, Oracle |publisher=Computerworld |date= |accessdate=2013-09-11}}</ref>

* [[Percona Server]] &ndash; created by [[Percona]], aims to retain close compatibility to the official MySQL releases, while focusing on performance and increased visibility into server operations.<ref>[http://www.percona.com/software/percona-server/faq Percona Server Frequently Asked Questions] {{Webarchive|url=https://web.archive.org/web/20150415051416/http://www.percona.com/software/percona-server/faq |date=2015-04-15 }}, How is it related to other MySQL forks?</ref> Also included in Percona Server is [[XtraDB]], Percona's fork of the [[InnoDB|InnoDB Storage Engine]].

Line 111:

* [[Outline of free software]]

<!-- The following links need to be placed in the body of the outline above-->

* [[Infobright]] &ndash;

* [[MySQL DataController]] &ndash;

* [[Toad Data Modeler]] &ndash;

* [[Xeround]] &ndash;

==References==

Line 122:

== External links ==

{{sisterlinkssister project links|MySQL}}

* [http://dev.mysql.com/doc/refman/5.6/en/ ''MySQL 5.6 Reference Manual'']

Line 129:

* [http://www.oracle.com/us/products/mysql/index.html MySQL site at Oracle.com]

* [http://intruders.tv/en-tech/mysql-co-founder-david-axmark-on-sun-s-billion-dollar-acquisition/ Interview with David Axmark, MySQL co-founder] Video

* {{dmoz|/Computers/Software/Databases/MySQL/|MySQL}}

{{Outline footer}}

[[Category:Outlines of computing and engineering|MySQL]]

[[Category:Wikipedia outlinesOutlines|MySQL]]

[[Category:MySQL| ]]