Extension Splitting

Availability

This feature is available since MogDB 5.0.0.

Introduction

In MogDB 5.0.0, extensions are independently developed. Each extension of the related version corresponding to the server package can be downloaded from the website, facilitating installation of the latest extension package and independent upgrade of each extension.

Additionally, Dolphin MySQL is integrated into MogDB server and is not independently packaged. Users can create a database whose compatibility type is B without running any command.

Benefits

MogDB version 5.0.0 extensions will be released independently so that users can obtain and install extensions individually. This means that you can selectively install and upgrade extensions according to your needs to meet your specific business requirements.

In addition to this, we have also integrated the Dolphin MySQL Compatible extension, that allows users to use MogDB while enjoying the convenience of being compatible with MySQL. This means that you can operate MogDB with similar syntax and functionality as MySQL, without having to learn a new database language and features. In this way, you can migrate and manage your data more easily and enjoy the benefits of MogDB's high performance and reliability.

Description

Extension list:

1. pg_bulkload: data import in batches

2. pg_prewarm: data warm-up

3. pg_repack: unlock vacuum

4. PostGIS: spatial data extension

5. wal2json: logical replication

6. db_link: homogeneous database connection

7. pg_trgm: full-text search

8. whale: Oracle compatibility (MogDB version)

fdw:

1. postgresql_fdw: supports PostgreSQL/openGauss. It uses the openGauss libpq package.

2. oracle_fdw: supports Oracle. It uses the Oracle 19c package, and supports the arm and x86 packages.

3. mysql_fdw: support MySQL. It uses the MySQL 8.0 client package.

The following extension will be released with server and is not packaged independently:

1. Dolphin MySQL compatibility extension

Constraints

1. For built-in extensions, Dolphin, whale, and db_link, and pg_trgm will be packaged with MogDB server since MogDB 3.1.0.
2. Hot-upgrade extension is not supported temporarily.
3. Uninstallation extension is not supported temporarily.
4. Extension naming rule: {Extension name}-{Community version of an extension}-{Version of MogDB server}-{Supported operating system}-{CPU architecture}.tar.gz

Related Pages

Extension Acquisition