maazamalik commented on issue #15638: URL: https://github.com/apache/druid/issues/15638#issuecomment-1907839992
We tried replacing default community version of mysql driver to the AWS mysql jdbc driver. The problem that @FarhadF originally posted is fixed by using aws driver. When the failover in RDS occurs, the connection times out for ~10s followed by a connection reset (resolves the rds endpoint again) and then the coordinator continues to work smoothly. The problem now is that the lookups doesn't work. historical logs: ``` org.apache.druid.query.lookup.LookupUtils - Lookup [partner_uuid_to_sales_manager_uuid] could not be serialized properly. Please check its configuration. Error: Cannot construct instance of `org.apache.druid.query.lookup.namespace.JdbcExtractionNamespace`, problem: Failed to find MySQL driver class. Please check the MySQL connector version 5.1.49 is in the classpath ``` The lookups only work when the config `druid.access.jdbc.enforceAllowedProperties` is set to `false`. but according to the docs, https://druid.apache.org/docs/latest/configuration/#external-data-access-security-configuration, this is depricated and will be removed in the future version. druid: `v28.0.1` aws mysql jdbc driver: v1.1.12 How to reproduce: ``` ARG MYSQL_URL=https://repo1.maven.org/maven2/software/aws/rds/aws-mysql-jdbc/1.1.12/aws-mysql-jdbc-1.1.12.jar ARG MYSQL_JAR=aws-mysql-jdbc-1.1.12.jar ``` config: ``` druid.metadata.mysql.driver.driverClassName=software.aws.rds.jdbc.mysql.Driver druid.metadata.storage.connector.connectURI=jdbc:mysql:aws://aurora-mysql-host/database_name ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
