search

mariadb-corporation / mariadb-connector-r2dbc

Connector for Java R2DBC
Apache License 2.0
117 stars 25 forks source link

Support for failover and load ballancing modes #11

Open jddipqd opened 3 years ago

jddipqd commented 3 years ago

MariaDB Connector/J supports multiple Failover and Load Balancing Modes: https://mariadb.com/kb/en/failover-and-high-availability-with-mariadb-connector-j/

Is this supported with mariadb-connector-r2dbc? I'm mostly interested in replication mode.

rusher commented 3 years ago

That's on the roadmap, even if it probably will be slightly different from jdbc connector.

That's to be describe and discussed still, probably for 1.1.0 version.

My opinion is that multiple hosts for failover on other nodes, but only for same type (primary or replica) JDBC connector implementation is permitting primary and replica for mysql connector compatibility. But this induce different performance issues when switching to read-only.
It's way better to have a second pool with only read-only hosts

paskos commented 2 years ago

We use multi-cluster setup with loadbalance: loadbalancing mode. Is there a plan to support it in reactive connector ? Thanks in advance

edmundtansw commented 2 years ago

Is there any update to this? Looking forward to failover host option for R2DBC connector.