Mycat2
MySQL Proxy using Java NIO based on Sharding SQL, Calcite
Open source intermediate for the MySQL database network protocol written in Java language, open source of GPLv3 protocol. Custom Calcite distributed query engine, edit SQL to relationship algebra expression, rule optimization engine, and cost optimization engine, generate physical execution plan, support logic view. Any cross-currant cross-table join query, support cross-currant cross-table non-associated query, support cross-currant cross-table association query, support cross-currant cross-table Window grammar, support global secondary index, limited support storage process, support visualization configuration. Support parallel extraction of result sets, support the automatic transfer of back-end result sets, support multiple routing notes, and optimizer notes. Parameterization of the requested SQL, cache physics execution plan, and request of the same parameterization SQL, will avoid some analysis and optimization processes.