MemSQL - Datapipe


MemSQL is the leader in real-time and historical Big Data analytics based on a distributed in-memory database. MemSQL cluster deployment is easy with pre-defined clusters and 1-Button Deploy™ technology on Datapipe.

Sample Production Cluster Topology

Use Cases

MemSQL's versatility and ease of use make it an ideal tool for capturing previously untapped value in your data. MemSQL will speed up your existing applications and analytics, and enable new real-time use cases that were previously impossible. With its tiered storage architecture and ability to query both relational and JSON data, MemSQL is a flexible solution that addresses your data processing and growing storage requirements. Data is most valuable at the time it is created, and MemSQL allows businesses to access, analyze, and act on data in real time.

  • Real-time operational monitoring – Machine data is often generated with such volume and velocity that it overwhelms legacy databases, making operational analytics slow or impossible. Build dashboards on top of MemSQL for synthesized views into both real-time and historical operational data. In contrast, MemSQL can run analytical queries while loading streaming data, enabling dashboards to display truly real-time operational metrics. In addition, MemSQL's JSON support and SQL interface make it a versatile and easy to use development platform.
  • Real-time ad bidding – Real-time ad bidding requires analyzing customer profiles and resolving competing bids simultaneously. The database must return results in milliseconds even under aggressive read and write workloads.
  • Real-time risk analysis – Financial institutions must analyze and store large volumes of data as it is created. MemSQL's in-memory row store is uniquely suited to ingest transactional data, while simultaneously running time-sensitive analyses. As the data ages, transfer it to MemSQL's highly compressed column store for deep analysis. MemSQL offers the speed and enterprise-grade durability necessary to give accurate and complete insight into an organization's trading operations.