Re: JDBC thin client load balancing and failover support

[rizal123 <kh...@btpn.com>]

Hi Val,

According to this ticket 'IGNITE-7029'.
How long it will be *Live*?
At least tell me the estimated time?

Because I have the same problem, about failover and Jdbc thin can access
multiple Node (IP Address).
And I need to go to POC.

regards,
-Rizal





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: JDBC thin client load balancing and failover support

[Denis Magda <dm...@apache.org>]

> I`m using JDBC Thin, at my datasource I put only one IP address.
> How come the other cluster will get the data? If i only invoke into one Ip
> address.

The node the driver connects to forwards queries to the rest of cluster nodes. It’s just a gateway for the driver.

The goal of the ticket is to let the driver connect to the other node (gateway) if an old one went down and push queries through the new instead.

> Btw, this is another question for me.
> How about the load-balancer?

According to the definition of the ticket we would try to support both - reconnection and load-balancing.

As for now, you still can do this on your own by opening several connections to the cluster via different IPs and load balancing queries among them.

Hope this helps.

—
Denis

> On Jan 9, 2018, at 6:38 PM, rizal123 <kh...@btpn.com> wrote:
> 
> Yes it is.
> I can do put some logic to re-route to another address if primary node is
> down. But I think this is not solution..
> 
> Btw, this is another question for me.
> How about the load-balancer?
> 
> Currently i have 3 VM (3 ip address). Which will be used as 3 cluster
> ignite. Behind that, i have Oracle database. 
> I`m using JDBC Thin, at my datasource I put only one IP address.
> How come the other cluster will get the data? If i only invoke into one Ip
> address.
> Please let me know if there is something I miss..
> 
> 
> 
> 
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: JDBC thin client load balancing and failover support

[rizal123 <kh...@btpn.com>]

Yes it is.
I can do put some logic to re-route to another address if primary node is
down. But I think this is not solution..

Btw, this is another question for me.
How about the load-balancer?

Currently i have 3 VM (3 ip address). Which will be used as 3 cluster
ignite. Behind that, i have Oracle database. 
I`m using JDBC Thin, at my datasource I put only one IP address.
How come the other cluster will get the data? If i only invoke into one Ip
address.
Please let me know if there is something I miss..







--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: JDBC thin client load balancing and failover support

[Denis Magda <dm...@apache.org>]

It should be supported for 2.4.

Anyway, this should not be a showstopper because this logic can be embedded into an application. If the application loses a connection to one IP address it can re-connect to the cluster via a different one.

—
Denis

> On Jan 8, 2018, at 11:37 PM, rizal123 <kh...@btpn.com> wrote:
> 
> Hi Val,
> 
> According to this ticket 'IGNITE-7029'.
> How long it will be *Live*?
> At least tell me the estimated time?
> 
> Because I have the same problem, about failover and Jdbc thin can access
> multiple Node (IP Address).
> And I need to go to POC.
> 
> regards,
> -Rizal
> 
> 
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/