...
Logical Name | Setting |
phixflow | Type: Rows Data Filegroup: PRIMARY Initial Size: 2000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
phixflow_data_01 | Type: Rows Data Filegroup: ANALYSIS_DATA Initial Size: 100,000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
phixflow_log | Type: Log Initial Size: 1000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
| Anchor | ||||
|---|---|---|---|---|
|
MariaDB is a dialect of MySQL.
...
Option | Setting |
Version | |
| Max Server Memory | At least 2 GB |
The following configuration parameters must be set in my.cnf | |
datadir | Ensure that the data dir being used has sufficient space for the initial period of PhixFlow operation. This is in the [mysqld] section of the my.cnf file. |
| binlog_formatMIXED | mixed This must be added to the [mysqld] section of the my.cnf file. |
wait_timeout | 28800 (this is the default, but some installation processes set this to a much lower value) This must be in the [mysqld] section of the my.cnf file. |
| The following configuration parameters can optionally be set in my.cnf | |
| log_bin_trust_function_creators | 1 This must be added to the [mysqld] section of the my.cnf file. For details on why this setting is recommended - and the alternatives if you do not want to set in this my.cnf, see Running non-deterministic functions |
Example
If you add all parameters above to the my.cnf, including the optional parameters, then the end of the [mysqld] section of you my.cnf file should look something like this:
| Code Block |
|---|
[mysqld]
...
datadir = /var/lib/mysql
...
wait_timeout = 28800
...
binlog_format = mixed
log_bin_trust_function_creators = 1 |
Database
The following are parameters of the database required by a PhixFlow installation. Note that all
| Note |
|---|
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 |
| Anchor | ||||
|---|---|---|---|---|
|
PhixFlow's migration scripts sometimes require the use of non-deterministic functions. To run, these require either a setting (log_bin_trust_function_creators) to be updated, or to run with sufficient privileges.
Permanent setting change to allow non-deterministic functions
You can permanently allow non-deterministic functions to run in migration scripts by updating log_bin_trust_function_creators in the my.cnf file. This is convenient, because you don't have to remember to make any changes to your session when migrating. However, if you don't want to make this permanent change, see the following section.
Setting log_bin_trust_function_creators in the my.cnf file is an optional parameter recommended in MariaDB installation.
Session change to allow non-deterministic functions
You can either do this in a session, or to make the setting update permanent (that is, it will persist after a database restart) add it to the my.cnf file.
Notes
Windows / Antivirus
MariaDB is not compatible with on-access anti-virus software so this must be disabled for the MariaDB data folder(s).