SecondDataSource2-2023-08-10 14-04-45_1.mp4

This tutorial outlines the steps for connecting a MySQL database to a Graphweaver instance with an existing Postgres database connection. In addition, we will connect entities across data sources. Users in the Postgres database will have Todos in the MySQL database. We can accomplish this in three steps:

  1. Create a MySQL Database
  2. Update our connections in Graphweaver
  3. Create new data and schema entities representing the MySQL data

Prerequisites for adding a second datasource

In this guide we are assuming you already have a Graphweaver instance running and connected to a Postgres data source. If you don’t have this already set up, you can follow our Connect To Postgres tutorial. This tutorials starts from the end of that one.

We also want to ensure you have MySQL, Node.js version 18 or greater, pnpm version 8 or greater, and the mysql shell client installed installed on your local machine before continuing.

Step 1: Installing and Configuring MySQL

The first step in to make sure that we have the configuration settings correct in MySQL. For this tutorial, we are going to assume that you have MySQL running locally on port 3306.

If you have it running on another port then remember to change this in the Graphweaver configuration below.

Next, you are going to need a user in MySQL that we will use when connecting from Graphweaver. For this tutorial, we are going to assume that you have a user root and an empty password.

Here are the settings that we will need:

Next, let’s setup a database to use as an example.

Step 2: Creating the MySQL Database