MySQL & Modern Workloads

ScaleDB extends MySQL for high-velocity high-volume data, enabling near real-time analytics across massive streams of data. NoSQL and Hadoop are excellent choices for unstructured data, or data variety challenges. However, if you are managing structured time-series data, and it is generated at high-velocity and high-volume, MySQL with ScaleDB is the tool for you. Unlike NoSQL, ScaleDB is a feature rich ACID compliant RDBMS solution including SQL, Joins, Ad-Hoc Queries and full support of the MySQL ecosystem. With special optimizations for time-series data, ScaleDB even outperforms NoSQL alternatives so, you can continue to use the MySQL you know and trust.
Screenshot_1

The ScaleDB Ecosystem

MariaDB is the database tier and ScaleDB operates underneath as a clustered storage engine. This means you use all of the familiar tools to program, manage, and optimize your MySQL applications. In other words, all the connectors are available /J, /PHP, /ODBC, etc. and if you want to run a BI tool against the data, you can pick between Tableau, Looker, JReport, Pentaho and many more.

If you need to combine your streaming time-series data with OLTP data, you can put the OLTP data into a table using MySQL with InnoDB. Complex queries that join between your OLTP data and your streaming (ScaleDB) data are then easily supported. Not only does ScaleDB scale-out with high-volume, high-velocity time-series data, it is MySQL.

DualTableBetter