MemSQL Pipelines

MemSQL Pipelines: Real-Time Data Ingestion with Exactly-Once Semantics

Today we launched MemSQL 5.5 featuring MemSQL Pipelines, a new way to achieve maximum performance for real-time data ingestion at scale. This implementation enables exactly-once semantics when streaming from message brokers such as Apache Kafka. An end-to-end real-time analytics data platform requires real-time analytical queries and real-time ingestion. However, it is rare to find a data platform that satisfies both of these requirements. With the launch of MemSQL Pipelines as a native feature...


MemSQL at OOW16

MemSQL and Oracle: Better Together

Oracle OpenWorld 2016 kicks off on September 18th in San Francisco with ten tracks, including a Data Center track highlighting innovation in databases including MemSQL and Oracle. We built MemSQL to be a flexible ecosystem technology, as exemplified by several features. First, we offer users flexible deployments – whether it’s hybrid cloud, on-premises, VMs, or containers. Second, our connector tools are open source, such as MemSQL Spark Connector and Streamliner, which lets you...


predictive analytics for supply chain management

MemEx: Predictive Analytics for Global Supply Chain Management

The Internet of Things (IoT) produces staggering amounts of data daily. Real-time analysis of this data helps businesses address the demands of consumers in today’s always-on economy. Supply chain management exemplifies IoT impact on manufacturing industries. With a multitude of moving parts like vehicles, shipping containers, and packages functioning as sources of data, companies need more advanced methods for ingesting and analyzing IoT data. Most companies use descriptive analytics, but...


Path to Predictive Analytics Book

The Path to Predictive Analytics and Machine Learning - Free O’REILLY Book

Organizations once waited hours, days, or even weeks to get a handle on their data. In an earlier era, that sufficed. But with today’s endless stream of zeros and ones, data must be usable right away. It’s the crux of decision making for enterprises competing in the modern era. Recognizing cross-industry interest in massive data ingest and analytics, we teamed up with O’Reilly Media on a new book: The Path to Predictive Analytics and Machine Learning. In this book, we share the latest step...


kafka real-time analytics

Real-Time Analytics with Kafka and MemSQL

Connected devices, IoT, and on-demand user expectations push enterprises to deliver instant answers at scale. Applications that anticipate customer needs and fulfill expectations for fast, personalized services win the attention of consumers. Perceptive companies have taken note of these trends and are turning to memory-optimized technologies like Apache Kafka and MemSQL to power real-time analytics. High Speed Ingest Building real-time systems begins with capturing data at its source and using...


RBAC Database Security

Why Role-Based Access Control Is Essential to Database Security

As repositories of highly sensitive, confidential, and valuable business data, databases are the crown jewels of every organization. Successful businesses not only supply accurate and timely data, they must protect it as well. Security provides a critical competitive edge for any high functioning database. So database providers must prioritize protecting data in order to gain loyal customers who can trust the systems set in place to properly guard valuable information. In our latest enterprise...


Geospatial Benchmark

MemSQL Geospatial Operations Perform 2x - 24x Faster Than Alternatives

The mobile revolution, epitomized by the rise of GPS-enabled smartphones, is transforming our lives – the way we travel, connect with like-minded people, track our goods and shipments, manage traffic congestion, get threat alerts, and hunt for Pokemon. Many estimates place the number of smartphone subscribers at 2 billion, a number expected to grow to 6.1 billion by 2020. Each of these devices serves as a GPS-data emitting mobile sensor, providing geospatial data that can be used to track...


Denver CIO

The Changing Face of the Modern CIO

In 1981 the role of Chief Information Officer (CIO) first breaks onto the scene. Today, thirty five years since genesis, the responsibilities of the CIO have radically changed. The original CIO served as senior executive in an enterprise and was responsible for the information technology and computer systems that supported enterprise goals. However, as today’s business needs rapidly change, so too does the role of a modern CIO. Today, CIOs must adapt or they will get left behind with legacy...


operational data warehouse

The Emergence of Operational Data Warehouses

Last month, we announced that MemSQL received the highest score in the Gartner Critical Capabilities Report for the “Operational Data Warehouse Use Case”. While the findings Gartner shared are gratifying, this deserves a bit of a deeper dive. For starters, let’s examine how Gartner defines an Operational Data Warehouse: “This use case manages structured data that is loaded continuously in support of embedded analytics in applications, real-time data warehousing, and operational data...


BPU Linux Performance

What is BPF and why is it taking over Linux Performance Analysis?

Performance analysis often gets bottlenecked by lack of visibility. At MemSQL, we architected our database to easily observe its inner workings. Observability allows our engineers to easily identify components that need to be faster. Faster components mean our database’s performance skyrockets. These tools also enable support engineers to react quickly and precisely to customer needs. In the spirit of using the best available tools to which we have access, the performance team is currently...