|
Home > Archive > Commerce Server General > August 2006 > Downtime with Commerce Server Staging?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Downtime with Commerce Server Staging?
|
|
| Pascal 2006-08-03, 7:23 pm |
| Hi,
Anyone aware of possible downtime in a production system when using the
Commerce Server Staging to copy catalog from a staging area to a production.
What happens if someone request a product that is not in the cache while the
catalog table is getting copied/transferred? I assume the request is somehow
queued/locked until the job is done but wanted to know if anybody knew for
sure. My assumption is the process is transacted so there should be much of
an impact or wait but wanted to confirm.
Pascal
| |
| Esra Onalan [MSFT] 2006-08-05, 1:24 am |
| Hi Pascal,
Staging should not interrupt site availability as business data types are
non transactional by default.
However if you are using transactional mode of catalog import this could
affect the availability of your site as all the products in the catalog
will be transacted as a whole. In general, you should be using incremental
mode of catalog staging once a full import is done for better performance.
Thanks
Esra Onalan
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2006 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: Downtime with Commerce Server Staging?
thread-index: Aca3HUiWnfJ54+yhR4e9H6P+gn9dEA==
X-WBNR-Posting-Host: 206.108.58.39
From: =?Utf-8?B?UGFzY2Fs?= <Pascal@discussions.microsoft.com>
Subject: Downtime with Commerce Server Staging?
Date: Thu, 3 Aug 2006 09:53:02 -0700
Lines: 11
Message-ID: <A935F37F-ACDF-4C65-9A45-0456C07587E0@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18086
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
Anyone aware of possible downtime in a production system when using the
Commerce Server Staging to copy catalog from a staging area to a
production.
What happens if someone request a product that is not in the cache while
the
catalog table is getting copied/transferred? I assume the request is
somehow
queued/locked until the job is done but wanted to know if anybody knew for
sure. My assumption is the process is transacted so there should be much of
an impact or wait but wanted to confirm.
Pascal
| |
| Pascal 2006-08-05, 1:24 am |
| In a high traffic site where there is virtually little or no "low traffic
hour", there is no possible concurrency issues? When the catalog is
transferred from Staging to Production, does the Staging component locks the
product table or do something to prevent a read while the catalog data is
written? This might be low level question but I am dealing with a customer
with a strong technical team.
Pascal
"Esra Onalan [MSFT]" wrote:
> Hi Pascal,
>
> Staging should not interrupt site availability as business data types are
> non transactional by default.
> However if you are using transactional mode of catalog import this could
> affect the availability of your site as all the products in the catalog
> will be transacted as a whole. In general, you should be using incremental
> mode of catalog staging once a full import is done for better performance.
>
> Thanks
> Esra Onalan
> Microsoft
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2006 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> --------------------
> Thread-Topic: Downtime with Commerce Server Staging?
> thread-index: Aca3HUiWnfJ54+yhR4e9H6P+gn9dEA==
> X-WBNR-Posting-Host: 206.108.58.39
> From: =?Utf-8?B?UGFzY2Fs?= <Pascal@discussions.microsoft.com>
> Subject: Downtime with Commerce Server Staging?
> Date: Thu, 3 Aug 2006 09:53:02 -0700
> Lines: 11
> Message-ID: <A935F37F-ACDF-4C65-9A45-0456C07587E0@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18086
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
> Anyone aware of possible downtime in a production system when using the
> Commerce Server Staging to copy catalog from a staging area to a
> production.
> What happens if someone request a product that is not in the cache while
> the
> catalog table is getting copied/transferred? I assume the request is
> somehow
> queued/locked until the job is done but wanted to know if anybody knew for
> sure. My assumption is the process is transacted so there should be much of
> an impact or wait but wanted to confirm.
>
> Pascal
>
>
| |
| Esra Onalan [MSFT] 2006-08-10, 7:27 am |
| Hi Pascal,
The answer to your question is yes, if Transactional Catalog Staging option
is specified for a business data project involving Catalog business data.
Then staging will perform the import operation under a transaction. This
will cause locking of the relevant data until the transaction commits or
aborts. During the transaction concurrent reads of the affected data would
block.
Thanks
Esra Onalan
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2006 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: Downtime with Commerce Server Staging?
thread-index: Aca3+OOIAU7Gm5PTTeK7jrNtXu1Bzg==
X-WBNR-Posting-Host: 206.108.58.39
From: =?Utf-8?B?UGFzY2Fs?= <Pascal@discussions.microsoft.com>
References: <A935F37F-ACDF-4C65-9A45-0456C07587E0@microsoft.com>
<XcVwwG$tGHA.3920@TK2MSFTNGXA01.phx.gbl>
Subject: RE: Downtime with Commerce Server Staging?
Date: Fri, 4 Aug 2006 12:05:02 -0700
Lines: 69
Message-ID: <176C9176-B24C-4B36-B3B5-8AFF764FB4AC@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18095
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
In a high traffic site where there is virtually little or no "low traffic
hour", there is no possible concurrency issues? When the catalog is
transferred from Staging to Production, does the Staging component locks
the
product table or do something to prevent a read while the catalog data is
written? This might be low level question but I am dealing with a customer
with a strong technical team.
Pascal
"Esra Onalan [MSFT]" wrote:
> Hi Pascal,
>
> Staging should not interrupt site availability as business data types are
> non transactional by default.
> However if you are using transactional mode of catalog import this could
> affect the availability of your site as all the products in the catalog
> will be transacted as a whole. In general, you should be using
incremental
> mode of catalog staging once a full import is done for better performance.
>
> Thanks
> Esra Onalan
> Microsoft
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2006 Microsoft Corporation. All
rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> --------------------
> Thread-Topic: Downtime with Commerce Server Staging?
> thread-index: Aca3HUiWnfJ54+yhR4e9H6P+gn9dEA==
> X-WBNR-Posting-Host: 206.108.58.39
> From: =?Utf-8?B?UGFzY2Fs?= <Pascal@discussions.microsoft.com>
> Subject: Downtime with Commerce Server Staging?
> Date: Thu, 3 Aug 2006 09:53:02 -0700
> Lines: 11
> Message-ID: <A935F37F-ACDF-4C65-9A45-0456C07587E0@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18086
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
> Anyone aware of possible downtime in a production system when using the
> Commerce Server Staging to copy catalog from a staging area to a
> production.
> What happens if someone request a product that is not in the cache while
> the
> catalog table is getting copied/transferred? I assume the request is
> somehow
> queued/locked until the job is done but wanted to know if anybody knew
for
> sure. My assumption is the process is transacted so there should be much
of
> an impact or wait but wanted to confirm.
>
> Pascal
>
>
|
|
|
|
|