Failover Plugin Issue

[prthbabu]

Hi,

Am using failure plugin to allow connections to be very quickly restored in the event of a DB instance failure as per your documentation.
Have an aurora global cluster with 2 nodes in 2 different regions. My client application is running in US-EAST-1 which is current primary.
From AWS console, I tried to failover to the secondary region so that it becomes the new primary. This failover process which i see from AWS console takes at least 15 mins to set a new primary and make all nodes available.
But during this process, I see this error in my client application:

2023-10-19 12:21:27.682 ERROR 8 --- [nio-9000-exec-6] s.a.j.p.f.FailoverConnectionPlugin : Unable to establish SQL connection to the writer instance.
2023-10-19 12:21:27.692 WARN 8 --- [nio-9000-exec-6] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Failed to validate connection software.amazon.jdbc.wrapper.ConnectionWrapper@73aa0339 - org.postgresql.jdbc.PgConnection@7f8832a3 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2023-10-19 12:21:27.710 WARN 8 --- [nio-9000-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 08003

When all nodes are back available and a new primary is set:
Since my client application in US-EAST-1 is still pointing to the old writer instance connection string, can only read now.

Please let me know how can I solve this by not changing my connection string and low downtime?

[crystall-bitquill]

Hi @prthbabu,

Thanks for your question! Unfortunately the AWS JDBC Driver does not currently support global databases. Support for this feature is in the backlog but we cannot comment on a timeline right now. Apologies for the inconvenience, we will update our documentation to reflect this limitation.

[prthbabu]

Hi @crystall-bitquill

Could you please let me know if your documentation is updated with this issue for global databases?
Also any chance this will be sorted in the near future?
Or any suggestion on work around at the moment?

Thanks

[davecramer]

@prthbabu see https://github.com/awslabs/aws-advanced-jdbc-wrapper#known-limitations for discussion about global databases