I’m hoping someone might have experience using a non-trivial sized database with Compose. I’m just going to layout the details in bullet form because it can get confusing. I’ve bolded the most important point if you don’t want to read everything.
- have an app on heroku that uses mongohq [small] db. DB is about 1GB.
- built new tools in meteor, needs to use said mongohq db
- mongohq db does not support oplog so using it is not an option
- create new Compose account, setup a credit card and get activated with their one free month promotion
- export db from heroku mongohq to new compose account using mongodump/mongorestor
- mongorestore fails because the user collection can’t be overwritten
- I delete user collection that I dumped and restore works
- queries from command line work, queries from robomongo work and queries from within Compose tool works
- queries from Meteor do NOT work. I confirm with Compose support that my env variables are correct, that the oplog param is indeed correct
- confirm that my user account does indeed have oplog support
- wipe out the db and do a db import straight from my heroku Compose/mongohq account directly to the new Compose account (using compose ui tool)
- new import works great, everything works as expected EXCEPT Meteor.
- create a new collection in Compose account, manually insert records from the imported collection that does not work with meteor
- update meteor app to point to new collection and it works!
I’m out of ideas on how to make this work and Compose support has been absolutely worthless. In fact, I may leave them just for their lack of support as this seems to be an issue on their end. With that said, I’m really hoping this is something amazingly stupid from my end so I can get things moving again.
Does anyone know if there is a DB size limit for using compose during the trial? Some parts of their app reports my DB at 600mb which suggests something is awry. My guess is that oplog access is simply not working, but that detail does not get reported back to me.
Sorry for the log winded text, I wanted to demonstrate that I’ve tried everything I can think of.