Outline of MySQL: Difference between revisions

Content deleted Content added
Monkbot (talk | contribs)
m Graphical user interfaces: Task 16: replaced (1×) / removed (0×) deprecated |dead-url= and |deadurl= with |url-status=;
Bender the Bot (talk | contribs)
 
(16 intermediate revisions by 14 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]].
* [[WebScaleSQL]] &ndash; software branch of MySQL 5.6 jointly developed by Facebook, Google, LinkedIn and Twitter to provide a centralized development structure for extending MySQL with new features specific to large-scale deployments, such as building large replicated databases running on server farms. The project's objective is to tightly follow new MySQL community releases, rather than merely be a software fork.
 
Line 111:
* [[Outline of free software]]
<!-- The following links need to be placed in the body of the outline above-->
* [[DaDaBIKInfobright]] &ndash;
* [[MySQL DataController]]
* [[Infobright]] &ndash;
* [[MySQLToad DataControllerData Modeler]] &ndash;
* [[Xeround]] &ndash;
* [[Toad Data Modeler]] &ndash;
* [[Xeround]] &ndash;
 
==References==
Line 123 ⟶ 122:
 
== External links ==
{{sisterlinkssister project links|MySQL}}
 
* [http://dev.mysql.com/doc/refman/5.6/en/ ''MySQL 5.6 Reference Manual'']
Line 130 ⟶ 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| ]]