What users are saying about
Top Rated
74 Ratings
7 Ratings
Top Rated
74 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
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.9 out of 101

Add comparison

Likelihood to Recommend

Amazon RDS

Amazon Relational Database Service is best for situations where you need to use a MariaDB or MySQL Database, but do not want to spend time setting up and securing the server/software. Amazon Relational Database Service manages all of this for you, so it is very easy to get up and running and have an enterprise-ready environment ready for use.
No photo available

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

  • Getting the data in and out of our databases, especially with the close integration RDS has with S3 buckets.
  • Less overall management of the database servers. Our DBAs are now do more DBA work than server admin work, which moves them higher on the value chain.
  • Performance and Scalability.
No photo available
  • 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

  • Extend the retention time for backups
  • Provide an option to freeze a db version
Eric Humphrey 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

Running our database on RDS has been a good option as we originally thought most of our database would be running on EC2 instances and they we needed root access to the machine. We found out that wasn't the case and just needed to change our mindset.
No photo available
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

  • Positive - Move to Redshift from Oracle could save us up to 50% annually on database licensing
  • Positive - Move to Aurora is helping us save on on premise support we pay for mySQL
  • Negative - still, hard to find a true cost of ownership until several months of use under you're belt
No photo available
  • 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