Setup with MySQL

Introduction

Out of the box, Senzing is configured to use an embedded SQLite database for the entity repository to accelerate getting started. This article describes the steps to configure Senzing to use PostgreSQL as the entity repository.

• MySQL Homepage
• MySQL Documentation
• Repository Downloads

Pre-requisites

• A user, password, IP, and database from your DBA that you use with select, delete, update, and truncate access.
  • Note: For the installation, either the DBA installs the Senzing schema or you need to have DDL writes too.
• A MySQL server setup considering this article
• libmysqlclient21 and mysql-client-core

  Add Senzing Schema to MySQL

  • mysql -u <user> -p -d <database> < senzing/resources/schema/g2core-schema-mysql-create.sql
  • You will be prompted for the password for the mysql user

  Configure the CONNECTION

  Depending on you set your G2Module configuration...

  • Change the SQL CONNECTION entry
    • CONNECTION=mysql://<user>:<password>@<server>:3306:<database>/
  • Or optionally with a non-default schema
    • CONNECTION=mysql://<user>:<password>@<server>:3306:<database>/?schema=<schema>

  Install the default Senzing configuration

  • Source setupEnv
    • cd <senzing_project_path>
    • source setupEnv
  • Inject the default configuration
    • python3 python/G2SetupConfig.py