eco-friendly

KlustronDB supports both MySQL and PostgreSQL database connection protocols and SQL syntax, allowing seamless integration with these two world-class open-source database ecosystems. KlustronDB supports MySQL and PostgreSQL client connection libraries for all common programming languages, so software written in these languages can connect to KlustronDB and correctly execute all standard SQL statements as well as MySQL and PostgreSQL-specific DML SQL statements. Corresponding data migration tasks can also be completed with one click using KlustronDB and third-party data import tools.

KlustronDB provides tools specifically for importing data from MySQL either in full or in streams, and KlustronDB can also collaborate with third-party data import tools such as OGG to import data from common database systems like PostgreSQL, Oracle, and SQL Server.

1. Data can be imported into the KlustronDB cluster from databases such as MySQL, TiDB, Oracle, PostgreSQL, etc. Not all common database systems are listed here, but as long as tools like OGG support a particular database system, users can import data from it into the KlustronDB cluster.

• Data Import and Export
• Importing Full Data and Streaming Synchronization from Oracle to KlustronDB
• Full Import and Streaming Synchronization of Data from PostgreSQL to KlustronDB
• Using Ti-dumpling and Ticdc to synchronize TiDB data to KlustronDB
• Using Ti-dumpling and Ti-binlog to synchronize TiDB data to KlustronDB
• Importing Data from MySQL Fully and Streamingly to KlustronDB
• From Oracle to KlustronDB Stream Data Synchronization
• Oracle Migrate Data to KlustronDB
  • DDL2KUNLUN
• Introduction to KlustronDB's Binlog2sync Tool
• KlustronDB CDC Principles and Functions
• Detailed Explanation of KlustronDB CDC Usage
• KlustronDB CDC Parallel Replication and High Availability

2. Since KlustronDB's computing nodes are developed based on PostgreSQL, they basically support PostgreSQL connection protocols and SQL syntax, with only a few features removed. For details, see:

• KlustronDB and PostgreSQL Compatibility
• KlustronDB System Introduction: SQL Standard Compatibility and Routine Maintenance

3. KlustronDB's support for the MySQL connection protocol and proprietary DML syntax allows almost all applications originally using MySQL to connect to KlustronDB without any code modifications or recompilation. However, there are still a few subtle differences between KlustronDB and MySQL in these areas, which may cause issues for some applications. Here, we provide detailed technical details of KlustronDB in these aspects for user reference. In addition, we have checked and verified whether all published MySQL connection libraries for common programming languages can connect to KlustronDB and work normally. Except for a very few exceptions, the vast majority of versions work fine, as detailed below.

• KlustronDB & MySQL Connection Protocol Introduction
• KlustronDB's Support for MySQL Private DML Syntax
• Summary of MySQL Syntax and Features Not Supported by KlustronDB
• KlustronDB Summary of MySQL Connectors for Current Mainstream Programming Languages
• Introduction to KlustronDB's Unique Variable Read-Write Features

4. The final chapter will also provide technical documentation written by our database technology experts on the core technologies, usage, and tuning of MySQL and PostgreSQL for users' reference.

• Handling and Fixing MySQL Bugs

END