Author: MemSQL Support

Feed: SingleStore Blog. Author: . Kubernetes was originally developed to manage containers running stateless workloads, such as computation-intensive processing tasks and web servers. It was then extended to allow you to manage stateful workloads, such as data tables and e-commerce sessions. However, doing so is not easy. One of the people who has figured out how to do this well is our own Rob Richardson, technical evangelist at SingleStore. In a recent DZone webinar, this three-part webinar series, Rob shows you how to build stateful workloads in Kubernetes. (From the link, you can easily download the slides and stream the ... Read More

Feed: SingleStore Blog. Author: . Analyzing query plans is an important part of database optimization. At SingleSore, we continuously improve our Visual Explain UI to make it easier to use for developers looking to optimize their query performance. Tito Griné interned at SingleStore in the Summer of 2021 and did some refactoring of our Visual Explain feature.What is Visual ExplainVisual Explain is a tool that displays graphically, and in a friendly way, the output of EXPLAIN and PROFILE commands. The result helps database engineers understand queries, discover bottlenecks, and analyze database schemas. They can then use the result insights to ... Read More

Feed: SingleStore Blog. Author: . Driven by new requirements and new types of workloads, many organizations have invested in specialized database technologies in recent years. New systems had to support big transactional and analytical workloads. They had been using general-purpose database technology for years, but discovered it was no longer good enough. New data requirements demanded specialized database technology. General-purpose database technology was suitable for developing almost any type of workload. With this technology, data warehouses, websites, transactional databases, and so on, could be developed. They were good at everything, but they did not excel in certain workloads. It was time ... Read More

Feed: SingleStore Blog. Author: . Distributed SQL databases have significant advantages over traditional approaches such as sharding middleware and NoSQL. Read on to learn everything you need to know to get started with Distributed SQL Databases.The Need for Distributed SQLDevelopers are building new applications in the cloud at insanely fast rates, iterating through development cycles and scaling on-demand as required. Monolithic applications are turning into agile microservices, and while the focus is primarily on the application layer, there remains a heavy reliance on the data layer to maintain a reliable customer experience. Distributed SQL databases provide consistency of developer experience and ... Read More

Feed: SingleStore Blog. Author: . Point-in-time recovery (PITR) is one of the hottest features in SingleStore 7.5, offering new, mission-critical capabilities for enterprise customers. Domenic Ravita takes a deep dive into PITR with SingleStore’s VP of Product Development, Rick Negrin, to find out how this new feature benefits database administrators, executives and developers. A few weeks ago I blogged about the highlights of SingleStore 7.5, recapping our recent webinar, “What’s New in SingleStore Summer Release?” One of its most hotly anticipated capabilities is point-in-time recovery (PITR) which, as it sounds like, allows you to recover a complete database to any point in ... Read More

Feed: SingleStore Blog. Author: . Are you looking for the fastest possible way to get a new SingleStore Cluster up and running while testing out sample datasets to experiment with and use? Well, today’s your lucky day, because in this post we are going to: Set up a new SingleStore cluster.Import over 20 million rows of sample data from an S3 Bucket.Run some sample queries on the imported dataset in SingleStore.Okay, first of all, if you’re new here, what exactly is SingleStore?SingleStore is a distributed, scale-out, general-purpose SQL database designed to have the versatility to run both analytical and operational ... Read More

Feed: SingleStore Blog. Author: . The Workload Monitoring UI allows SingleStore users to analyze their clusters' workloads. They can do this by viewing all of the activities that ran during a specific period of time, as well as each query’s resource usages (CPU, network, disk I/O, etc.) and other properties. In this blog post, we explain how we implemented the graphical interface for this feature.What is Workload Monitoring?Workload Monitoring is a visual UI currently implemented in SingleStore Studio on top of the Workload Profiling SingleStore database feature. The goal of Workload Monitoring is to allow the user to analyze a ... Read More

Feed: SingleStore Blog. Author: . Oliver Schabenberger, Chief Innovation Officer at SingleStore sat down with David Yakobovitch, publisher of the HumAin Podcast and Head of Education and Training at Singlestore to discuss the role data science plays in making breakthrough innovation possible. Listen to the full episode, or read the transcript below.David YakobovitchWelcome to our newest season of HumAIn podcast in 2021. HumAIn is your first look at the startups and industry titans that are leading and disrupting ML and AI, data science, developer tools, and technical education. I am your host David Yakobovitch, and this is HumAIn. If you ... Read More

Feed: SingleStore Blog. Author: . Over the past year, the pandemic has drastically altered the educational landscape. 55 million K-12 students in the United States suddenly found themselves in online or hybrid learning environments. Educators needed new ways of managing their classrooms, keeping students engaged, and tracking their performance. Some school districts took an ad hoc approach to the software needed to support digital learning. Educators had to learn and log in to multiple applications, adding complexity and inefficiency to an already harrowing time. These solutions also often fell under general-purpose categories and were not always well-suited for the education market. GoGuardian ... Read More

Feed: SingleStore Blog. Author: . 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.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 ... Read More