Supported MariaDB Versions Artifactory supports MariaDB versions 10.2.9-10.4 and version 10.5.9 (Refrain from using MariaDB 10.5.x versions other than version 10.5.9 due to this known issue). Supported JDBC Driver Versions Artifactory supports the MariaDB Java Connector versions 2.1.2 and above. Note that when using JDBC version 2.4.x and above, you need to add the following flag: useMysqlMetadata=true to the connection string. Artifactory provides a script that will execute the SQL commands you need to create your MariaDB database. The script can be found in You should review the script and modify it as needed to correspond to your specific environment. Once you have verified that the script is correct, you need to run it to create the database and proceed with configuring the database. Artifactory privileges If you are running MariaDB database on a Docker container please use the following: Selecting a Case-Sensitive Collation While MariaDB Database Server is not case-sensitive by default, it is important to select a case-sensitive collation because Artifactory is case-sensitive. For example, in the Artifactory privileges We recommend providing Artifactory with full privileges on the database. Download the MariaDB JDBC driver (available from the
MariaDB website) and copy the Permissions Make sure your driver has the same permissions as the rest of the files in the Adjust the database connection details in the Artifactory System YAML. Storing BLOBs inside MariaDB The suggested (and recommended) configuration stores all artifact information in MariaDB while the artifact binary data is stored on the file system (under To store BLOBs in MariaDB, you will need to configure the Filestore with the Full-DB and Full-DB-Direct Binary Providers and change The MariaDB Connector/J does not support the special
lightweight "/* ping */" query. JDBC Connection Pools perform regular validity checks on connections in the pool, which use an SQL validation query. Since some data files (builds, configurations etc.) are stored in MariaDB, it is extremely important to increase the maximum allowed packet size used by MariaDB to avoid errors related to large packets. To learn more, please refer to
Packet Too Large in the MariaDB. We recommend changing this parameter in the /etc/my.cnf Absolute Path If Restart required After modifying the maximum allowed packed size you need to restart MariaDB. You can also use the command line You can also change the Note, however, that upon a restart, the value of the When using Artifactory with MariaDB it is recommended to use the InnoDB engine with the following tuning parameters configured in the Note that both the XtraDB and InnoDB engines are compatible with the various InnoDB system variables. Restart required After tuning MariaDB to work with Artifactory, you need to restart MariaDB. Both MySql and MariaDB servers do support the “/* ping */” query, but the MariaDB Connector/J wraps the query as if it was a standard SQL query and transforms it into a “SET STATEMENT...” query, which is illegal in terms of syntax as far as the server is concerned. For this reason, Artifactory uses a generic “SELECT 1” as a validation query for pooled connections when MariaDB is used as a database type. The MySql Connector has no such limitation, and supports the “/* ping */” query.Creating the Artifactory MariaDB Database
$JFROG_HOME/artifactory/app/misc/db/createdb/createdb_mariadb.sql
and is displayed below.CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL on artdb.* TO 'artifactory'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL on artdb.* TO 'artifactory'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
createdb.sql
script above COLLATE is set to "utf8_bin"
.Configuring Artifactory to use MariaDB
mariadb-java-client-<version>.jar
file into $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
directory$JFROG_HOME/artifactory/var
directory. shared:
database:
type: mariadb
driver: org.mariadb.jdbc.Driver
url: jdbc:mariadb://<your db server url, for example: localhost:3306>/artdb?characterEncoding=UTF-8&elideSetAutoCommits=true&useSSL=false&useMysqlMetadata=true
username: artifactory
password: password
$JFROG_HOME/artifactory/var/data/artifactory/filestore
).
While it is not recommended, it is possible to store BLOBs inside MariaDB provided that the typical BLOB size is relatively small. Storing large BLOBs in MariaDB can cause memory issuesbecause MariaDB buffers BLOBs rather than streaming them (please refer to
MySQL Bug #15089) and may result in OutOfMemory
errors with large binaries depending on your JVM heap size. max_allowed_packet
to be higher than the maximum artifact size you intend to store in Artifactory.Known Issues
Lightweight Ping Query
Increasing MariaDB Default Packet Size
/etc/my.cnf
file as follows:# The MariaDB server
[MariaDBd]
.
# The maximum size of the binary payload the server can handle
max_allowed_packet=8M
.
/etc/my.cnf
does not already exist, you need to create it under the absolute path and not under $JFROG_HOME/artifactory/var
.
max_allowed_packet
variable on the MariaDB command line as in the following example:SET GLOBAL max_allowed_packet = 134217728;
max_allowed_packet
variable will be read from the /etc/my.cnf file and revert to the value in that file as described above.Tuning MariaDB for Artifactory
/etc/my.cnf
file:# The MariaDB server
[mysqld]
.
# By default innodb engine use one file for all databases and tables. We recommend changing this to one file per table.
# NOTE: This will take effect only if Artifactory tables are not created yet! Need to be set and MariaDB restarted before starting Artifactory for the first time.
innodb_file_per_table
# Theses are tuning parameters that can be set to control and increase the memory buffer sizes.
innodb_buffer_pool_size=1536M
tmp_table_size=512M
max_heap_table_size=512M
# Theses control the innodb log files size and can be changed only when MariaDB is down and MariaDB will not start if there are some innodb log files left in the datadir.
# So, changing theses means removing the old innodb log files before start.
innodb_log_file_size=256M
innodb_log_buffer_size=4M
.
createdb_mariadb.sql Script
For example
Modifying /etc/my.cnf
Tuning Parameters for MySQL