Re: JDBC thin client load balancing and failover support

2018-01-09 Thread Denis Magda
> 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

Re: JDBC thin client load balancing and failover support

2018-01-09 Thread rizal123
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

Re: JDBC thin client load balancing and failover support

2018-01-09 Thread Denis Magda
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 wrote:

Re: JDBC thin client load balancing and failover support

2018-01-08 Thread rizal123
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-u

Re: JDBC thin client load balancing and failover support

2017-11-28 Thread blackfield
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

2017-11-27 Thread Aurora
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

Re: JDBC thin client load balancing and failover support

2017-11-27 Thread gunman524
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

2017-11-27 Thread vkulichenko
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/bro

JDBC thin client load balancing and failover

2017-11-27 Thread blackfield
It appears Ignite has load balancing support for its compute grid but not for data grid. As in, the JDBC thin client does not have load balancing and failover support. If JIRA for it does not exist yet, can we create a JIRA for Ignite JDBC thin client to provide load balancing and failover suppor