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 MemSQL 5.1. This release adds Role-Based Access Control (RBAC) to the already powerful MemSQL 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 MemSQL 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, MemSQL 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 passwords
- Cluster Administrator – manages the MemSQL cluster
- Backup Operator – performs backups
- Application User – executes per-application DML statements
MemSQL 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 MemSQL reference documentation.
Try MemSQL Today
Download MemSQL 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.