Raijin has announced the release of version 1.3 of its powerful, schemaless SQL-like database engine. This version implements user authentication and permissions and focuses on enhancing performance and robustness.
New user authentication and permissions
This release introduces certificate and password-based user authentication and granular user permissions. You can grant permissions at the database or table level with support for the following privileges:
-
ALL PRIVILEGE(superuser) -
CREATE -
SELECT -
INSERT -
DROP -
ALTER -
MAINTENANCE -
METADATA
See User management in the Raijin documentation for more information.
Optimized querying partitioned tables
The team investigated and addressed several bottlenecks when querying data across different table partitions, especially when ordering and aggregating data. The optimizations significantly improve query speed and CPU usage for these types of queries.
Improved memory management
Special attention was given to improving Raijin Database memory management in this release. The team addressed several issues related to excessive memory consumption and out-of-memory errors when processing complex queries or exporting data. Raijin Database will now also detect and respect CGroups memory limits.
Fixed queries that use ORDER BY with LIMIT
Several improvements were implemented for queries using the ORDER BY clause with LIMIT to address errors and potential segmentation faults.
The optimized algorithm is more robust, consumes less memory, and improves overall query speed.
Collect logs with NXLog
As a database engine, Raijin is geared towards semi-structured data, making it a perfect solution for log storage. Log data is notoriously unstructured, making it hard to store in rigid table structures like traditional SQL systems.
Raijin complements NXLog’s powerful log collection and centralization solutions. With NXLog Enterprise Edition’s Raijin integration, you can seamlessly and easily send logs from NXLog Enterprise Edition to a Raijin database instance. The two fit hand in glove, providing the methods of capturing, processing, and storing log data for a complete log management solution.
Check out the Raijin release notes for a full breakdown of the features and improvements.
