Requirements
Your MySQL warehouse must allow inbound traffic from our Authorized Static IP Addresses. You can maintain a 'Deny All' firewall policy and only grant access to our specific IPs to ensure the connection remains private and secure
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 Authorized 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
Step 1 - Connect
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.