Various posts have noted that mirroring over distance is not advisable or that either async connections should be used.
Are there any limits/recommendations i.e. if two datacenters are a couple of files part with 10GBs fibre links and <50ms response times would this be acceptable for high-availability mirroring?
Hi Andrew,
I think you have good network links.
The best thing to do is to test it in synchronous mode first. See what the performance is like.
If the performance is not acceptable, you can then switch the safety off.
Please note that Wtiness server should not be used when running with safety off option.
cheers
Jag
|||Andrew,
Please include re-indexing and large bulk inserts in your testing as well.
cheers
Jag
|||jag,
Thanks for the response, although I think I will need to look at another solution as mirroring has a very small limit on the number of Databases that can be mirrored (10 recommended, people maxing out at 60) and with a large SharePoint installation the number of content databases can exceed these limits relatively quickly.
Options: More SQL servers (x2 to mirror) or use Clustering in live datacenter with Log Shipping to redundant center.
Andrew
No comments:
Post a Comment