v0.3.2

Features

Pisa-Controller

• Support database table strategy config #382

Pisa-Proxy

• Support database table strategy #380 #384
• Support min,max,sum aggregation function #386 #388 #389

Enhancement

• Sharding rewrite logic optimizition #387

Fix

Pisa-Proxy

• Fix parse sharding toml config error #381

Other

Charts

• Update to v0.3.2

v0.3.1

Features

Pisa-Controller

• Support QoSClaim CRD for Pisa-Daemon #354

Pisa-Proxy

• Support database strategy #345

Pisa-Daemon

• Support set QoS for app #351 #360 #363 #364 #366

Enhancement

Pisa-Proxy

• Support min，max，avg function for merge stream #355 #359
• Support create table sql parser #302
• support create resource group SQL parser #365
• Support create role sql parser #373

Fix

Pisa-Proxy

• Fix SQL parsing abnormally issues #369

Other

golang-sdk

• Add QoSClaim CRD

Charts

• Update to v0.3.1

v0.3.0

Features

Pisa-Controller

• Support CRD DataShard #326

Pisa-Proxy

• Support single database sharding #338

Enhancement

Pisa-Controller

• Optimized sidecar injection #234
• Support generic static readwrite splitting rule #251

Pisa-Proxy

• Support SHOW STATUS parser #254
• Introduce CloudWatch Sinker for later audit events #258
• Support CREATE TABLESPACE parser #259
• Support CREATE SERVER #261
• Front MySQL protocol use tokio codec #263
• Support dynamic readwrite splitting monitor switch #264
• Refactor MySQL server runtime #274
• Experimental SIMD in SQL Parser #278

Fix

Pisa-Proxy

• Fix Apple M1 Macbook build failure in some cases #260
• Fix malformed SQL format in some cases #291
• Fix SQL parsing abnormally issues #297
• Fix unexpected AST in some cases #301
• Fix Pisa-Proxy crash without receive VirtualDatabase configuration #319

Other

Golang-SDK

• Move CRD and kubernetes client to github.com/database-mesh/golang-sdk #247
• Add DataShard CRD and update VirtualDatabase with DataShard as new spec member in Golang-SDK

Docs

• Add sharding doc
• Optimized microservices-demo deployment instruction #318
• Fork github.com/microservices-demo/microservices-demo to database-mesh and correct configurations for better demo, see: github.com/database-mesh/microservices-demo

Charts

• Update to v0.3.0

Known Issue

• DO NOT support SHOW DATABASES and SHOW TABLES
• DO NOT support observability under sharding mode

v0.2.0

Features

Pisa-Controller

Config

• Add Dynamic ReadWriteSplitting config to TrafficStrategy CRD.

Pisa-Proxy

Runtime

• Support Dynamic ReadWriteSplitting #204
• Support subcommand sidecar and daemon #190

Enhancement

• Refactor Pisa-Proxy config #182
• Complete Show SQL. #183
• Pisa-Controller code coverage check. #192
• Client conn add retry #215

Fix

Pisa-Controller

• Fix tls in webhook #221

Pisa-Proxy

• Fix MySQL8 auth plugin auth failed. #170
• Fix MySQL protocol EOF packet #166
• Mysql protocol charset #154
• Fix injected envs #223

Docs

• Add dynamic readwritesplitting doc
• Update standalone docs doc

Charts

• Update to v0.2.0

v0.1.1

Features

Pisa-Controller

Configuration convertion

• Add ReadwriteSplitting config to TrafficStrategy CRD.

Pisa-Proxy

Setup

• Admin port type changed from string to u32.
• Unify the regex value type for CircuitBreak, ConcurrencyControl and ReadWriteSplitting in TrafficStrategy as array.

Runtime

• Support Static ReadwriteSplitting(No backend awareness).
• Support TCL statement parsing.
• Support show databases, show tables,create database parsing.

Observability

• Introduce MetricsManager and MetricsCollector.
• Add sql_under_processing metric as Gauge.

Fix

Pisa-Controller

Setup

• Fix apiservice json unmarshal error. #34
• Rename sidecar name to pisa-proxy. #72
• Add default host as 0.0.0.0 and port as 3306 to MySQL type VirtualDatabase. #68
• Add server_version to Pisa-Controller and Pisa-Proxy. #111

Pisa-Proxy

Runtime

• Fix handle prepare packet hang when prepare statement is too long. #73
• Fix SQL Lex parsing some error. #98 #104
• Support Regex array for CircuitBreak, ConcurrencyControl and ReadWriteSplitting. #123 #124
• Support default admin port as 5591. #121

Docs

• Add first blog.
• Update CRD description doc.
• Add readwritesplitting doc.
• Add version.

Charts

• Update to v0.1.1

v0.1.0

This is the first release of Pisanix.

Features

Pisa-Controller

Setup

• Label-based sidecar injection

Configuration convertion

• Kubernetes CRD convertion to Pisa-Proxy configurations, including VirtualDatabase, TrafficStrategy, DatabaseEndpoint

Pisa-Proxy

Setup

• Retrieve configuration from Pisa-Controller

Runtime

• Support multiple proxy runtimes speaking MySQL protocol
• Support connection pool and basic loadbalancing strategy
• Support Yacc based SQL parser: SELECT, INSERT, UPDATE, DELETE, PREPARE, EXECUTE, BEGIN and SET.
• Support Regex based SQL circuit break
• Support Regex based SQL concurrency control

Observability

• Supoort basic observability
  • sql_processed_total
  • sql_processed_duration