Using MariaDB datasources with Unica Campaign
Unica Campaign supports MariaDB as System and user tables. The MariaDB database connection with
Unica Campaign is supported with unixODBC and MariaDB ODBC Connector. Users must install unixODBC and
MariaDB ODBC Connector on Unica Campaign Analytical server (listener) machine.
Note: For information on
supported versions, see the Recommended Software Environments and Minimum System Requirements
document.
MariaDB Server On Linux
On Linux, add the following lines to
/etc/my.cnf
[mysqld]
innodb_page_size=32768
character_set_server=utf8
sql_mode='NO_BACKSLASH_ESCAPES'
innodb_strict_mode=0
wait_timeout=2592000
Note: V12.1 FP2 onwards we need to add table_definition_cache=1024 MariaDB database level
parameter in configuration file.
MariaDB server on Windows
Configure my.ini
by adding the following lines to section mysqld
.
[mysqld]
innodb_page_size=32768
character_set_server=utf8
sql_mode='NO_BACKSLASH_ESCAPES'
innodb_strict_mode=0
wait_timeout=2592000
Note: V12.1 FP2 onwards we need to add table_definition_cache=1024 MariaDB database level
parameter in configuration file.