Category: Datawarehousing

Feed: MemSQL Blog. Author: Floyd Smith. With the arrival of the cloud, organizations face new opportunities – and new challenges. Chief among them is how to take the greatest advantage of public and private cloud resources without being locked into a specific cloud or being barred from access to existing infrastructure. Container solutions such as Docker offer part of the solution, making it much easier to develop, deploy, and manage software. In our webinar, product manager Micah Bahti describes how to take advantage of the next step: Using Kubernetes, and the MemSQL Kubernetes Operator, to manage containers across public clouds ... Read More

Feed: Actian. Author: Sampa Choudhuri. Increasingly, companies are embracing the use of SaaS and other cloud services to give their employees the feature-rich capabilities they require at an affordable cost. IT leaders are finding it much more efficient to buy IT services already built than to build and operate them internally.Buying SaaS solutions and other technology capabilities from 3rd parties does not eliminate the need and importance of your IT organization and its staff. On the contrary, it makes the role of IT more important than ever. SaaS applications may come and go, but the holistic integrity of your company’s ... Read More

Feed: MemSQL Blog. Author: Mike Boyarski. MemSQL has spent the last six years on a single mission: developing the fastest, most capable database on the market for a new generation of workloads. Today’s businesses are beginning to win or lose on their ability to use data to create competitive advantage, and technology teams at these companies need data infrastructure that can meet an increasingly broad set of requirements, perform well at scale, and fit easily with existing processes and tools. MemSQL 6.8 is the latest release of the database that meets this challenge. Whether accelerating and simplifying the use of ... Read More

Feed: MemSQL Blog. Author: Jacky Liang. Many companies, including our customers, have invested heavily in Hadoop infrastructure. In a recent blog post, we explored the topic of hype when it came to enterprises deploying Hadoop across their organizations, and ultimately where Hadoop falls short for certain use cases. Using MemSQL, many of our customers have been able to augment Hadoop using our HDFS pipelines feature, allowing them to quickly ingest from the Hadoop Distributed File System (HDFS) and perform analysis of their data in real time. With MemSQL 6.8, we are happy to announce our support for Kerberos and wire ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. In this blog post, I’ll focus on new query processing capabilities in MemSQL 6.8. The marquee query feature is just-in-time (JIT) compilation, which speeds up query runtimes on the first run of a query – now turned on by default. We have also improved performance of certain right and left outer joins and related operations, and Rollup and Cube. In addition, we add convenience features, including sub-select without an alias, and extended Oracle compatibility for date and time handling functions. Finally, new array functions for splitting strings and converting JSON data are added. Other ... Read More

Feed: MemSQL Blog. Author: Jacky Liang. In this blog post, part one of a two-part series, we look at the state of Hadoop from a macro perspective. In the second part of this series, we will look at how Hadoop and MemSQL can work together to solve many of the problems described here. 2008 was a big year for Apache Hadoop. It appeared organizations had finally found the panacea for working with exploding quantities of data with the rise of mobile and desktop web. Yahoo launched the world’s largest Apache Hadoop production application. They also won the “terabyte sort” benchmark, ... Read More

Feed: MemSQL Blog. Author: Carl Sverre. Kubernetes has taken the world by storm, transforming how applications are developed, deployed, and maintained. For a time, managing stateful services with Kubernetes was difficult, but that has changed dramatically with recent innovations in the community. Building on that work, MemSQL is pleased to announce the availability of our MemSQL Kubernetes Operator, and our certification by Red Hat to run on the popular OpenShift container management platform. Kubernetes has quickly become one of the top three most-loved platforms by developers. Now, with the MemSQL Kubernetes Operator, technology professionals have an easy way to deploy ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A MemSQL customer previously ran their business on two databases: the Amazon Web Services Relational Database Service (AWS RDS) for transactions and Druid.io for analytics, with a total bill which reached over $93,000 a month. They moved both functions to MemSQL, and their cost savings have been dramatic – about two-thirds of the total cost. The customer’s new monthly cost is about $31,000, for a savings of $62,000 a month, or 66%. In addition, the customer gains increased performance, greater concurrency, and easier database management. Future projects can also claim these benefits, giving the ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. Intel’s new Optane DC persistent memory adds a new performance option for MemSQL users. After careful analysis, we’ve identified one area in which MemSQL customers and others can solve a potentially urgent problem using Optane today, and we describe that opportunity in this blog post. We also point out other areas where MemSQL customers and others should keep an eye on Optane-related developments for the future. If you need broader information than what’s offered here, there are many sources for more comprehensive information about Optane and what it can do for you, beginning with ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. The proliferation of streaming analytics and instant decisions to power dynamic applications, as well as the rise of predictive analytics, machine learning, and operationalized artificial intelligence, have introduced a requirement for a new type of database workload: operational analytics. The two worlds of transactions and analytics, set apart from each other, are a relic of a time before data became an organization’s most valuable asset. Operational analytics is a new set of database requirements and system demands that are integral to achieving competitive advantage for the modern enterprise. This new approach was called for ... Read More