[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-4977 at 7/11/17 8:30 AM:
-------------------------------------------------------------
Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good.
Also tested scaling JDG down to zero and restarting, multiple times. Materialization restarted, as expected, and querying continued without having to reconnect.
was (Author: van.halbert):
Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan, Quick Starts
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4977:
------------------------------------
Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4977:
-------------------------------
Component/s: Quick Starts
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan, Quick Starts
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4977:
-------------------------------
Fix Version/s: 8.12.x-6.4
9.3.2
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4977:
------------------------------------
Regarding the 'renaming' process, when the cache names are swapped, the 'ST' cache is cleared. Immediately reducing the total memory footprint in JDG/infinispan.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-4977 at 7/11/17 7:59 AM:
-------------------------------------------------------------
Format for -vdb.xml for the BEFORE and AFTER:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{ST}'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{ST} {modelName}.{MV}'');',
{code}
Example:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.ST_StockCache StockJDGSource.StockCache'');',
{code}
was (Author: van.halbert):
Format for -vdb.xml for the BEFORE and AFTER:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{stagingCacheName}'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{materializedCacheName} {modelName}.{stagingCacheName}'');',
{code}
Example:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.StockCache StockJDGSource.ST_StockCache'');',
{code}
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-4977 at 7/11/17 7:57 AM:
-------------------------------------------------------------
The issue was resolved by change JDG to use the clustered configuration with the following caches:
{code}
<replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/>
<distributed-cache name="stockCache" />
<distributed-cache name="st_stockCache" />
{code}
Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered.
was (Author: van.halbert):
The issue was resolved by change JDG to use the clustered configuration with the following caches:
{code}
<replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/>
<distributed-cache name="memcachedCache"/>
<distributed-cache name="stockCache" />
<distributed-cache name="st_stockCache" />
{code}
Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4977:
------------------------------------
Format for -vdb.xml for the BEFORE and AFTER:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{stagingCacheName}'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{materializedCacheName} {modelName}.{stagingCacheName}'');',
{code}
Example:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.StockCache StockJDGSource.ST_StockCache'');',
{code}
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4977:
------------------------------------
The issue was resolved by change JDG to use the clustered configuration with the following caches:
{code}
<replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/>
<distributed-cache name="memcachedCache"/>
<distributed-cache name="stockCache" />
<distributed-cache name="st_stockCache" />
{code}
Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months