Hi Please Help,

We have configured Asynchfullpage database mirroring. Our database Prod "Hang" when error network "packet loss" and automatically normal again when network normal or network truly disconnect. Our production application that connect to database prod will DOWN when 2 minutes didn't get reply from database production.

Ask : 1. Why asynchfullpage mirroring depend on network status from dc to drc ? 2. How to configure so when error network "packet loss" database Prod not temporary "hang" ?

Thanks For Your Help

asked 17 May '17, 05:06

ekohariono's gravatar image

ekohariono
41335
accept rate: 0%

FWIW, you may link to your older question in case that is a follow-up...

(17 May '17, 05:47) Volker Barth
Replies hidden

This is the old question.

(18 May '17, 03:09) Vlad

In a database mirroring configuration the primary database must ship the transaction log to the secondary over the network TCP/IP link. In an asyncfullpage configuration the primary will ship the transaction log page to the secondary and normally not wait for a response before proceeding. BUT in both async modes the primary will periodically send a special request to the secondary and wait for a response to ensure that the secondary is not getting too far behind (read more details in my answer to your previous question). I am suspecting that the "hang" that you are seeing is caused by the primary waiting for this ACK.

You did not mention which version you are using. Some changes were made in recent versions of SQLA 17 that changes when this handshake between the primary and secondary (e.g. addition of a 'lagtime' option). These changes may help?

If your network is experience a high rate of packet loss then I would recommend that you spend your effort making improvements to your network! There is no SQLA mirroring configuration that will work well in a high-package-loss network. If you cannot fix your network then perhaps you should investigate using a different method of moving transactions to a secondary server: live backup and mobilink are two such methods.

HTH

Note: Mary's answer to your previous question provides some details on configuring your mirror system.

permanent link

answered 17 May '17, 08:52

Mark%20Culp's gravatar image

Mark Culp
24.9k10139297
accept rate: 41%

edited 17 May '17, 09:01

Hi Mark,

Thanks for your answer, we use sql anywhere 16 standard edition.

(18 May '17, 00:08) ekohariono
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×32

question asked: 17 May '17, 05:06

question was seen: 1,588 times

last updated: 18 May '17, 03:09