Has anyone deployed mosql on heroku / heroku postgres?

[tensiondriven]

This is not exactly an issue, and Boy, it would be nice to know if this is possible before attempting to implement.

[nelhage]

I haven't done so, and I don't know of anyone who has, offhand, but I'd be somewhat surprised if it doesn't work. If you run into any issues, I'd be happy to hear about them.

[tensiondriven]

Sounds good - this issue is in our current sprint, so look forward to an update one way or the other in the next week or so. Thanks for the prompt reply!

[charlietran]

I've used MoSQL with Heroku Postgres, the actual MoSQL process was running on an EC2 instance. Worked great!

[levity]

We've just deployed the actual MoSQL process on a Heroku dyno. Too early to tell how robust it is, but so far it's been painless.

[nikilster]

@charlietran What were the deciding factors in running the MoSQL process on ec2 vs heroku?

@charlietran @levity What's the latency like? Real time is pretty important for my visualizations.

[nikilster]

@levity What type of dyno did you use in heroku / how exactly did you set that up? Thanks - I'm new to Heroku :)

[levity]

Just a plain old dyno. I wrote a rake task that starts mosql in a subprocess, and then added a line to the Procfile, then started it up with heroku ps:scale.

The rake task looks like this. Procfile and ps:scale usage are well-documented on Heroku.

[nikilster]

Fantastic thanks!

[ryanatwork]

We (Upworthy) run mosql on Heroku.

Basically just add a Procfile with this line: worker: bundle exec mosql --sql $DATABASE_URL --mongo $MONGOHQ_URL?slaveOk=true

[tensiondriven]

:+1:

[brettallred]

@levity - have you tried (do you know how to) run multiple mosql processes in a single worker dyno?