What users are saying about

Amazon RDS

Top Rated
68 Ratings

MemSQL

7 Ratings

Amazon RDS

Top Rated
68 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

MemSQL

7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Add comparison

Likelihood to Recommend

Amazon RDS

Reach for amazon RDS if you're looking to offload your database to an dedicated server. This is really important for just about any database-backed system that relies on multiple server instances. If you can afford it, it's also a good solution for simply running a database instead of co-locating one on your application server because it takes so much of the guesswork out of management.
Justin Schroeder profile photo

MemSQL

MemSQL is especially useful to serve as a back-end storage for spark streaming, and also small update problems. The streamliner technology is very helpful to process daily streaming data and consequent data analysis. Same SQL syntax is also very handy for people to learn and use.
Sachin Aggarwal profile photo

Pros

  • It's quite easy to set up and provision new RDS instances.
  • Setting up multi-zone failover tolerant databases is literally just a couple mouse clicks.
  • Databases are automatically backed up and have minor version upgrades applied.
  • Set and forget.
Justin Schroeder profile photo
  • Faster query speed than traditional SQL database.
  • It con server in the pipeline to deal with streaming data with Kafka, spark streaming and MemSQL
  • It is very scalable.
Sachin Aggarwal profile photo

Cons

  • Currently RDS does not offer a No-SQL DB management through RDS. They have their DynamoDB offering for No-SQL, but I wish RDS offers popular No-SQL DB's like MongoDB in their offerings.
  • RDS does not provide access to the Virtual Machine. It provides access to the database instance but not to the VM that Database resides in. This is kind of a nice to have as it would allow for fine grained performance tuning of the DB.
  • Unifying RDS security by combining instance security model with AWS IAM model. Currently to manage an RDS instance you have to have two security models in place, one, to secure access to RDS through IAM and the other to secure access to the Database through the Database's own security.
Anudeep Palanki profile photo
  • Provide faster python API for invoking MemSQL
  • MemSQL connection between spark failed when more than around 48 partitions data processing
  • Better tuning of MemSQL performance on Scale-up server
Sachin Aggarwal profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
MemSQL5.0
Based on 1 answer
I still want to see the performance about using latest version of spark and memsql. About renewal, if there is a new and better version of spark-memsql connector, then maybe.
Tianwen Chu profile photo

Alternatives Considered

There really isn't a comparable service. Azure was surprisingly complicated to set up and crashed at odd points during a POC without much help. We looked at Rackspace to check it out, but as most of our infrastructure is in AWS, any benefit to Rackspace's offerings were nullified by keeping it all in one place.
Michael E. Gruen profile photo
I have tried using CSV as a back-end storage, yet I/O is very heavy, direct transit from spark to MemSQL in memory really beats.
Sachin Aggarwal profile photo

Return on Investment

  • Easy to get started: low time cost.
  • Scaling cost with usage — better dollar cost management
Michael E. Gruen profile photo
  • It offers me solution to solve spark storage problem
  • It adds more complexity of my application since multiple tech softwares are involved.
  • More types of bugs will be encountered when doing streamliner, including hardware connection.
Sachin Aggarwal profile photo

Pricing Details

Amazon RDS

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MemSQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details