Configuring a MySQL or MariaDB database for the IBM UrbanCode Deploy blueprint design server
To use a MySQL or MariaDB database with the blueprint design server, before
you install the blueprint design server, install the database and provide the Java™ Database Connectivity (JDBC) JAR file for the
blueprint design server installation process.MySQL and MariaDB are similar
databases. Which one you use depends on your operating system and version.
For example, the command to install MariaDB on a system that runs Red
Hat Enterprise Linux™ version 7 resembles the
following example:
yum install -y mariadb mariadb-server
To set the
database to run automatically and start the MariaDB database on a Linux system that uses systemctl
, run the
following
command:systemctl enable mariadb; systemctl start mariadb
Note: The database
must be encoded in UTF-8.
Follow these steps to set the database encoding:
- On the system that hosts the database, open MySQL or MariaDB configuration file. The location of the file depends on the operating system. On Linux, the file is named my.cnf, and many distributions put the file in the folder /etc or /etc/mysql. On Windows, the file is named my.ini.
- In the
[mysqld]
section of the configuration file, add the following lines:character-set-server=utf8 character-set-filesystem=utf8
- Restart the database. For example, to restart MariaDB on Linux, use this
command:
systemctl restart mariadb