MariaDB is not compatible with on-access anti-virus software, so this must be disabled for the MariaDB data folder(s).

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.

Option	Setting
Version	See System Requirements and Compatibility.
The following configuration parameters must be set in `my.cnf`
`datadir`	Ensure that the data directory being used has sufficient space for the initial period of PhixFlow operation. This is in the `[mysqld]` section of the `my.cnf` file.
`binlog_format`	`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 in the `[mysqld]` section of the `my.cnf` file. This setting is needed because PhixFlow's migration scripts sometimes require the use of non-deterministic functions

...

Code Block

language	bash

innodb_default_row_format = dynamic
innodb_file_per_table = 1
innodb_strict_mode = ONOFF

Note
Check the `innodb_buffer_pool_size` parameter is set to a suitable size depending on the specification of the server. See MariaDB planning

Bounce MariaDB:

Code Block

language	bash

sudo systemctl stop mysql.service
sudo systemctl start mysql.service

...

Versions Compared