Scylla DB Adds HTAP
Written by Kay Ewbank   
Friday, 16 November 2018

A new release of Scylla DB has been released with support for Hybrid Transactional / Analytical Processing (HTAP) via concurrent OLTP and OLAP. The open source NoSQL database also now has feature parity with Apache Cassandra. 

The new release, Scylla Open Source 3.0, also has materialized views and support for secondary indexes. The developers of Scylla describe it as a drop-in replacement for Apache Cassandra with as much as 10 times better performance. It is written in C++ to maximize throughput, latency and administration, and the company says Scylla delivers scale-up performance of more than 1,000,000 IOPS per node, scales out to hundreds of nodes, and consistently achieves a 99 percent tail latency of less than 1 millisecond.

scylladb

The new features of Scylla start with the HTAP support from the addition of support for concurrent OLTP and OLAP. Organizations using Scylla can run real-time operational workloads with big-data analytical workloads within a single database cluster. This is tricky to achieve as Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) have very different data access characteristics. OLTP generally involves transactions that mix reads, writes, and updates, so needs to have low latency. OLAP, in contrast, usually involves broad scans across datasets. Scylla now has capabilities that isolate workloads, so should be able to run both types of use at once.

scylla2

The support for materialized views means Scylla supports creating and periodically maintaining a view where the results are calculated and stored for later use, and updated to remain current at points where the database engine has spare capacity.  While this is a relatively common feature in SQL databases, it is less frequently found in NoSQL databases. The Scylla developers say this enables automated server-side table denormalization. Another improvement in this release is support for secondary Indexes that can be scaled to any cluster size.

There's a one hour test-drive of Scylla that you can take to see how it would cope with your parameters, with performance graphs will show you the throughput, latency, disk capacity and load you can expect.

scylladb

 

 

More Information

ScyllaDB Open Source Edition

Related Articles

Cassandra 2.0 Available

Cassandra 1.0 with Increased Performance

Cassandra with CQL

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin.

Banner


Machine Learning At All Levels On Coursera
29/11/2018

Andrew Ng's inaugural presentation of an introductory course on machine learning will begin on Coursera early in 2019. Meanwhile the courses he teaches at intermediate to advanced level have just re-s [ ... ]



2018 Best Alexa Socialbot Wins $500,000
28/11/2018

Gunrock, a team of students from the University of California, Davis has been awarded the 2018 Alexa Prize for Best Socialbot, winning themselves $500,000. The $1 million for holding an engaging 20-mi [ ... ]


More News

Python

 



 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Friday, 16 November 2018 )