Re: [EXTERNAL] Cassandra vs MySQL

2018-03-20 Thread Carl Mueller
Yes, cassandra's big win is that once you get your data and applications adapted to the platform, you have a clear path to very very large scale and resiliency. Um, assuming you have the dollars. It scales out on commodity hardware, but isn't exactly efficient in the use of that hardware. I like to

Re: [EXTERNAL] Cassandra vs MySQL

2018-03-20 Thread Jeff Jirsa
I suspect you're approaching this problem from the wrong side. The decision of MySQL vs Cassandra isn't usually about performance, it's about the other features that may impact/enable that performance. - Will you have a data set that won't fit on any single MySQL Server? - Will you want to write

Re: [EXTERNAL] Cassandra vs MySQL

2018-03-20 Thread Joaquin Casares
Hello Oliver, The first thing that I check when seeing if a workload will work well within Cassandra is by looking at it's read patterns. Once the read patterns can be written down on paper, we need to figure out how the write patterns will populate the required tables. Since you know enough about

Re: [EXTERNAL] Cassandra vs MySQL

2018-03-20 Thread Oliver Ruebenacker
Hello, Thanks for all the responses. I do know some SQL and CQL, so I know the main differences. You can do joins in MySQL, but the bigger your data, the less likely you want to do that. If you are a team that wants to consider migrating from MySQL to Cassandra, you need some reason t

RE: [EXTERNAL] Cassandra vs MySQL

2018-03-20 Thread Durity, Sean R
I’m not sure there is a fair comparison. MySQL and Cassandra have different ways of solving related (but not necessarily the same) problems of storing and retrieving data. The data model between MySQL and Cassandra is likely to be very different. The key for Cassandra is that you need to model