MySQL: Difference between revisions
No edit summary |
No edit summary |
||
| (9 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
MySQL is one of the supported databases that underpins a Moodle installation. | MySQL is one of the supported databases that underpins a Moodle installation. | ||
MySQL describes itself | MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model." | ||
MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which sometimes prove difficult to support. | |||
== See also == | |||
* [http://www.mysql.com/ The MySQL homepage] | |||
* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum] | |||
* [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL''] | |||
[[Category:Administrator]] | |||
[[Category:Developer]] | |||
[[Category:SQL databases]] | |||
[[ja:MySQL]] | |||
[[de:MySQL]] | |||
Latest revision as of 06:43, 11 August 2011
MySQL is one of the supported databases that underpins a Moodle installation.
MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."
MySQL comes with an array of storage engines. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the default storage engine of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which sometimes prove difficult to support.
