Setting mongodb, redis & postgresql on heroku step by step

Setting mongodb, redis & postgresql on heroku step by step

< setting mongodb on heroku >

1. create heroku app.
2. create mongodb account
 * make credit on this site :  https://addons.heroku.com/
   $ heroku addons:add mongohq:sandbox (free)

3. password change
https://partners.mongohq.com

4. check out the connection
install Tadpole DB : https://sites.google.com/site/tadpolefordb/
mongodb://<user>:<password>@paulo.mongohq.com:10037/app18663713
user: "heroku", pwd: *****

< setting redis on heroku >

1. create heroku app
2. create redis account
$ heroku addons:add rediscloud:20
3. install redis  (for redis client)
http://redis.io/download

4. check out heroku redis site
Endpoint  pub-redis-13710.us-east-1-4.1.ec2.garantiadata.com:13710
Redis Password *****

5. check out the connection
$ redis-cli -h pub-redis-13710.us-east-1-4.1.ec2.garantiadata.com -p 13710
$ auth ******
OK
$ set redis "Hello, Redis!"
OK
$ get redis
"Hello, Redis!"

< setting redis on postgresql >

1. create heroku app

2. create postgresql account
$ heroku addons:add heroku-postgresql:dev

3. check out the connection info.
https://postgres.heroku.com/databases

3. jdbc setting

database.driverClassName=org.postgresql.Driver
database.url=jdbc:postgresql://ec2-54-225-102-116.compute-1.amazonaws.com:5432/d752d1bhh9oj50?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
database.username=tjosdqffsibowa
database.password=****

* database.url : add "?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" in order to escape ssl error.

cf. https://devcenter.heroku.com/articles/getting-started-with-nodejs