Overall Satisfaction with IBM Compose
It is used primarily to store/retrieve sports feed data by our APIs so that we can make the data available to our users via the mobile apps. It allows us to query data in a way we cannot within MySQL (our primary data store) as we can store documents rather than having to normalise it.
- Web interface is pretty good for basic querying, which means other tooling is not required.
- Being able to rely on Infrastructure as a Service means we don't have to spend time looking after this system ourselves.
- Upgrading Mongo instances can be a little troublesome depending on the version upgrade being done. In the end we had to resort to doing this ourselves via command line scripts because the online interface was not capable.
- The web interface, particularly for querying, is a little slow.
- We haven't really shopped around much on this front, but it does seem to do the job at a reasonable price. There are certainly other solutions out there, but we've not taken a look in detail making ROI difficult to determine (ie. any hosted Mongo service would give us the same impact)
We use Amazon Aurora as our primary datastore and use IBM Compose Mongo as an alternative only when Aurora does not cover the use case well. Amazon DynamoDB looks good but doesn't have the same wealth of libraries and support which makes MongoDB easy to use and therefore was not really considered a viable alternative for us.