R2DBC doesn't support for Multiple Host based connection pool

[rajeev-jha1988]

Currently, R2DBC don't provide the support for the connection pool with a read replica URL. Its throwing unknown host exception.
java.net.UnknownHostException: failed to resolve 'host1:3306,replica1:3306' after 2 queries .
Below is the Link for Stack over flow
https://stackoverflow.com/questions/66172770/spring-data-read-replica-setting-for-r2dbc

[mirromutth]

Hi there, apologies for the late reply.

Currently, this would not be a driver issue. R2DBC was using r2dbc-pool for pooling, and the driver implementation would not consider about connection pool.

If this problem still bothers you, could you please create a ticket in the r2dbc pool issues?

[suresh0087]

r2dbc Pool is saying this should be addressed by driver project as per below
r2dbc/r2dbc-pool#169

[suresh0087]

Hi @mirromutth,

is R2DBC is supporting for mutliple hosts currently ?

[suresh0087]

Hi @mirromutth ,

could you please help on supporting multiple hosts for r2dbc

[sayanroy7]

@mirromutth Are you actively maintaining this project? There seems to be no response on the open issue! Imho, this is a very basic need to consider using this driver.