2017 was an exceptional year at ScyllaDB. We were successful in all the areas that really matter—our product, our staff and, most importantly, our user community. And while there’s still much work to do, I’d like to take a moment to reflect on a few of our bigger accomplishments from the year.
What’s the deal with prepared statements? A query itself is just a string of text. For example: INSERT INTO tb (key,val) VALUES (“key”, “value”) In this simple example, we inserted two strings in a two-column table. Before that can happen, the CQL statement string (INSERT INTO…) needs to be sent to Scylla, parsed, and assuming no errors in the query, executed. It’s the parsing part that we are concerned with here. Parsing a CQL query is a compute-intensive operation that consumes resources just like anything else you would have a computer do. What if we could do the parsing part […]
If you were forced to choose just one thing that would prompt you to move your mission-critical functionality to a new database, what would it be? Better performance? Worries about future scaling on your existing platform? Easier time for your DevOps? What about awesome support from the company itself? At Scylla Summit 2017, mParticle’s Nayden Kolev explained how all of the above factors started the group one year ago on a fruitful collaboration with Scylla in production.
The Scylla team is pleased to announce the release of Scylla 2.0.2, a bugfix release of the Scylla 2.0 stable branch. Release 2.0.2, like all past and future 2.x.y releases, is backward compatible and supports rolling upgrades. If you are upgrading from 1.7.x, make sure to read the Scylla 2.0 release notes first. In particular, you can upgrade to Scylla 2.0 from Scylla 1.7.4 or later, and support for older driver versions has been discontinued (see release notes).
What is a User Defined Type? (UDT)? User Defined Types (UDTs) allow a definition of struct that includes multiple typed named fields (including other UDTs). Once a UDT is defined, it can be used as a column type in a table definition. In Scylla, you can define a Column as a frozen<UDT>.
Solving your performance problems with Intel Optane Organizations often face problems with their current database infrastructure regarding performance, data persistence, and cost. Some may use in-memory databases to help address performance concerns but they may run into data persistence issues. Sacrificing the integrity of your data is never a good tradeoff for performance. Also, more memory in a server will drive up costs. An ideal solution would provide the performance of an in-memory database without compromises on throughput, latency, and data persistence.
They may not have time machines or lightsabers, but they do have the Higgs-Boson and they’re looking for the most scalable framework with which to study it. At CERN, the problem of the day is scaling out their AliEn global file catalog and their plans may well involve Scylla.
This will be a series of blog posts that provide a story arc for Scylla Training. Backstory Mutants have emerged from the shadows and are wreaking havoc on the earth! Increased levels of mutant malicious behavior pose a threat to national security and the general public. Luckily, there are mutants who have teamed up with Government agencies to help protect people against the bad ones.
When an organization changes their database backend, it is not a simple task and there is usually an interesting story behind it. This was the case with Zenly, a mobile application that lets you know where your friends are in real time. They were using Elasticsearch as their main database to take advantage of its full-text search capabilities. However, Elasticsearch did not perform well for Zenly’s workload, which consists mostly of update operations, and they found it difficult to monitor and locate their data, so they began to look for a database replacement.
How do you quantify how effective your database system is in terms of throughput, latency and CPU usage? And what do you do when there is a risk to your SLA? These were the main questions explored in Lukasz Pachiarek and Szymon Szymanski of Allegro’s talk at Scylla Summit 2017.
Apache®, Apache Cassandra®, are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. No endorsement by The Apache Software Foundation is implied by the use of these marks.