Klustron-1.3 Datasheet

Key Features

• Sharding & Partitioning
• Fullsync & Fullsync HA
• Fault Tolerance & Auto Failover & Zero down time
• Elastic Scale-out
• Parallel Query Execution
• MySQL and PostgreSQL Client Protocols and SQL Compatibility
• SQL-2016 Compatibility
• OLAP Using Latest User Data
• Physical & Logical Backup & Restore
• Data Export/Import & Parallel CDC
• Online DDL & Repartitioning
• Cluster Management API
• XPanel
• JSON Data Management and Indexing
• Distributed Database for
  • PostGIS
  • PGVector
  • PostgresML

Klustron is designed for storing, managing, and utilizing massive amounts of data, achieving high-performance transaction processing and data read/write operations. It supports automatic online horizontal elastic scaling and maintains continuous service during node and network failures, ensuring no data loss or corruption. It is compatible with various application software and web systems.

• Unbreakable Reliability: It can automatically respond to cluster environment failures – any node failure or network failure of a Klustron cluster will not lose or damage user data, nor will it affect the normal operation of the business system.
• Elastic Scalability: It supports non-stop horizontal elastic scaling without any impact on business systems, logic, and end-user experience; and evenly utilizes computing and storage resources of all servers and provides continuous, stable, high-performance and low-latency OLTP Data access capabilities.
• Compatibility: The only application software in the industry that supports the connection protocol and DML SQL syntax of MySQL and PostgreSQL databases at the same time, and is compatible with all common programming languages, and the corresponding data migration can be completed with one click.
• Leading Performance: Klustron's OLTP performance is far ahead of competing products, ensuring that it can still provide high-throughput and low-latency transaction processing performance with terabytes of data, thousands of connections, and hundreds of thousands of QPS. See performance test report for details.
• Data Securiy: Klustron supports full data encrypted storage, log encrypted storage, and full link encrypted transmission; supports multi-level fine-grained access control, so that DBAs can define access control rules in the database system to ensure that user data will not be accessed without authorization.

Kluston-1.3 Technical Specifications

Open Architecture · Compatible with PostgreSQL & MySQL connection protocols and common SQL syntax · Supports InnoDB & RocksDB storage engines · CDC service for streaming parallel data export, with resumption after interruption and automatic recovery from failures · Compute nodes support third-party extension plugins: external data sources (FDW), stored procedure programming languages (Python/Perl/Java/Lua), PostGIS, PGVector MySQL Compatibility · Text and Binary Protocol · All MySQL DML and common DDL syntax · Prepared Statement · MySQL variable read/write syntax · AUTO_INCREMENT syntax and functionality · Toggle AutoCommit mode · Client-decided statement error handling in transactions · Implicit transaction start and commit · Collection of common SHOW commands · Support for MySQL and PostgreSQL lexical rules Complies with SQL-2016 Standard · Standard SQL · Subqueries, Table Joins · Views, Materialized Views · Triggers · Prepared Statements · Stored Procedures · User-Defined Functions · Window Functions and CTEs · GROUPING SETS, CUBE, ROLLUP · Advanced Data Management Features · Domain, Check · Row-Level Security (RLS) · Support for common character sets (Unicode, GBK) · Full i18n and l10n support Query Optimizer · Cost-Based Optimizer · Query Rewrite · Partition Pruning · Column Projection · Predicate Pushdown, Aggregation Operator Pushdown, Sort Operator Pushdown, Join Pushdown · Distinct and Limit Pushdown · Multi-Level Parallel Query Optimization · Statistics Collection, Aggregation, and Utilization High Availability · FullSync HA · Metadata RBR HA · Global Transaction Disaster Recovery · Automatic Failover for Storage Master Node · Zero Data Loss · Active-Active Configuration for Same City/Remote Locations · Multi-Data Center High Availability for Same City/Remote Locations Backup and Restore · Export to Apache Parquet files · Cluster Hot Backup · Full Physical Backup, Incremental Log Backup · Logical Backup for Database/Schema/Table · Logical Restore for Database/Schema/Table · Physical Restore to a Specified Time Point · Physical Restore to a Specified Transaction ID · Scripted Command-Line Tools · Backup to HDFS, Public Cloud Object Storage (OSS, S3), and Mounted File Systems · Streamed Data Change Export (CDC) · Batch Data Import/Export and Migration Tools

Application Interfaces · Common Language PostgreSQL Connectors · Common Language MySQL Connectors · JDBC, ODBC Security · Multi-Level, Fine-Grained Data Access Control · Database Role Management · Multiple Authentication Methods · Password Management · Encrypted Storage for Data Files and Binlog Files · Encrypted Storage for Backup Files High Performance · Read/Write Separation · Resource Isolation · Tens of Thousands of Concurrent Connections, Millions of QPS · B+ Tree Index2 · Cluster Status Monitoring, Diagnostics, and SQL Tracing · Horizontal Scaling of Compute/Storage Nodes OLTP Load and Transaction Support · ACID Transaction Support · Row-Level Locking for Inserts, Updates, Deletes · Multi-Version Concurrency Control for Read-Only Queries · Distributed Transaction Processing · Supports Multiple Transaction Isolation Levels: Read Committed, Repeatable Read, Serializable · Automatic Global and Local Deadlock Detection · Global Multi-Version Concurrency Control (Global MVCC) · InnoDB and RocksDB Engines OLAP Load Optimization · User-Defined Aggregate Functions · Analytical Function Support (OLAP) Data Sharding · Supports Three Sharding Methods - Hash, Range, List · Mirrored Tables (Replicated Tables) · Table Groups XPanel Graphical Cluster Management Configuration GUI · Cluster Creation/Deletion · Cluster Physical Backup/Restore · Cluster Logical Backup/Restore · Add/Delete Compute Nodes · Add/Delete Storage Nodes/Shards · Storage Node Master-Slave Switchover · Metadata Cluster Management · Alert Mechanism · Node Running Status Monitoring · Cluster Expansion/Contraction · Online DDL & Repartition · Cluster Log Collection via ES and Retrieval via Kibana · CDC Configuration · Active-Active Cluster Configuration · High Availability Configuration for Multi-Data Centers · Private Deployment Multi-Tenant Mode · Multi-Language and Internationalization

Notes:

1 Foreign keys are not supported.

2 Hash indexes are not supported. Although the syntax for creating Hash indexes is supported, a B+ Tree index is created underneath.

END