Ecosystem Compatibility

Klustron (formerly KunlunBase) supports both MySQL and PostgreSQL database connection protocols and SQL syntax, seamlessly integrating with the ecosystems of these two world-class open-source databases. Klustron supports MySQL and PostgreSQL client libraries for all common programming languages, allowing software written in these languages to connect to Klustron and correctly execute all SQL standard-compliant statements, as well as MySQL and PostgreSQL-specific DML SQL statements. Corresponding data migration tasks can also be completed with one click using Klustron and third-party data import tools.

Klustron provides tools for full or streaming data imports from MySQL and can also collaborate with third-party data import tools like OGG to import data from other common database systems such as PostgreSQL, Oracle, and SQL Server.

1. Data can be imported into a Klustron cluster from MySQL, TiDB, Oracle, PostgreSQL, and other databases. Although not all common database systems are listed here, if tools like OGG support a specific database system, users can import data from it into the Klustron cluster.

• Data Import and Export
  • Full Import and Stream Synchronization of Data from Oracle to Klustron
  • Full Import and Stream Synchronization of Data from PostgreSQL to Klustron
  • Using Ti-dumpling + Ticdc to Synchronize TiDB Data to Klustron
  • Using Ti-dumpling + Ti-binlog to Synchronize TiDB Data to Klustron
  • Full and Stream Data Import from MySQL to Klustron
  • Stream Data Synchronization from Oracle to Klustron
  • Migrating Data from Oracle to Klustron
  • DDL2KUNLUN
  • Klustron's Binlog2sync Tool Introduction
  • Klustron CDC Principles and Functions
  • Detailed Usage of Klustron CDC
  • CDC Parallel Replication and High Availability in Klustron

2. Since Klustron's compute nodes are based on PostgreSQL, it supports most PostgreSQL connection protocols and SQL syntax, with a few removed features. For more details, see:

• Klustron Compatibility with PostgreSQL
• Introduction to Klustron: SQL Standard Compatibility and Routine Maintenance

3. Klustron supports MySQL connection protocols and private DML syntax, allowing almost all applications originally using MySQL to connect to Klustron without any code modifications or recompilation. However, there are still a few minor differences between Klustron and MySQL that may cause issues for some applications. The technical details of these differences are provided for user reference. Additionally, we have verified the compatibility of all released MySQL connectors for common programming languages with Klustron, with most versions working correctly except for a few exceptions. For more details, see the following documents:

• Introduction to Klustron's MySQL Connection Protocol
• Klustron's Support for MySQL Private DML Syntax
• Summary of Unsupported MySQL Syntax and Features in Klustron
• Summary of MySQL Connectors for Mainstream Programming Languages Supported by Klustron
• Introduction to Klustron's Unique Variable Read and Write Features

4. This chapter also provides technical documents written by our database experts on MySQL and PostgreSQL kernel technologies, usage, and optimization for user reference.

• MySQL Bug Handling and Fixing

END