Simple mysql server that respond to SELECT 1 implementing wire protocol
Testing get a list of databases using native MySQL X Plugin
Testing a select interacting to PolarDBX Engine XProtocol
Uses XDataSource to create a connection using method getConnection().
XDataSource uses XConnectionManager
Simple query breakdown test using Apache Calcite Framework
A more complete example:
- QuerySQL.java - Executes a simple query from code against percona-server
- ParseSQL.java / TestSchemaManager.java - Parse a query
- SimpleServer.java - Complete server , client connect to a server send a SQL query that runs against percona-server with xprotocol plugin
- SimpleSplitServer.java - Extends SimpleServer by spliting query to run by chunk
Option to run:
-
Type for an SQL and loop over
Create a connection using XConnectionManager and manager.getConnection -
Build execution plan
Final server test only with splitting query logic:
- Removed Extra Inheritance
- Moved Inline Classes to Helper Files
- Simplified Query Splitting Logic
- Refactoring for a Single Purpose