You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2017/11/28 01:00:35 UTC
Re: JDBC thin client load balancing and failover support
You can use client node based driver [1] to get full failover support. Thin
client currently indeed goes though a single node and I believe it makes
sense to at least provide an ability to specify multiple addresses for the
connection. I created a ticket for this:
https://issues.apache.org/jira/browse/IGNITE-7029
[1] https://apacheignite-sql.readme.io/docs/jdbc-client-driver
-Val
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: JDBC thin client load balancing and failover support
Posted by blackfield <ch...@maxpoint.com>.
This ticket is slotted for 2.4 and seems to be related.
https://issues.apache.org/jira/browse/IGNITE-6942
@Val, can you please link it with IGNITE-7029?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: JDBC thin client load balancing and failover support
Posted by Aurora <25...@qq.com>.
Client node driver mode could bring a huge memory usage on your application (
local cache)
thus I believe most choose JDBC thin driver mode.
BTW our data source library called Druid doesn't support common JDBC Driver,
which reported transaction issues.
So, this feature seems very important for us.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: JDBC thin client load balancing and failover support
Posted by gunman524 <gu...@126.com>.
That's exactly what I expected
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: JDBC thin client load balancing and failover support
Posted by 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
Posted by 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
Posted by 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/
Re: JDBC thin client load balancing and failover support
Posted by 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/