...
When using MariaDB, the following initial database configuration is recommended. However, some of the options below may need to change over time as the work carried out by PhixFlow increases.
...
Installation
Database
Create a new database as follows:
Parameter
Setting
Name
Option | Setting |
VersionMariaDB 10.0.14 or | greaterSee Compatibility Guide and Upgrade Planning. |
| Max Server Memory | At least 2 GB |
The following configuration parameters must be set in my.cnf | |
datadir | A directory on a partition set up to store the MySQL data files. |
character_set_server | utf8 |
collation_server | utf8_bin |
Max Server Memory | At least 2 GB |
Logins
Create a new login as follows:
...
Parameter
...
Setting
...
Login Name
...
phixflow
...
Password
...
Please provide to the PhixFlow installation consultant
Ensure that the data dir being used has sufficient space for the initial period of PhixFlow operation. | |
| binlog_format | MIXED |
wait_timeout | 28800 (this is the default, but some installation processes set this to a much lower value) |
Database
The following are parameters of the database required by a PhixFlow installation. Note that all of these parameters are reflected in the example MariaDB database creation command in Configure the Database.
You will need a database, and a login with all privileges on that database. The database must be created with the following options:
| Option | Setting |
|---|---|
| character_set_server | utf8 |
| collation_server | utf8_bin |
Notes
Windows / Antivirus
MariaDB is not compatible with on-access anti-virus software so this must be disabled for the MariaDB data folder(s).