Ruby on Rails - consider we are connecting mysql rds with our rails application in ruby on rails - ruby on rails tutorial - rails guides - rails tutorial - ruby rails
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,
Install our added gems,
- 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