r2dbc-mssql icon indicating copy to clipboard operation
r2dbc-mssql copied to clipboard

Published 20 hours ago • verified publisher icon r2dbc

Support MultiSubnetFailover parameter for r2dbc-mssql

Open satory-sky opened this issue 5 years ago • 2 comments

Hi

Could you please introduce MultiSubnetFailover parameter for r2dbc-mssql driver. I am considering to move from plain JDBC driver (that successfully supports MultiSubnetFailover) to R2DBC for mssql. However, I could not find any information regarding usage of MultiSubnetFailover parameter neither in documentation no in code. Do you have any plans to introduce this parameter as potential feature for a future release? Could you please help.

Best Regards, Alex Kontarero.

satory-sky avatar Jul 02 '20 07:07 satory-sky

This driver does not yet support high-availability or failover options. It makes sense to consider those and any help is appreciated to get this featured in soon.

SQL Server AlwaysOn relies on instance resolution which requires #129 first to be in place. It makes sense to combine server resolution with the application intent (read only, read write) in some sense to cater for read-write and read-only nodes.

mp911de avatar Jul 03 '20 09:07 mp911de

Hi

Is there any update on this topic? We are using this driver, but now we need support for MultiSubnetFailover and we would need to give up it if it is not supported. Can I somehow help, so we get support for MultiSubnetFailover?

Best, Milivoje

kojadin avatar May 02 '22 05:05 kojadin