Klustron 1.2 Release Notes

The Klustron team has developed a series of significant features during the version 1.2 cycle, building upon the core functionalities already present in version 1.1. This release introduces more comprehensive features and improved performance. Here, we outline the new features directly related to the user, enhancements to existing functionalities, and a summary of key bugs fixed and usability improvements. This list highlights the principal features implemented and major bugs fixed in version 1.2.

1 New Features

1. Global Multi-Version Concurrency Control (Global MVCC)
2. Change Data Capture (CDC) for Cluster Data Updates
3. Remote Cluster Replication (RCR)
4. Multi-IDC High Availability Mechanism
5. TABLE GROUPING Mechanism and Features
6. Re-enabled several advanced SQL features, including domains, CHECK constraints, triggers, materialized views, and Row Level Security (RLS)
7. XPanel Alert Mechanism
8. Support for Common MySQL Table Creation Options
9. #1123 Support for Common MySQL DDL Syntax
10. Several usability and UI improvements in XPanel
11. Encryption for backup data files and log files

1.1 Core Features

#1204 Show whether the index is used in query plan 
#1231 Read Committed Isolation in explicit transactions for SELECT statements 
Clustermgr Cluster High Availability: Ensures immediate availability of a new master node for Klustron cluster management if the primary clustermgr node fails

1.2 MySQL Compatibility

#1202 Make default schema of MySQL connections configurable
#1211 MySQL syntax compatibility corner cases
#1459 Compute nodes support for join operations without join conditions, defaulting to cross join, consistent with MySQL's default behavior

2 Enhancements to Existing Features

Use of prepared statements and binary protocol for executing queries
#1049 Parallelize sort merge join
#1109 Parallel SELECT on single tables
#1231 Read Committed Isolation in explicit transactions for SELECT statements
Optimization of Klustron cluster high availability mechanisms

2.1 Backup and Recovery Enhancements

#479 Support for NFS storage backup data
#1206 Support for batch operations in logical backup recovery
#1219 Support INTERNAL_TRX_NO_USER_DATA flag in myloader and binlog2sync
#1243 Specify logical backup data recovery through repartition

2.2 Scalability Enhancements

#472 Wait for the table's new location and retry after a table is reported not found in a storage shard
#1150 Scale-out enhancement
#1201 Configurable rate limiting for full data transfer during scaling
#1217 Flag transactions initiated by internal cluster operations
#1223 Table move enhancement
#1224 Table catch-up in gtid_mode

2.3 Other Enhancements

#1111 Remove cached sequences when made read-only
#1253 Enable RocksDB and its configurations in installation scripts
#1258 Refactor myloader and mydumper
#1261 Cluster_mgr HA: Increase election timeout and implement election prioritization

3 Important Bug Fixes

3.1 MySQL Compatibility Bug Fixes

#1338 Compute node using MySQL protocol did not insert data into the expected schema
#1373 database() system function for MySQL connections

3.2 Community Edition MySQL InnoDB Bug Fixes

#1363 InnoDB: trx mis-ordered in trx list
#1323 InnoDB: TRX_SYS_TRX_NUM_GTID written to the wrong place
#1278 InnoDB: readview mis-ordered

END