MySQL Installation
From DreamFactory
(→Set up MySQL) |
Drewpearce (Talk | contribs) (→Set up MySQL) |
||
| Line 1: | Line 1: | ||
===Set up MySQL=== | ===Set up MySQL=== | ||
| − | + | MySQL and its clones make great system databases for DreamFactory. We frequently use MariaDB, as it is open source. For help installing MariaDB, see the [https://downloads.mariadb.org/mariadb/repositories/ | MariaDB Download System]. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
'''Regarding MySQL engines:''' | '''Regarding MySQL engines:''' | ||
| Line 20: | Line 13: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | ===Driver=== | |
| − | + | The MySQL PHP driver is available in your package manager, or downloadable from php pecl. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | For example if you are following the [[../../../APT/Ubuntu_16.04/Modules/MySQL| Ubuntu 16.04]] instructions, this package is named php7.1-mysql. | |
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 18:23, 28 February 2018
Set up MySQL
MySQL and its clones make great system databases for DreamFactory. We frequently use MariaDB, as it is open source. For help installing MariaDB, see the | MariaDB Download System.
Regarding MySQL engines: Older versions of MySQL default to using the MyISAM engine. This engine does not support foreign key relationships and is thus not compatible with DreamFactory. The InnoDB engine is recommended for DreamFactory. Here are some suggested settings related to InnoDB that you can put in your my.cnf file
default-storage-engine = InnoDB innodb-file-per-table = 1 innodb_stats_on_metadata = 0 character-set-server = utf8 collation-server = utf8_general_ci
Driver
The MySQL PHP driver is available in your package manager, or downloadable from php pecl.
For example if you are following the Ubuntu 16.04 instructions, this package is named php7.1-mysql.
