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 the DBPlusEngine.
limit Proxy	Limit the number of instances created by DBPlusEngine-Proxy in a single cluster.
limit 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 address of the hardware device on which the computing nodes in the cluster.

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	DataType	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

No License or Performance After License Overrun #

Can start cluster unable to execute RDL, RUL, and RAL, can 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