Ruby on Rails Adding an Amazon RDS to your rails application Consider we are connecting MYSQL RDS with your rails application.
Example
Steps to create MYSQL database
- Login to amazon account and select RDS service
- Select
Launch DB Instancefrom the instance tab - By defaul MYSQL Community Edition will be selected, hence click the
selectbutton - Select the database purpose, say
productionand clicknext step - Provide the
mysql version, storage size, DB Instance Identifier, Master Username and Passwordand clicknext step - Enter
Database Nameand clickLaunch 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 PostgreSQLgem 'activerecord-oracle_enhanced-adapter'for Oraclegem '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
