...
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
Option | Setting |
Version | |
| Max Server Memory | At least 2 GB |
The following configuration parameters must be set in my.cnf | |
datadirA | directory on a partition set up to store the MySQL data files.Ensure that the data dir being used has sufficient space for the initial period of PhixFlow operation. |
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 |
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
Database
Create a new database as follows:
Parameter
Setting
Name
Notes
Windows / Antivirus
MariaDB is not compatible with on-access anti-virus software so this must be disabled for the MariaDB data folder(s).