The release of distributed SQL database NuoDB 4.0 adds a Kubernetes Operator and supports indexing improvements. NuoDB released the latest version of the database that also supports Azure and Google Cloud Platform certification.
The NuoDB Kubernetes Operator simplifies and automates database deployments in Red Hat's OpenShift cloud platform, and is available in the OpenShift 4 Integrated OperatorHub Marketplace. The NuoDB Operator can be used to configure and deploy the NuoDB database natively inside Red Hat OpenShift. Users also have the option to deploy the database with a sample SQL application that generates SQL activity on the database, allowing them to see NuoDB in action.
There is also the NuoDB Insights, a graphical dashboard that provides insight into the performance and overall health of the database. This feature will support other Kubernetes distributions in the future, to help with the deployments of distributed, stateful applications in Kubernetes.
The Operator leverages NuoDB Admin, a new management tier that includes a REST API designed to improve database lifecycle management and ensure deployment of NuoDB for cloud and container environments.
In regard to integration with cloud platforms, NuoDB 4.0 now supports Amazon Web Services (AWS), Azure and Google Cloud Platform (GCP), providing customers with a choice of public clouds to deploy NuoDB. The database can be deployed on-premises or in private clouds as well. In addition to the new REST API, NuoDB Admin includes:
- Database restart by automatically managing the restart order
- Granular and client connection load balancing with the use of process labels
- Improved diagnostics and domain state metrics
The indexing improvements include added support for online index creation and expression-based indexes. Online index creation enables customers to create indexes without impacting application availability. Expression-based indexes help to create indexes based on general expression and functions, improving performance for queries using expressions or functions. These indexes can speed up queries in which filtering happens, based on expressions rather than columns.
The security support includes LDAP based user authentication and network encryption based on TLS 1.2 specification. Checkout this tutorial to learn more about the certificate based encryption.
To learn more about NuoDB 4.0 features, checkout the blog or signup for the webinar. You can also download NuoDB Community Edition from the company website.
NuoDB recently released the minor version 4.0.1 which includes the following new features:
- Windows Installation Package: A new Windows installation package in .zip file format is now available, providing additional installation flexibility for Windows environments. This includes the ability to install multiple NuoDB instances on the same Windows server.
- Memory Parameters: The "mem" database option now supports specification of values in binary format (Gi/Mi/Ki) as well as decimal format (G/M/K). All values will be interpreted as binary. For example, 1G and 1Gi will represent 1024 MB. This parameter is used to set the maximum amount of memory in bytes to be utilized by a database process. To define this amount in kilobytes, megabytes or gigabytes, append either 'Ki', 'Mi', or 'Gi' to the value specified, for example 2Gi.
In other related news, the NuoDB team recently joined Intel and Temenos at SIBOS 2019 Conference, a financial services event, to present on how financial institutions can leverage the NuoDB distributed SQL database on premise or on the cloud.