The Data Access Proxy connector is based on the standard Java Database Connectivity (JDBC) interface. It proxies standard database connection pools, such as DBCP, Druid, and c3p0, to perform create, read, update, and delete (CRUD) operations on databases. You can use the connector to connect to a Data Access Proxy server and execute database operations.
The Data Access Proxy connector supports the following features:
Database password encryption and decryption
Database passwords are sensitive information. To improve security, you can use ciphertext for passwords in the configuration file. The Data Access Proxy connector provides the SecuritySpec interface. This interface lets you integrate custom encryption and decryption algorithms from a JAR package.
SQL Tracing Analysis
You can pass the traceId to the Data Access Proxy server in a custom MySQL HINT statement. This creates a complete trace from your application to the server and outputs SQL execution logs. This lets you use a tracing analysis application to quickly find the execution duration of a SQL statement.
Routing for sharding
You can use custom HINT statements to route a SQL statement to a specific sharded database or table.
Interceptor extensions
The Data Access Proxy connector has a flexible extension mechanism. You can implement the Interceptor interface to add more features.