Author
Doug Doan
Doug is Director of Infrastructure Quality Engineering at SingleStore
Engineering
SingleStoreDB Self-Managed 5.1 Enhances Security for Real-Time Enterprises
Enterprises seek real-time data and analytics solutions to stay current in competitive, fast-evolving markets. Companies dealing in private information, such as healthcare organizations, financial institutions, and the public sector have historically been limited in their pursuit of real-time results, given stringent security requirements. Today, we announce the availability of SingleStoreDB Self-Managed 5.1. This release adds Role-Based Access Control (RBAC) to the already powerful SingleStoreDB Self-Managed 5, unlocking the gateway to real-time for companies with comprehensive security requirements.
Industry Standard Security
Protecting data from malicious users is a top priority for SingleStore customers. Granting access to specific people is a key mechanism for data protection. But managing users one at a time is difficult to when a large number of people use the system. Role-Based Access Control (RBAC) is an industry best practice used by many organizations for simplifying data access management.
With this release, SingleStore Enterprise Edition enables organizations to leverage the power of roles. To enable this feature, two new objects were added to the security model: roles and groups. Roles are collections of permissions and groups are collections of users. Roles are then applied to groups and users are put into groups. Customers can create their own roles such as:
Security Officer – manages users and passwordsCluster Administrator – manages the SingleStore clusterBackup Operator – performs backupsApplication User – executes per-application DML statements
SingleStore also provides management functions that determine the set of permissions for a given user.
The RBAC feature was extensively tested with a rigorous set of functional and performance tests, including inside a FIPS 140-2 environment. With our performance tests, we validated that a cluster can have up 30,000 roles and 30,000 groups without any significant degradation in query performance.
Read more about RBAC in SingleStore reference documentation.
Try SingleStore Today
Download SingleStore today and harness your real-time data. Build streaming data pipelines in minutes, taking your data ingest and analytics to unprecedented levels of scale and sophistication while keeping your data secure.
Read Post
Engineering
Building an Infinitely Scalable Testing System
Quality needs to be architected like any other feature in enterprise software. At SingleStore, we build test systems so we can ship new releases as often as possible. In the software world, continuous testing allows you to make tiny changes along the way and keep innovating quickly. Such continuous testing is an essential task—and on top of that, we compete with large companies and their armies of manual testers. Instead of hiring hordes of testers, we decided to build infinitely scalable test software.
This test system is called Psyduck, and it is extremely powerful. We currently run over 100,000 tests a day on Psyduck, almost double the number of tests from the last release of SingleStore. In order to achieve this, we had to architect Psyduck to scale as we grew.
In this blog post, we will share how we utilize Psyduck to maximize product quality, as well as build an efficient developer workflow.
Any engineering team, regardless of size, needs an infinitely scalable testing system of its own.
Make Testing Easy
The first step in building your test system is to ensure your entire team is on board. You can make testing mandatory, but the best way to develop extraordinary testing, is to make the process easy. This also helps foster an engineering culture where developers are passionate about testing. The SingleStore developer workflow for writing a new feature, including testing it, is engineered to be deliberately easy. See the image below.
Read Post
