Connecting to Amazon RDS

The following connection process describes how to connect to Chartio if you are hosting your MySQL database instance on Amazon RDS (Relational Database Service).

After you have elected to add a datasource to Chartio, you'll be taken to a page which prompts you for the database type you would like to connect. Since RDS does not support PostgreSQL, please select the MySQL option instead.

mysql or postgres selection

After selecting MySQL, you will be guided to the setup instructions page. Scroll down to the end of the page, until you find the option to "connect directly" (as pictured below).

This link will take us to the page that contains the connection form. Here, we are prompted to fill out 5 fields, one of which is pre-filled as a default. They are:

  1. The host name to which we'll be connecting. Here, you will want to enter the endpoint url for your database instance.

  2. The name of the database

  3. The database username

  4. The database password

  5. And finally, the port, which is set at 3306 by default

Below is an example of a completed form.

Before connecting to Chartio, the RDS security groups need to be modified in order to white label Chart.io's inbound IP.

To do this, simply enter the following IP as a CIDR into your security group: 173.203.96.249/32 (as seen below).

Once that's done, you should be all set to go. Just click "Test Connection and Save," and you'll be taken to your Chartio dashboard, which will begin auto-generating a starter set of visualizations.