SingleStore is announcing the industry's first unified cloud database with the separation of storage and compute. SingleStore’s innovative architecture allows customers to run operational and analytical workloads simultaneously while flexibly scaling resources to power the next generation of data-intensive applications.
Separation of Storage and Compute
SingleStore has implemented the separation of Storage and Compute, allowing users to effortlessly scale compute to meet the needs of any workload, while managing storage needs completely independently. Many data warehouses have separated storage and compute, but unlike SingleStore’s Unified database, their designs have sacrificed performance and query latency in doing so. SingleStore is unique in that it can run both operational and analytical workloads because of the unique architecture delivering the separation of storage and compute. This allows SingleStore to store nearly limitless volumes of data without increasing query latency or giving up our industry leading performance.
By processing workloads directly at the point of compute rather than requiring round-trips to slow object storage, SingleStore avoids high latencies and network bandwidth issues typically associated with other databases. This gives SingleStore users peace of mind that they can achieve ultimate elasticity and scalability, while continuing to drive modern applications and complex analytics workloads which execute with the highest performance and lowest latency possible.
Suspend & Resume Workloads Effortlessly
SingleStore is the fastest unified database for data-intensive applications, and many of our customers run SingleStore 24x7 to serve their mission-critical workloads. Now, SingleStore has introduced the ability to easily Suspend compute resources when not in use, allowing temporary or part-time workloads to be run with maximum ease and efficiency. Delivered as part of our SingleStoreDB Cloud, clusters can be Suspended and Resumed nearly instantaneously, making all of your data available when you need it, and minimizing cost when workloads are inactive.
This capability is built on the unique architecture that makes the separation of storage and compute possible, and allows organizations with hundreds or thousands of deployments to easily and effortlessly manage all of their data infrastructure across the organization for maximum efficiency.
Flexible Billing Model
The incredible flexibility delivered by SingleStore and the Separation of Storage and Compute pushed us to update our billing model to be simpler and more flexible. Now singlestore offers customers two ways to use SingleStoreDB Cloud; on-demand or with monthly credit bundles to handle dynamic and growing compute workloads. With flexible compute credits and a low per GB rate for storage, organizations can minimize TCO when storing their organizations data in SingleStore.
Customers can start out on-demand, or receive discounts for yearly commits to monthly usage volumes. Continuous and dynamic workloads both benefit from this flexibility, and users don’t have to worry if their workloads burst or grow rapidly. Workloads can burst above monthly commits at on-demand rates, and unused credits are rolled over to the following month, ensuring users get maximum value from SingleStore.
Universal Storage: Achieving the SingleStore vision, One Database for all your workloads.
SingleStore Universal Storage is a single table type which supports transactional and analytical workloads. For decades, many people believed that you needed different databases and technology to run analytical and transactional workloads. SingleStore has proved that wrong with the introduction of the 7.5 release.
With this announcement of Universal Storage technology, SingleStore provides support for multi-column keys, and makes Universal Storage the default table type. Developers no longer have to make difficult tradeoffs when designing their schema. They simply type “CREATE TABLE” and focus on building their application.
The 7.5 release adds these key features to make this possible:
- Multi-column hash indexes and multi-column unique constraints
- Multi-column key support for INSERT ON DUP KEY UPDATE+IGNORE
Usability & Performance
Emojis: New support for UTF8 4 byte characters (utf8mb4) allows a wide range of data to be easily stored in the database. One of the key drivers for this feature was to allow Emojis to be stored easily as part of a text field. Emoji support is one of the most asked for features by our developer community. Full support for extended Asian character sets is now available with utf8mb4.
Temporary stored procedures: SingleStore now supports temporary stored procedures, which can be created by anyone who can connect to the database and run a query. They disappear when the session terminates. This is useful for scripting procedural logic mixed with SQL.
JSON functions: We've introduced JSON_BUILD_OBJECT, JSON_PRETTY to let you easily build JSON objects and pretty print JSON values, respectively.
Interpreter speed up: SingleStore is unique in its ability to do "just in time" compilation of SQL queries. By default, it starts by interpreting a query, compiles the query operators to machine code in the background, then switches to the compiled code on the fly. Now, in 7.5, the interpreter has been enhanced to be much faster.
Preview SingleStoreDB Cloud Today
The SingleStoreDB Cloud is the industry’s first unified relational and multi-model database to deliver the separation of storage and compute for data-intensive applications without sacrificing performance.