Plugin management

The plugin management feature for ApsaraDB for SelectDB lets you manage plugins, such as JDBC drivers, from a centralized console to support multiple SQL dialects. This feature automatically distributes and synchronizes plugin updates across all nodes, including those added during scaling. This ensures strict version consistency across the cluster and simplifies operations.

Prerequisites

The instance kernel version must be 4.1.0 or later.

Supported plugins

There are two types of plugins:

Default plugin: These plugins are pre-installed when you create an instance and are ready to use. They cannot be uninstalled.
Optional plugin: You can install these plugins from the console as needed. You can also uninstall them at any time.

Note

The information in this table may change and may not include the latest plugins or versions. For the most accurate list of plugins and version details, refer to the console.

Database type	Plugin name	Type	Description
ClickHouse	clickhouse-jdbc-0.3.2-patch11-all.jar	default	A JDBC driver for connecting to ClickHouse databases, compatible with older ClickHouse services. This file includes all dependencies.
ClickHouse	clickhouse-jdbc-0.4.2-all.jar	default	A newer JDBC driver for ClickHouse with improved performance and bug fixes. It supports more recent ClickHouse features. This file is a fat jar that includes all dependencies.
SQL Server	mssql-jdbc-11.2.0.jre8.jar	default	The official Microsoft SQL Server JDBC driver, version 11.2.0, for JRE 8 environments. It supports SQL Server 2012 and later.
SQL Server	mssql-jdbc-11.2.3.jre8.jar	default	A minor update to the official Microsoft SQL Server JDBC driver. It includes security patches and stability improvements.
MySQL	mysql-connector-java-8.0.25.jar	default	The official Oracle MySQL JDBC driver for connecting to MySQL 8.0+ databases. It supports SSL-encrypted connections, new authentication plugins, and features.
	mysql-connector-j-8.4.0.jar	default	The official Oracle MySQL Connector/J 8.4.0 driver for connecting to MySQL 8.0+ databases. Key features include: Enhanced JSON processing capabilities and X DevAPI improvements. Support for the TLS 1.3 security protocol. Performance optimizations in high-concurrency environments. Support for enhanced authentication plugins such as `caching_sha2_password`.
	mysql-connector-j-8.3.0.jar	optional	The official Oracle MySQL Connector/J 8.3.0 driver for connecting to MySQL 8.0+ databases. Key features include: Improved JSON processing capabilities and X DevAPI enhancements. Support for the TLS 1.3 security protocol. Performance optimizations for high-concurrency environments.
Oracle	ojdbc6.jar	default	An Oracle JDBC driver (ojdbc6) for Java 6 environments and Oracle Database 11g. It is primarily used for legacy systems that connect to older Oracle databases.
Oracle	ojdbc8.jar	default	An Oracle JDBC driver (ojdbc8) for Java 8 environments and Oracle Database 12c or later. It supports modern features such as JSON.
PostgreSQL	postgresql-42.5.0.jar	default	A PostgreSQL JDBC driver, version 42.5.0. It supports PostgreSQL 9.4 and later.
PostgreSQL	postgresql-42.5.1.jar	default	A bug-fix release of the PostgreSQL JDBC driver that improves stability and is recommended for production environments.

Manage plugins

Install plugin

Log in to the Alibaba Cloud SelectDB console.
In the upper-left corner of the page, select the region where your instance is located.
On the Instances page, click the target instance ID.
In the navigation pane, click Plug-in Management.
On the Available Plug-ins tab, find the target plugin, and click Install in the Actions column.
In the confirmation dialog box, click Install.

After you submit the installation request, the instance status changes to Installing.... The installation takes about one minute to complete, after which the instance status returns to Running.

Uninstall plugin

You can only uninstall optional plugins that you have installed yourself. Follow these steps:

Navigate to the Plug-in Management page.
Switch to the Installed Plug-ins tab.
Find the plugin you want to uninstall, and click Uninstall in the Actions column.
In the confirmation dialog box, click Uninstall.