Re: How to execute an sql on a specific remote server?

2019-09-11 Thread Ilya Kasnacheev
Hello! You can set `local=true` to execute completely local requests, and you can connect your JDBC to NX with this option. Regards, -- Ilya Kasnacheev вс, 8 сент. 2019 г. в 20:44, livelace : > Hi, Andrew. I found this topic in Google. > > I have a case where: > > 1. I have two nodes (all cac

Re: How to execute an sql on a specific remote server?

2019-09-08 Thread livelace
Hi, Andrew. I found this topic in Google. I have a case where: 1. I have two nodes (all caches are replicated) N1 and N2, NX is a client node . 2. N2 fills with small portions of data (relatively frequent). 3. N2 has relatively small RAM and CPU. 4. N1 has huge volume of RAM and many CPU cores. 5

Re: How to execute an sql on a specific remote server?

2018-06-05 Thread Andrey Mashenkov
Hi, What are you trying to achieve? What is cache mode? For REPLICATED cache, your query will be sent to and executed on one random node. 1. You can sent a compute job [1] to certain node (via ignite.compute(ignite.cluster().forNode(...)).execute(task)) or affinity job [2] (ignite.compute().aff

How to execute an sql on a specific remote server?

2018-06-05 Thread Shravya Nethula
Hi, I am trying to execute the following select query using the native java client on a cluster of 2 nodes. String query = "select * from Person"; List> results = superCache.query(new SqlFieldsQuery(query)).getAll(); Now, is any there way to execute the same query on only one specific remote nod