AWS RDS (MySQL)

Overview

Amazon Relational Database Service (Amazon RDS) is a collection of managed services that makes it simple to set up, operate, and scale databases in the cloud. RDS offers several features and is one of the most popular managed database providers

AWS RDS for MySQL is a managed mysql database service which can be used to set up, operate, and scale a mysql database in the cloud with just a few clicks

Get Started with AWS RDS for MySQL

1. Sign up for an account with AWS. AWS offers a free tier to get you started and you can upgrade to paid services when needed.

2. Create a RDS for MySQL instance in your account. Here are some AWS tutorials to help you get started

   • Tutorial 1 - Creating a MySQL Instance

   • Tutorial 2 - Getting started with a MySQL instance

   • Important Notes -

     • Remember to choose "MySQL" as the engine type and not "Aurora (MySQL Compatible)" to get started quickly

     • You can choose "Free tier" as the template for your instance if you plan to use this for evaluation purposes with Neurelo

     • You don't need this DB to be connected to an EC2 instance

     • Use Password authentication for the database authentication method

     • Remember the username and password used when creating this instance. You will need these to connect your DB to Neurelo

     • You can specify the database name under Additional Configuration -> Database options

     

To enable Neurelo to connect to your AWS RDS instance, please make sure that the Neurelo IP addresses are enabled in your security groups to connect, or make the instance publicly accessible (not recommended -- use with caution only for testing purposes)

Collect MySQL connection details from the AWS Console

1. To connect your newly created instance to Neurelo, you will need the following information

   • Host / Endpoint for the DB instance

   • Port

   • Username

   • Password

   • Database name

2. Login to the AWS console to fetch the host/endpoint and the port. You will need to remember the username, password and database name used when creating the instance.

Add the AWS RDS for MySQL instance as a Data Source in a Neurelo Project

For each new project in Neurelo, you can utilize the Quick Start feature, a guided wizard for step-by-step onboarding, including adding a new Data Source like AWS RDS for MySQL. Additionally, you can create new Data Sources anytime within your project from the left navigation panel.

Connecting AWS RDS for MySQL to Neurelo with the Database Connection details

1. Login to your Neurelo Dashboard

2. Choose the project where you want to add a new data source or create a new project for this purpose.

3. For new projects, follow the Quick Start Guide and click on "Connect Data Source" button

   • For existing projects, navigate to "Data Sources" from the left navigation bar in the project and click on the "New" button

4. Navigate to the "Connection Details" option on the new data source dialog box and enter the necessary information collected earlier from the AWS console. After entering the connection details, click on "Test Connection" to verify that Neurelo can successfully connect to MySQL in AWS RDS. Once the test is successful, click Submit to save the configuration in Neurelo.