MySQL

From DreamFactory
Jump to: navigation, search

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.