Getting started with Ruby on Rails Routing ActiveRecord Views ActiveRecord Migrations Rails Best Practices Naming Conventions ActionCable ActiveModel User Authentication in Rails ActiveRecord Associations ActiveRecord Validations ActiveRecord Query Interface ActionMailer Rails generate commands Configuration I18n - Internationalization Using GoogleMaps with Rails File Uploads Caching ActionController Configuration Safe Constantize Rails 5 Authorization with CanCan Mongoid Gems Change default timezone Asset Pipeline Upgrading Rails ActiveRecord Locking Debugging Configure Angular with Rails Rails logger Prawn PDF Rails API Deploying a Rails app on Heroku ActiveSupport Form Helpers ActiveRecord Transactions RSpec and Ruby on Rails Decorator pattern Elasticsearch React with Rails using react-rails gem Rails Cookbook - Advanced rails recipes/learnings and coding techniques Multipurpose ActiveRecord columns Class Organization Shallow Routing Model states: AASM Rails 5 API Authetication Testing Rails Applications Active Jobs Rails frameworks over the years Add Admin Panel Nested form in Ruby on Rails Factory Girl Import whole CSV files from specific folder Tools for Ruby on Rails code optimization and cleanup ActiveJob Active Model Serializers Rails Engine - Modular Rails Single Table Inheritance ActiveRecord Transactions Turbolinks Friendly ID Securely storing authentication keys Authenticate Api using Devise Integrating React.js with Rails Using Hyperloop Change a default Rails application enviornment Reserved Words Rails -Engines Adding an Amazon RDS to your rails application Payment feature in rails Rails on docker

Adding an Amazon RDS to your rails application

Consider we are connecting MYSQL RDS with your rails application.

Steps to create MYSQL database

Login to amazon account and select RDS service
Select Launch DB Instance from the instance tab
By defaul MYSQL Community Edition will be selected, hence click the select button
Select the database purpose, say production and click next step
Provide the mysql version, storage size, DB Instance Identifier, Master Username and Password and click next step
Enter Database Name and click Launch DB Instance
Please wait until all the instance gets created. Once the instance gets created you will find an Endpoint, copy this entry point (which is referred as hostname)

Installing connectors

Add the MySQL database adapter to your project's gemfile,

gem 'mysql2'

Install your added gems,

bundle install

Some other database adapters are,

gem 'pg' for PostgreSQL
gem 'activerecord-oracle_enhanced-adapter' for Oracle
gem 'sql_server' for SQL Server

Configure your project's database.yml file Open your config/database.yml file

production:
  adapter: mysql2
  encoding: utf8
  database: <%= RDS_DB_NAME %>  # Which you have entered you creating database
  username: <%= RDS_USERNAME %> # db master username
  password: <%= RDS_PASSWORD %> # db master password
  host: <%= RDS_HOSTNAME %>     # db instance entrypoint
  port: <%= RDS_PORT %>         # db post. For MYSQL 3306

Contributors

Topic Id: 10922

Example Ids: 32685

This site is not affiliated with any of the contributors.