Re: code sample for cluster configuration

2018-02-07 Thread Vinokurov Pavel
Hi Rajesh, There is a good sample with enabled persistance - https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/persistentstore/PersistentStoreExample.java Also documentation about Ignite persistance presented in https://apacheignite.readme.io/docs/dist

Re: code sample for cluster configuration

2018-02-07 Thread Vinokurov Pavel
rting the data. > Would just setting Ignition.setClientMode(true) is enough for this > usecase, would my application to push the data to one of the portioned > cluster server ? > > Thanks, > Rajesh > > On Wed, Feb 7, 2018 at 8:43 PM, Vinokurov Pavel > wrote: > &g

Re: continuous query - changes from local server only

2018-02-08 Thread Vinokurov Pavel
Som, You could create the continuous query on each client node with the filter described above. 2018-02-08 19:55 GMT+03:00 Som Som <2av10...@gmail.com>: > i've got both client and server nodes on each of 3 physical servers, that > is my cluster. there is a partitioned cache, each server node sto

Re: Loading cache from Oracle Table

2018-02-09 Thread Vinokurov Pavel
Hi Prasad, Within your implementation of CacheStore.loadCacheYou you could use multiple threads to retrieve rows by batches. Note that each thread should use different jdbc connection. 2018-02-09 13:57 GMT+03:00 Prasad Bhalerao : > Hi, > > I have multiple oracle tables with more 50 million rows.

Re: Ignite with Spring Cache on K8S, eviction problem

2018-02-11 Thread Vinokurov Pavel
Spring creates a composite key that might be not suitable for the distributed Ignite cache. You could use the custom composite key using concatenation #user+ " - "+#id. 2018-02-09 17:50 GMT+03:00 lukaszbyjos : > Hi. I have k8s cluster with one ignite server and few services as clients. > I have

Re: Timeout while running checkpoint

2018-02-11 Thread Vinokurov Pavel
Hi, The timeout could be caused by value PersistentStoreConfiguration#checkpointFreq parameter. Have you overrided *checkpointFreq* config parameter? 2018-02-12 10:05 GMT+03:00 Josephine Barboza : > Hi, > > I’m constantly seeing a lot of information logs after setting up a cluster > in ignite of

Re: Add ignite jars using maven

2018-02-11 Thread Vinokurov Pavel
I think the right way is to add dependencies into the pom file. 2018-02-12 10:37 GMT+03:00 Rajarshi Pain : > Hi, > > > Previously i was manually adding all the jars to my build path, now i am > using maven to do this. Is there any way to add all ignite jars with it's > dependency in to the projec

Re: Timeout while running checkpoint

2018-02-12 Thread Vinokurov Pavel
How often the "Skipping checkpoint" message occurred in logs? 2018-02-12 10:47 GMT+03:00 Josephine Barboza : > No I haven’t overridden checkpointFreq value. > > > > *From:* Vinokurov Pavel [mailto:vinokurov.pa...@gmail.com] > *Sent:* Monday, February 1

Re: Timeout while running checkpoint

2018-02-12 Thread Vinokurov Pavel
checkpoint-thread-#33%nvIDNSGN7CR%] INFO > GridCacheDatabaseSharedManager:463 - Skipping checkpoint (no pages were > modified) [checkpointLockWait=0ms, checkpointLockHoldTime=2ms, > reason='timeout'] > > > > > > *From:* Vinokurov Pavel [mailto:vinokuro

Re: Ignite with Spring Cache on K8S, eviction problem

2018-02-19 Thread Vinokurov Pavel
Could you show service methods with cache annotations. 2018-02-19 17:19 GMT+03:00 lukaszbyjos : > I still have a problem with evicting one cache. What's recommended setting > for partitioned cache? > From service B I want to evict "ch-current" cache but service A still see > old values. > At the

Re: Performance of Ignite integrating with PostgreSQL

2018-03-14 Thread Vinokurov Pavel
Hi, You could try to use igniteCache.putAll for write batches by 1000 entries. Use following script in PostgresDBStore#writeAll method to put data into the database: String sqlString = "INSERT INTO test(val) VALUES (:val1)(:val2)(:val3);"; 2018-03-14 11:58 GMT+03:00 : > Hi, > > I try to use Ig

Re: ContinuousQuery - SqlFieldsQuery as InitialQuery

2018-03-20 Thread Vinokurov Pavel
Hello! At the compilation time it is impossible to know result type of the SqlFieldsQuery. So you can try following: ((ContinuousQuery)q).setInitialQuery(new SqlFieldsQuery("select _val from table")); Thanks, Pavel 2018-03-20 20:43 GMT+03:00 au.fp2018 : > Hello All, > > I'm trying to setup a Co

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
+ "(:val51),(:val52),(:val53),(: > val54),(:val55),(:val56),(:val57),(:val58),(:val59),(:val60)," > >+ "(:val61),(:val62),(:val63),(: > val64),(:val65),(:val66),(:val67),(:val68),(:val69),(:val70)," > >+ "(:val71),(:val7

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
You already showed the cache configuration, but could you show jdbc connection initialization 2018-03-22 7:59 GMT+03:00 Vinokurov Pavel : > Hi, > > Could you please show the "PATH/example-cache.xml" file. > > 2018-03-21 9:40 GMT+03:00 : > >> Hi Vinokurov,

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
>> IgniteCache igniteCache = ignite.getOrCreateCache("testCache "); please, change to ignite.cache("testCache") to be sure the we use configuration from the file. 2018-03-22 8:19 GMT+03:00 Vinokurov Pavel : > You already showed the cache configuration, but cou

Re: Performance of Ignite integrating with PostgreSQL

2018-03-21 Thread Vinokurov Pavel
Also it makes sense to use new 2.4 version. 2018-03-22 8:37 GMT+03:00 Vinokurov Pavel : > >> IgniteCache igniteCache = ignite.getOrCreateCache(" > testCache "); > please, change to ignite.cache("testCache") to be sure the we use > configuration from t