MySQL

Instructions for syncing data into Vitally via MySQL

Requirements

Make sure that your MySQL warehouse is accessible over the internet.
Create unique MySQL credentials, using password authentication for Vitally's access to the database and grant the user permission to the required tables.
Safe-list Vitally's IP addresses in any relevant security groups:
- For US-hosted Vitally customers: 52.2.105.119, 34.198.95.164, 54.225.45.200, 3.233.54.92, 44.197.82.135, 44.205.137.47, 3.231.135.245, 34.234.2.125, 18.117.45.34, 18.118.174.158, 3.128.104.4, 3.128.39.40, 3.137.39.224, 3.20.73.62
- For EU-hosted Vitally customers: 13.50.117.250, 13.48.176.93, 13.48.142.17, 13.53.227.107, 16.171.90.148, 16.170.120.57, 16.171.215.121, 16.171.156.82

We'll need these values to connect to your MySQL warehouse:

Host: The public hostname of your MySQL warehouse.
Port: The port number of your MySQL warehouse. By default, it is 3306.
Database: The name of the database that you want to connect to (e.g. production).
Username: A unique user that you've created for Vitally.
Password: That user's password.

Last updated 3 months ago