September 2020 Summaries

Infosys, a global leader in next-generation digital services and consulting, has partnered with SingleStore to help clients across various verticals implement SingleStore's fast, scalable relational database. The partnership aims to provide solutions that blur the boundaries between painkillers (fixing existing problems) and vitamins (enabling new opportunities). Infosys brings its expertise in identifying opportunities and implementing solutions, while SingleStore provides raw power for such solutions. Together, they offer a powerful combination of speed, scalability, SQL compatibility, and other features, making them well-suited for use cases such as real-time business intelligence, offloading OLTP databases, performing operational analytics, building real-time apps, and performing real-time analytics. Recent implementations of SingleStore in Infosys-led projects include moving internal data warehousing workloads from Vertica to SingleStore, powering real-time business intelligence solutions, and offloading transactional databases to SingleStore, resulting in cost savings and better customer experience.

The Database of Now delivers operational insights by providing current business state information to help businesses identify crucial moments and capitalize on them. It achieves this by simplifying data infrastructure for diverse workloads across various access styles, patterns, and types, gaining advantages in speed, scale, and simplicity for data professionals, application stakeholders, and end users. This approach is critical in time-critical "Now scenarios" where real revenue is lost or gained in a split second, affecting customer experience, law enforcement, and public health outcomes.

Red Hat Marketplace has announced that SingleStore, a cloud-native distributed SQL database, is now available for purchase through their platform. This move aims to provide enterprise customers with a one-stop shop to discover, try, purchase, deploy, and manage certified container-based software across various environments. The SingleStore database is designed to handle both OLTP and OLAP workloads in a single system, making it suitable for operational analytics that require fast data ingestion, low-latency queries, and elastic scaling with familiar relational SQL. Red Hat Marketplace delivers a hybrid multicloud trifecta, including a robust ecosystem of partners, an industry-leading Kubernetes container platform, and award-winning commercial support, all on a highly scalable backend powered by IBM. The partnership aims to simplify software purchase and adoption for customers through a curated private marketplace experience.

You can now easily increase the number of partitions in your SingleStore database, which is critical for scalability. This is achieved through a clever strategy that adds partition splitting to the work of a backup operation. The process involves taking a split backup, dropping the original database, and restoring the split backup. The restored split database will have new partitions with data from half of the original partition. To use this feature, you can run a command to take a split backup, drop the database, and then restore it. You should also pause your workload before taking the backup, add leaves if necessary, and consider unpauseing your workload after restore. Additionally, rebalancing partitions may be recommended, especially if you backed up to the local filesystem. The background columnstore merger will eventually compact the columnstore blobs, reducing disk space usage.