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 user, password, IP or hostname, and database from your 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, your 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.sqll
<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 your SENZING_ENGINE_CONFIGURATION_JSON environment variable or sz_engine_config.ini file :

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

3306 is the default MSSQL port number, you need to change this is your port value differs.
  • 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!