Use of License in DBPlusEngine-Driver #

Background #

Function of License	Description
limit duration	Limit the duration of DBPlusEngine.
limit resources	Limit the number of storage nodes created by DBPlusEngine.
limit compute node (Proxy)	Limit the number of instances created by DBPlusEngine-Proxy in a single cluster.
limit compute node (Driver)	Limit the number of instances created by DBPlusEngine-Driver in a single cluster.
limit versions	Limit the version of the DBPlusEngine instance in a stand-alone or cluster.
MAC address of the hardware device	Limit the MAC addresses of the hardware devices where computing nodes (Proxy) in the cluster are located and the MAC addresses of the hardware devices accessed by computing nodes (Driver).
Limit functionality	Restrict available functions.

Configuration Method #

JAVA API #

Import Maven Dependency #

<dependency>
    <groupId>com.sphere-ex</groupId>
    <artifactId>shardingsphere-jdbc-core</artifactId>
    <version>${dbplusengine.version}</version>
</dependency>

Configuration Example #

Class name: com.sphereex.dbplusengine.license.config.LicenseRuleConfiguration

Attributes:

Name	Data Type	Description
license	String	license registration code

YAML #

Import Maven Dependency #

<dependency>
    <groupId>com.sphere-ex</groupId>
    <artifactId>shardingsphere-jdbc-core</artifactId>
    <version>${dbplusengine.version}</version>
</dependency>

Configuration Example #

databaseName:

mode:

dataSources:

rules:

license: xxx

SpringBoot #

Import Maven Dependency #

<dependency>
    <groupId>com.sphere-ex</groupId>
    <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
    <version>${dbplusengine.version}</version>
</dependency>

Configuration Example #

spring.dbplusengine.rules.license: xxx

Spring Name Space #

Import Maven Dependency #

<dependency>
    <groupId>com.sphere-ex</groupId>
    <artifactId>shardingsphere-jdbc-core-spring-namespace</artifactId>
    <version>${dbplusengine.version}</version>
</dependency>

Configuration Example #

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:license="https://www.sphere-ex.com/schema/dbplusengine/license"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           http://www.springframework.org/schema/beans/spring-beans.xsd
                           https://www.sphere-ex.com/schema/dbplusengine/license
                           https://www.sphere-ex.com/schema/dbplusengine/license/license.xsd
                           ">
    <license:license id="license" license="xxx"/>
</beans>

Post-processing #

If the following error occurs, please obtain the latest license and update the license.

No license prompt

FATAL:  License not registered

Incomplete license prompt

FATAL:  Incomplete license

License expiration prompt

FATAL:  License is expired

Illegal license prompt

ERROR:  The xxx exceeds the limit of the license

How is Performance Affected in Cases of No License or License Overrun #

Can start cluster, unable to execute RDL, RUL, and RALan execute a small amount of RQL
DistSQL with the global release

SHOW STORAGE UNITS
SHOW *
COUNT * RULES
EXPORT DATABASE CONFIGURATION
CONVERT YAML CONFIGURATION
REGISTER LICENSE
Transaction-related standard statements

The number of instances exceeds the limit and can be executed

SET INSTANCE STATUS

DB’s SQL statement cannot be executed

License Expired alert #

A WARN level alert is output in the cluster’s compute node run log when the license is <= 30 days from expiration.

The tips are:

The license of DBPlusEngine will expire in xx day(s)