Enterprise customers: Create self-hosted AWS database instance


In this Article we will learn how to setup a MySQL/MariaDB database in AWS RDS and How to connect that database to your stand-alone Artavolo Enterprise application. All of this is free tier eligible.

Prerequisites
Create a AWS Account.

Create a DB Instance on Amazon RDS

We will use Amazon RDS to create a MySQL/Maria DB Instance with db.t3.micro DB instance class, 20 GB of storage and this is free tier eligible.

The Amazon RDS Free Tier is available to you for 12 months.

  • 750 hrs per month of Amazon RDS in a Single-AZ db.t3.micro Instance.
  • 20 GB per month of General Purpose Storage (SSD).
  • 20 GB per month for automated backup storage and any user-initiated DB Snapshots.

Steps to create a DB Instance

1. Login with your AWS Account and go to console.

2. Search for RDS in Services and go to RDS .

3. In the top right corner of the Amazon RDS console, select the Region in which you want to create the DB instance. (optional)


4. Click on Create Database in Create Database Section on Dashboard.

5. Choose Standard Create to configure db Instance.



6. Choose MariaDB in Engine options and Free Tier in Templates.





7. Configure a DB instance name and credentials settings.



8. Disable Storage auto scaling in storage Section .



9. Change you Additional connectivity configurations . Public Accessible to yes to access the Database from local machine.



10 . Set Database Authentication to Password Authentication

11. Now Coming towards Additional Configuration

11.1 Enter a Initial Database name



11.2 Enable Automatic Backups and Backup retention period to 1 or 2 days and Disable Monitoring.



11.3 Enable All Log exports.



11.4 Enable auto minor version upgrade and Delete Protection also . This will not allow anyone to delete the Db instance Directly .



12. Click on create Database

13. Select instance security group, then edit Inbound rules and allow your IP to access it or make it publicly accessible.




Here, you are done with setting a MySQL/MariaDB database in Amazon RDS (Free Tier Eligible ).

Now you need to configure your Artavolo application to work with this database


1. Go to your Artavolo control panel and find page Settings.

2. On the bottom of the page you can find a Remote DataBase Storage section.

3. In DB HOST set your AWS DB endpoint. Go To databases on RDS. Click on your DB instance and you will find your DB Endpoints in Connectivity & security.

4. For DB NAME enter your database name (in the example we used mydb).

5. For DB PASS enter the password you have used in Step 7.

6. For DB USER enter 'admin'.

Congratulations! Your application is configured to work with a self-hosted database now.