...
MariaDB is not compatible with on-access anti-virus software, so this must be disabled for the MariaDB data folder(s).
For full details for creating an exception see https://support.microsoft.com/en-us/windows/add-an-exclusion-to-windows-security-811816c0-4dfd-af4a-47e4-c301afe13b26#:~:text=Go%20to%20Start%20%3E%20Settings%20%3E%20Update,%2C%20file%20types%2C%20or%20process. However, for example, if you are on Windows, and using Windows Defender, do the following:
Start → Settings → Update & Security → Windows Security → Virus & threat protection → [Virus & threat protection Manage settings] → Exclusions [Add or remove exclusions] → Add an exclusion
Select Process and enter the exact path and name of the executable for the service e.g.
C:\Program Files\MariaDB 10.4\bin\mysqld.exe
Minimum requirements
The following are the minimum requirements for a MariaDB installation to support PhixFlow.
Installation
Option | Setting |
|---|---|
Version | |
The following configuration parameters must be set in | |
| Ensure that the data directory being used has sufficient space for the initial period of PhixFlow operation. This is in the |
|
This must be added to the |
|
This must be in the |
The following configuration parameters can optionally be set in my.cnf | |
|
If set in For details on why this setting is recommended, and the alternatives if you do not want to set in this |
Example
If you add all parameters above to my.cnf, including the optional parameters, then the [mysqld] section of your my.cnf file should look something like this:
...
Option | Setting |
|---|---|
|
|
|
|
...
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 be 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 the setting 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 running PhixFlow migration scripts. If you don't want to make this permanent change, see the following section.
Instructions for setting log_bin_trust_function_creators in the my.cnf file are given above: https://phixflow.atlassian.net/wiki/spaces/HELPTRUNKR/pages/8642920464/MariaDB+installation#Installation.
Session change to allow non-deterministic functions
If you do not update the log_bin_trust_function_creators setting in my.cnf, you must make sure that your session either has this setting updated, or that you run migration scripts with sufficient privileges. Full details for doing this are given here: Upgrading PhixFlow.
Example installation
The following configuration is suggested as a guide. It incorporates the minimum requirements for MariaDB databases above.
...
| Code Block | ||
|---|---|---|
| ||
innodb_default_row_format = dynamic innodb_file_per_table = 1 innodb_strict_mode = ONOFF |
| Note |
|---|
Check the |
Bounce MariaDB:
| Code Block | ||
|---|---|---|
| ||
sudo systemctl stop mysql.service sudo systemctl start mysql.service |
...