MySQL Setup

This article is for general guidance. Always work with your DBA when setting up a production database. If you have any questions, contact Senzing Support . Support is 100% FREE!
When upgrading from Senzing v3 to Senzing v4, there are changes made to the entity repository database schema. See Upgrading the Senzing Repository Schema To V4

Prerequisites

  • A <username>, <password>, IP or <hostname>, and <database> from the DBA that has select, delete, update, and truncate access

  • A MySQL database tuned for Senzing

  • libmysqlclient21 and mysql-client-core packages installed

Add the Senzing schema

If applicable, the DBA should set up the database schema. If you have any questions, contact Senzing Support . Support is 100% FREE!
mysql -u <user> -p -d <database> <  <senzing_project_path>/resources/schema/szcore-schema-mysql-create.sql
<senzing_project_path> refers to the path specified with the /opt/senzing/er/bin/sz_create_project command when creating a project.

Configure the CONNECTION string

Edit the SENZING_ENGINE_CONFIGURATION_JSON environment variable or sz_engine_config.ini file :

Edit the new CONNECTION mysql://<username>:<password>@<hostname>:3306:<database>/?schema=schemaname entry where:

3306 is the default MySQL port number. Change this if the port value differs.
Parameter Description
<username> MySQL username
<password> Password for the above username
<hostname> IP address or hostname of the MySQL Server
3306 Port number of the MySQL Server
<database> Database name
/?schema=schemaname Remove unless using custom schema

Update database with the Senzing ER configuration

A Senzing instance is configured with a Senzing Entity Resolution configuration. On a fresh installation this configuration needs to be registered in the Senzing database.

See Updating Database with Senzing ER Configuration

If you have any questions, contact Senzing Support. Support is 100% FREE!