Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

If the version of MariaDB is 10.1.38, or newer, the recommended value for max_allowed_packet  is 512M

 


Note: in the case we will obtain the next 'The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.' error trying to upload an addon, we may update the default value of this mysql/mariadb parameter. This parameter is commonly allocated on the /etc/mysql/my.cnf file.

Code Block
[mysqld]
innodb_log_file_size=256M

...


If you are installing on a Ubuntu 18.04 server, default character set is set to utf8mb4. Using this character set can cause problems, as many index sizes will exceed maximum key size of 767 bytes. To prevent this problem, change following settings:

Code Block
[mysqld]
character-set-server  = Latin1
collation-server      = Latin1_general_ci

...


Alternatively, if UTF character set is required, write the following  settings:

Code Block
[mysqld]
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
innodb_large_prefix   = 1
innodb_file_format    = Barracuda
innodb_file_per_table = 1

...


Following this link  you will find the steps to setup a two nodes database cluster.

...

You must enable the SQL Server Browser Service at startup and the authentication method have to be set to “SQL Server and Windows Authentication mode”.To connect Soffid to the SQL server you will need a user with sysadmin role. In addition Soffid requires JDK installed on the server and SOFFID_JAVA_HOME environment variable should be set appropriately.

In addition, you must ensure that 'READ_COMMITTED_SNAPSHOT" parameter is enabled, you can do so with the following command:

...