Klustron-1.2 Datasheet

Key Features

Sharding & Partitioning
Fullsync & Fullsync HA
Fault Tolerance & Auto fail-over & 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 & CDC
Online DDL & Repartitioning
Cluster Management GUI&API

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.2 Technical Specifications
Open Architecture · Compatible with PostgreSQL & MySQL connection protocols and common SQL syntax · Supports InnoDB & RocksDB storage engines · Data-consistent, portable CDC service 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 · Cluster Hot Backup · Full Physical Backup, Incremental Log Backup · Logical Backup for Database/Schema/Table · Logical Restore for Database/Schema/Table · Time-Point-Based Physical Restore · Transaction-Based Physical Restore · Scripted Command-Line Tools · 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 IDCs

Kluston-1.2 Technical Specifications

Open Architecture
· Compatible with PostgreSQL & MySQL connection protocols and common SQL syntax
· Supports InnoDB & RocksDB storage engines
· Data-consistent, portable CDC service

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
· Cluster Hot Backup
· Full Physical Backup, Incremental Log Backup
· Logical Backup for Database/Schema/Table
· Logical Restore for Database/Schema/Table
· Time-Point-Based Physical Restore
· Transaction-Based Physical Restore
· Scripted Command-Line Tools
· 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 IDCs

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

Klustron-1.2 Datasheet

# Klustron-1.2 Datasheet

Klustron-1.2 Datasheet