Not getting scaled with the addition of new ignite node

Hi I am using Ignite 2.3.0, formed a cluster with 3 nodes, each node running on one server 10.144.114.113, 10.144.114.114 & 10.144.114.115 Below are the entries of the config file used on the server while starting the node Config.xml on 10.144.114.115

SQL Join not giving results

Hi I am using Ignite 2.3, cluster with 2 servers, one ignite node running on each server, using the ignite native persistence. If we see the below queries, query on a single table works fine, returns the data, but when I join the query it does not seems to be working, it says no rows

RE: Rest API not working for GET

It worked after keeping the jar in $IGNITE_HOME/libs folder. Thanks very much Regards, Naveen 91-9561721495 From: Alexey Kukushkin [mailto:kukushkinale...@gmail.com] Sent: Friday, November 24, 2017 4:57 PM To: user@ignite.apache.org Subject: Re: Rest API not working for GET Hi

RE: SQL Join not giving results

not have any option to collocate, since we d Also, how do I set setDistributedJoins(true) on sqlline.sh prompt. Regards, Naveen 91-9561721495 From: Alexey Kukushkin [mailto:kukushkinale...@gmail.com] Sent: Friday, November 24, 2017 6:30 PM To: user@ignite.apache.org Subject: Re: SQL Join

RE: SQL Join not giving results

ACCOUNT_ID_LIST | +++ +++ No rows selected (0.044 seconds) 0: jdbc:ignite:thin://127.0.0.1> Regards, Naveen 91-9561721495 From: Alexey Kukushkin [mailto

Enabling REST api for a apache client node

How do we set this in the config XML ‘-DIGNITE_REST_START_ON_CLIENT=true’, I wanted to enable REST for a client node What is the XML property Regards Naveen

Two persistent data stores for a single Ignite cluster - RDBMS and Ignite native

Native Cluster Restart preload from Ignite Native Upserts should keep going to both the data stores where as for all the queries it should use ignite native. Can we achieve this one ignite cluster with 2 backend data stores? Regards, Naveen 91-9561721495

RE: Rest API not working for GET

| PUBLIC | PERSON | TABLE | | +++++-------+

Memory foot print of the ignite nThe background cache eviction process was unable to free [10] percent of the cache for Context

HI am using 2.3 Doing PT for a service exposed thru REST Here is a node stats for cache called Customer, which has 10M and s nodes as part of the cluster, so each node is storing 3.3M odd records, which are on off-heap. Cache 'Customer(@c1)':

Re: Trying to pass memory arguments to Ignite.sh - ./bin/ignite.sh -J -Xms2g -Xmx10g -v config/IgnitePOC-NoCacheInfo.xml

1:250:56ff:feb4:237b%eno16780032] >>> Local ports: TCP:8080 TCP:10800 TCP:11211 TCP:47100 TCP:47500 [19:28:36,955][INFO][main][GridDiscoveryManager] Topology snapshot [ver=1, servers=1, clients=0, CPUs=8, heap=7.1GB] I could see heap getting reflected.. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Trying to pass memory arguments to Ignite.sh - ./bin/ignite.sh -J -Xms2g -Xmx10g -v config/IgnitePOC-NoCacheInfo.xml

): 8 >>> Heap: 1.0GB >>> VM name: 49645@JMNGD1BAQ10V03 >>> Ignite instance name: IgnitePOC Anything wrong I am doing. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Cache clear through IgniteVisor console

Hi I am using Ignite 2.3, trying to clear the cache, issued clear commands for the space which has 10M, dont anything happening, neither clearing the cache nor came out, it was in hung state. This is the command I issued cache -clear -c=Customer What could have gone wrong. Thanks naveen

Performance comparison of Primary Vs Secondary Indexes

y index. Can someone make me understand how it works. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Index not getting created

This issue got fixed after clean restart of the cluster and creating the caches again. I could create the index. Do we have any option to set the affinity mapping for the cache which is already created and holding data. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6

Affinity - Join query on the collocated data taking 90 seconds

---+ 1 row selected (94.456 seconds) 0: jdbc:ignite:thin://127.0.0.1> With collocated=true or without literally no difference in response times. How can improve the response times?? Have seen the same thread in the community on affinity on the response time, but not found any solution. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Performance comparison of Primary Vs Secondary Indexes

Hi Nikolay Can it get deteriorated further if we have more nodes in the cluster ? If so, performance of secondary index is inversely proportional to the number of nodes Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

How can we use the Discovery URL with SQLLINE which is both load balanced and Fault tolerent

. jdbc:ignite:thin://10.144.114.113:10800;10.144.114.114:10800;10.144.114.115:10800 Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity - Join query on the collocated data taking 90 seconds

|PARTY_ID| ACCOUNT_ID_LIST | ++++ ++++ No rows selected (0.022 seconds) What cou

Re: Affinity - Join query on the collocated data taking 90 seconds

Hi Attached the java code I am using. IgnitePOC-project.zip <http://apache-ignite-users.70518.x6.nabble.com/file/t1478/IgnitePOC-project.zip> Here the data load class - DataLoadAffinity. Config XML is - IgnitePOC-client.xml Please let me know if you need anything further Thanks

Count mismatch for a cache between ignitevisor & Sqlline

s issue. For other cache Customer, I could see 10M is cache size I could see properly from all. Also, where do I see the back up copies held by a node? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Memory foot print of the ignite node

86.7 30.4 134:43.12 java Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity - Join query on the collocated data taking 90 seconds

ave added Java cod for reference, if you want to reproduce the issue. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity - Join query on the collocated data taking 90 seconds

Hi Nikolai No, may be you were looking at the different config XML I am using IgnitePOC-client.xml, this is the content of this XML. Config XML does not have (not using the server XML which has AccountCache & CustomeCache Java Class name is - DataLoadAffinity.java where I am creating the cache

Re: Memory foot print of the ignite nThe background cache eviction process was unable to free [10] percent of the cache for Context

S 1.0 5.8 14:37.77 /app/JAVA_1.8/jdk1.8.0_151//bin/java -Xms1g -Xmx1g -server -XX:+AggressiveOpts -XX:MaxMetaspace+ However, data is not stored in off-heap, so how do we know the process which is holding the off-heap memory, can we see this in the top command output Thanks Naveen -- Sent

Soft copy High Performance in-memory computing with Apache Ignite Book by Michael Zheludkov, Shamim Bhuiyan, and Timur Isachenko

Hi Igniters I am planning to buy this book from Amazon, but the delivery takes 2 weeks to deliver to India. Can anyone has soft copy of this book, even its paid, I am fine to pay for the soft copy. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

IgniteVisor showing the cache, but SQLLINE tables are not seen

Hi AM using Ignite 2.3, I have created 2 caches thru Java API and could see the same thru igniteVisor, but I dont see anything SQLLINE when I execute !tables, what could be the reason. I ahev shared the config xml, and DataLoad.java used for loading the data visor> cache -e Time of the

Re: Rest API PUT command syntax

Yes, its getting stored as string, not as individual fields or properties of an object. Thanks naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Simple GETs/PUTs which one is better - Rest API, Thin , Thick OR Java API

wish you a very happy and prosperous new year to all the Igniters Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteVisor showing the cache, but SQLLINE tables are not seen

setCacheMode(CacheMode.PARTITIONED); // Default. custCacheCfg.setIndexedTypes(String.class, Customer.class); custCacheCfg.setBackups(1); what could be the issue Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SQL and backing cache question

t is to not to maintain or write POJOs for all the objects and maintain it under classpath. Does the rest API work for GET if we dont keep classes under classpath Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SQL and backing cache question

value classed, just use Ignite DDL and execute the scripts to create tables and start populating the data thru JDBC OR Java API and retrieve thru aql JDBC, Java API & Rest API.. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Cluster activation thru command line

:42962, rmtPort=42962 I could activate the cluster code thru code. Whats wrong with this command, how can I activate cluster thru command port Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Best practice while creating tables - specifying the length of the data type

t practice, do we need to specify the exact size or omitting the size completely, which one is efficient. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Simple GETs/PUTs which one is better - Rest API, Thin , Thick OR Java API

tring MAPPING_ID; private String SYNCREQUIRED; private String SYNCTO; private String ADB_SOURCE; } ** Still, no luck, I was getting teh same response, no data is returned. What could be wrong with this Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

When do we get this error - Unknown pair [platformId=0, typeId=1078091073]]

ingleGetFuture.setResult What could be the issue here Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IgniteVisor showing the cache, but SQLLINE tables are not seen

/ 34)| max: 0| max: 0| max: 0| max: 0 I am not sure, earlier I used to see caches from Sqlline as well though never set any sql sceham to the cache. what could be the reason Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Implementing security for Rest API

Hello All I am using Ignite 2.3 Planning to expose rest API for end users for doing GETs and PUTs, how can we secure the cluster, only authorized users should be able to connect to the cluster not every one. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Rest API PUT command syntax

002","landlineNo":"landlineNo2","workTelNo":"workTelNo2","primaryEmailId":"primaryEmailId2","secondaryEmailId":"secondaryEmailId2","relationshipType":"relationshipType2","relationshipFirstname":"relationshipFirstname2","relationshipMiddlename":null,"relationshipLastname":"relationshipLastname2","channel":"channel2","posAgentCode":"posAgentCode2","organizationName":"organizationName2","jobTitle":"jobTitle2","department":"department2","updateddatetime":null,"updatedby":"updatedby2","accessCode":"accessCode2","ssid":"ssid2","productOffer":"productOffer2","routingzone":"routingzone2","syncrequired":"syncrequired2","syncto":"syncto2","adbSource":"adbSource2"}} if I want to update field called custAddressIdList, how do I frame the rest URL http://10.144.114.115:8080/ignite?cmd=put=P10001=newValue=EDIF-CUSTOMER Giving the below error {"successStatus":1,"sessionToken":null,"error":"Failed to handle request: [req=CACHE_PUT, err=Failed to find mandatory parameter in request: val]","response":null} Do we have any command to update a record, does PUT always inserts a new record or it also updates the existing record with whatever the fields we pass just like a SQL update works Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Simple GETs/PUTs which one is better - Rest API, Thin , Thick OR Java API

Hello Igniters AM using 2.3 My use case is, I have around 20 tables, each of them will have around 500 to 1000 million (1 trillion) records and need to retrieve one to 5 records at a time and insert one to 5 records at one go. Which approach works better for this requirement REST API Thin

Rest API GET command syntax with a composite primary key

Hi Am using 2.3 What is the GET syntax for REST API for a cache which has a composite key. I have a cache which has a composite key - consisting of 2 columns Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Does Merge statement (DML) work with JDBC client driver

and accordingly we can use. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Usage of DataStreamer for bulk loading

the code. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Affinity Key column to be always part of the Primary Key

need to use PartyID as part of Account table primary key. Can someone answer this please? Thanks Naveen Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Usage of DataStreamer for bulk loading

Thanks Alexey. We are in the middle of the development, we may go live in next 3 to 4 months. If we are done with Copy command by then, we are good. When are we going to release 2.5 ?? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity Key column to be always part of the Primary Key

Customer P, Account A where P.PARTY_ID= A.PARTY_ID and A.PARTY_ID IN ('P1', 'P2'); How can we make use of Affinity to collocate CUSTOMER and ACCOUNT data in this case. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Error while Ignite integration with Tableau

[springUrl=file:/D:/Naveen/Ignite/apache-ignite-fabric-2.3.0-bin/config/default-config.xml, err=Error creating bean with name 'ignite.cfg' defined in URL [file:/D:/Naveen/Ignite/apache-ignite-fabric-2.3.0-bin/config/default-config.xml]: Cannot create inner bean

DDL should work without prefixing the schema

,'upd5','5','5') I tried to change the schema to PUBLIC by setSchemaName, but still does not seem to be working. I would like to have same DML query should work for the table created thru SQL DDL and Java API without schema. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity Key column to be always part of the Primary Key

ing to explain, is affinity key to be part of the primary key ?? If this is the case, whole my data model will change drastically. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Data Recovery after cluster restart

10.144.114.115:47500..47502 ----- Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity Key column to be always part of the Primary Key

Do we have any update on this clarification regarding the affinity Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Usage of DataStreamer for bulk loading

); streamer.addData(tokens[0], aASSOCIATED_PARTIES); } As you mentioned, I have made sure that one DataStreamer for each client, after this change, it stopped failing. Any ways we can improve this performance. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How to configure a cluster as a persistent, replicated SQL database

this for native ignite persistence, what do I need to add for using Oracle as persistent layer Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6

RE: Does Merge statement (DML) work with JDBC client driver

version of code base for native persistence? At the moment, since I am using native persistent, I just created tables thru JDBC and doing all the writes and reads also thru JDBC, so I have not developed any POJO for any of the tables. Is my understanding correct ? Thanks Naveen -- Sent from: http

Re: How to configure a cluster as a persistent, replicated SQL database

Hi Jose Did it work for you ? I had the same question. I wanted to use JDBC client driver to connect to Ignite cluster. I am trying to use Java Would you be able ot share the code snippet if you are using java to connect to the ignite cluster thru JDBC client driver Thanks Naveen -- Sent

Usage of DataStreamer for bulk loading

y line thats read from the file. It should be called for lets say every 1000 records once, start accumulating all the 1000 records and add it to cache 1000 records in batch. How could we do this, batch wise or time wise, like every minute it should write. Thanks Naveen -- Sent from: http

RE: Is backup copy always stored on different host - is ithost-awarereplication

How do I use this template while creating the cache, what is the property I should set Thanks Naveen -- Sent from: http://apache-ignite-users

Delete SQL is failing with IN clause for a table which has composite key

typeByValue(GridQueryProcessor.java:1901) at org.apache.ignite.internal.processors.query.GridQueryProcessor.validateKeyAndValue(GridQueryProcessor.java:2755) at org.apache.ignite.internal.processors.cache.GridCacheContext.validateKeyAndValue(GridCacheContext.java:1829) ... 20 more Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Sql query problem using IN clause

AND ((__Z0.ENTITY_ID = '12345') AND (__Z0.RELATIONSHIP = 'OutageID_ServiceIDs')) Any suggestions on this. Thanks naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Delete SQL is failing with IN clause for a table which has composite key

Hi These are the queries I have used, which I was getting the error every time I execute. Nothing else to share Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Cache.clear() is not clearing the data in DB when both native as well as 3rd Party persistence is used

and JDBC APi are reflecting on both cache and DB. Am i missing something here or its a known issue, OR we do need to clear entries in DB manually ?? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

How to start Ignite with a jar built from the source code

Hi Am using 2.4 I would like to build jar from source code downloaded from Apache and use jar to start the Ignite node, do we have any documentation on this on how to pass the config XML etc.. Thanks Naven -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Running heavy queries on Ignite cluster on backing store directly without impacting the cluster

records in some of the tables, for some reason unknowingly runs query on those tables, it should not bring down the cluster abtruptly Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How to start Ignite with a jar built from the source code

in building the jar from source and how do I run ignite server node with jar Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Running heavy queries on Ignite cluster on backing store directly without impacting the cluster

cluster ?? Hope you understood my requirement ? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Error: class org.apache.ignite.IgniteException: Ignite instance with this name has already been started: igniteDual

for dual backing store - native and Oracle, which is failing in this case. Thanks naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Running heavy queries on Ignite cluster on backing store directly without impacting the cluster

also. How can we avoid this, it should run on backing store, I am fine if thge query exection takes longer time, but cluster should not get crashed. Hope I conveyed my requirements more clear this time. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Running heavy queries on Ignite cluster on backing store directly without impacting the cluster

on backing store, it may not have any impact on RAM from where we always do GETs, will that work? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

One time replicating of the cluster data for setting up a new cluster

Hi Am using 2.3 I do have one cluster running with 3 servers, each with 2 nodes. Now we need to replicate this data on a new cluster which is going to have the same configuration. Just copying node folders enough to get the data ? Whats the best practice for doing this Thanks Naveen

Re: Running heavy queries on Ignite cluster on backing store directly without impacting the cluster

is utilized upto 60 to 70%, however CPU resources are not utilized. Hope I was able to convey my adhoc requirements to run various SQL queries to debug data related issues and consequences of these queries on the performance on the cluster Thanks Naveen -- Sent from: http://apache-ignite-users

RE: How to configure a cluster as a persistent, replicated SQLdatabase

,'maplist6','rel5',sysdate,'upd5','5','5'); Because of this, I had to change my existing Oracle DMLs to make it work with Ignite. I believe I tried to change the schema to PUBLIC by explicitly setting the schema while creating the cache, but still no luck, Any suggestions for this, Tha

New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

Hi Looks like dual persistence - 3rd party (Oracle) and native persistence - both are supported "*Starting with Apache Ignite 2.4, 3rd party persistence can be used together with native persistence*" Can someone explain how this is going to work, how do we config this. Tha

Re: New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

. In case of eviction, where do we specify from which persistence it should get the data if its not in RAM. Could you please provide little more insight on this feature. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Affinity Key column to be always part of the Primary Key

of composite primary key. Regards Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: Is backup copy always stored on different host - is it host-awarereplication

_type=com.ril.edif.model.MAP_ASSOCIATED"; So how do I specify the cacheConfiguration.setAffinity(new RendezvousAffinityFunction(true)) Objective is to keep the backup on different host Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

and load it to RAM, however if we update any column in DB which is not reflecting in RAM. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Error: class org.apache.ignite.IgniteException: Ignite instance with this name has already been started: igniteDual

tance with this name has already been started: igniteDual" How can i use unique name for every client, when I omit the instance name also its throwing error saying the default instance is already connected. Thanks Naveen igniteDual-client.xml <http://apache-ignite-users.70518.x6.nabble.com/fi

Any references - Syncing Ignite and Oracle DB with Oracle GoldenGate - updates from DB to ignite

this solution ? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

Thanks Denis. I did go thru the link, so the full details are not furnished. Can this be achieved with Ignite (out of the box) with Oracle GoldenGate tool with minot changes / configuration on ignite cluster. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Error: class org.apache.ignite.IgniteException: Ignite instance with this name has already been started: igniteDual

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

Is backup copy always stored on different host - is it host-aware replication

, but on different node. Is it host-aware replication ?? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Cache stats like number of cache hits, misses, reads, write, avg

Hi We are using Ignite 2.5/2.6 Have enables stats collection by setting this property Created cache, and ran some Gets on it, and when we check stats thru visor, we dont see any stats for read cache -c=CustomerCache -a All the columns like Hits, Writes, Reads are showing as zero, is there

Re: Cache stats like number of cache hits, misses, reads, write, avg

I guess I was doing the same. Only change I could see is, you were enabling setMetrcis for both regionCfg and storageCng regionCfg.setMetricsEnabled(true); // Setting the data region configuration. storageCfg.setDataRegionConfigurations(regionCfg);

Re: Cache stats like number of cache hits, misses, reads, write, avg

HI Andrei It worked after enabling metrics at both egionCfg and storageCfg and also enabling cacheMetrics for the cache. Stats are getting captured when we insert it thru cache.Put/putall , not getting captured the data inserted thru datastreamer | CustomerCharsCache(@c11)|

Re: Long activation times with Ignite persistence enabled

Do we have any update long activation times ? I too face the same issue, am using 2.6. Cluster with 100 GB of disk size, got activated in 5 minutes, and when I tried with a cluster which has 3 TB is taking close to an hour. Is it the expected behavior OR some configuration I am missing here

Re: Long activation times with Ignite persistence enabled

thread pools, can we reduce the cluster activation time. System Pool Public Pool Striped Pool Custom Thread Pools Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Long activation times with Ignite persistence enabled

do we group them 4. Some of the caches are independent , does not have any relation with other caches So in case, I am going with cache group, shall I change the partition to 128 or keep the default ? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ways to improve re-balancing of partitions and how to monitor re-balance progress

-balanced only in RAM and RAM updates not getting reflected on DISK ?? Is there any better ways to monitor progress of re-balancing activity ? And, also ways to speed up re-balance provided we have enough system resources Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ways to improve re-balancing of partitions and how to monitor re-balance progress

Add to above I also see below, completed rebalancing and cancelled rebalancing logs after any client joins connects to the cluster. Is it normal behavior of re balance [2018-11-08T20:06:36,936][INFO ][disco-event-worker-#341%EDIFCustomer%][GridDiscoveryManager] ^-- Node

Re: Ways to improve re-balancing of partitions and how to monitor re-balance progress

Has any one got anything to say on this. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Long activation times with Ignite persistence enabled

, Ignite node used to use 250GB odd. Now after removing AlwaysPreTouch, ignite node use only 50G (around). Other than, activation time remains same with or without AlwaysPreTouch. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Long activation times with Ignite persistence enabled

effect on the cluster performance ?? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Long activation times with Ignite persistence enabled

Do we have any update on this Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ways to improve cluster activation time

are going to have close to half a billion records in each cache, so how do we group them 4. Some of the caches are independent , does not have any relation with other caches So in case, I am going with cache group, shall I change the partition to 128 or keep the default ? Thanks Naveen -- Sent

Re: Long activation times with Ignite persistence enabled

cache, so how do we group them 4. Some of the caches are independent , does not have any relation with other caches So in case, I am going with cache group, shall I change the partition to 128 or keep the default ? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ways to improve cluster activation time

We can ignore this as there was already another ticket on the same issue -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ignite questions

with read from RAM, by default it does not pre-load the data. If you want to avoid this you can pre-load the data programatically and load Memory, good for even SQL SELECT as well. But with the 3rd party persistence, we need to pre-load the data to make your read work for SQL SELECT. Thanks Naveen

Effective way to pre-load data around 10 TB

fast in very less time ? OR any other better ways of achieving the same Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: Effective way to pre-load data around 10 TB

M, HDD, our CPU utilization is also not so high when we are preloading the data. Changing thread pool size will have any impact this read ??? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite performance is getting dipped by 50% when run both upserts and query services are run together

are using backup=1 and enabled persistence. Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite performance is getting dipped by 50% when run both upserts and query services are run together

These are settings we have maxSize=#{80L * 1024 * 1024 * 1024} checkpointPageBufferSize=#{8L * 1024 * 1024 * 1024} pageSize=#{4 * 1024} Any clues we have for this dip in TPS Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

  1   2   >