Networks

Ask something
Discussion Locked

Possible mirroring!

0 helpful
2 replies

by whatme? 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Looking for a solution to Web site-database mirroring? 5 geographic sites w/ wan connectivity but slow. I was looking at 3rd party software to "mirror" my web site and a "cached" version of our database. Has anyone done this successfully nad or what softawre? I am wondering about simply inserting the website "folder" in a DFS folder. The web folder ad cached database folder is in one folder. There probably is a better way to go but I was wondering if anyone has tried this yet?
Our reason. 5 sites..... very slow links. Each site is OK to work on their own for several hours.
This is a W3k AD single domain private farme relay sites.

2 replies

by mshavrov

Do your websites have read-only access to the database, or they need to write something back? If you have read-only access, you may just stop your SQL database once in a while, and copy your "master" database to your "backup sites". However if your data changes a lot, and you need to have a fresh copy on every website, it may be time and bandwidth consuming.

As I understand, you are using W3K with IIS, and I assume you use Microsoft SQL server. You may use the Microsoft SQL server internal functionality to create "Subscription" from your "backup sites" to your "master site". If you have read-only data, you may create one-way synchronization, and if you have to write something back, you may create two-ways synchronization between your master database and subscribers. Synchronization could be set up as a scheduled update, and will transmt only changes.

Hope this helps,

Mike
MCSE W2K, MCSE+I, MCDBA, Security+, CCNP, CCDP, CCSP, etc.
http://www.3comheadsetadapter.com

by whatme?

Subscriptions on another SQL server is OK, but what is more important I feel is the Web server. I was hoping a user could access a local web server so web site mirroring was more important.

This discussion is closed to new replies.