Is Cassandra used in Medical industry?

Hi, We are working on a medical project, where CFR - Code of Federal Regulations Title 21 - FDA certification mandatory for the software we use to build the application. Could somebody confirm whether Cassandra is got the

Re: [EXTERNAL] Cassandra vs MySQL

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

Re: One time major deletion/purge vs periodic deletion

It's possible you'll run into compaction headaches. Likely actually. If you have time-bucketed purge/archives, I'd implement a time bucketing strategy using rotating tables dedicated to a time period so that when an entire table is ready for archiving you just snapshot its sstables and then

Re: [EXTERNAL] Cassandra vs MySQL

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

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

Re: [EXTERNAL] Cassandra vs MySQL

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

RE: [EXTERNAL] Cassandra vs MySQL

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

Re: Anomaly detection

Hello Salvatore, I used SPM Sematext that had this feature already 3 or 4 years ago I believe. SPM offers some out of the box dashboards for Cassandra. See https://sematext.com/spm/ More recently we built some templates for Cassandra in Data Dog that I believe should show the most important

Re: select fields and heap usage

Take a look at this interesting read: https://sysdig.com/blog/column-selection-effects-query-performance/ Ali Hubail Senior Software Developer Petrolink International Ltd. | Milwaukee, WI Office: +966 13 877 1068 | Cell: +1(414)3267981 Email: ali.hub...@petrolink.com | www.petrolink.com

select fields and heap usage

Hello, Talking about heap pressure, is there any difference between make a '*select **' and a '*select field *'? Is cassandra taking into the heap the whole partition to make the merge doesn't matters if we make a select of few rows ? Best greatings Jean Carlo "The best way to predict the